[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