[thelist] SQL syntax

Joel Lieberman joel_lieberman at yahoo.com
Sat Feb 2 11:16:01 CST 2002


I've been watching from the side-lines and I have to
agree -  Rudy is a real Prince!  Thanks for your
excellent advice from those of us who quietly listen.

Joel Lieberman
--- Susan Wallace <susanhw at webcastle.com> wrote:
> Once again rudy, you RULE!
>
> That works like a charm! Thank you VERY much!
>
> I copied/pasted this into the SQL "window" in
> Enterprise Manager, checked
> syntax, it was Ok, so I ran it and all of the
> records that I needed came up.
>
> <snip>
> >     where
> convert(char(10),dbo.Member_Info.ExpDate,102) =
> >          convert(char(10),
> >        convert( datetime,
> >        dateadd( day, -datepart(day,getdate()),
> dateadd(month,1,getdate()) )
> >                     ) , 102)
>
> Also, thank you for the explanation - that all makes
> sense, even to my
> over-tired brain. :)
>
> Susan
> <tip type="Frustration Point">
> If you have been staring at a problem for many
> hours, searching the web,
> and just not "getting it", post a message to this
> list and take a break.
> When you come back, there will most likely be at
> least one response that
> will get you restarted in the right direction. And
> if you are working on
> SQL syntax, rudy will be kind enough to take time
> out of his day to give
> you the *exact piece of information* that you
> needed. ;-)
> </tip>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com



More information about the thelist mailing list