Viewing 15 posts - 33,676 through 33,690 (of 59,102 total)
CELKO (6/14/2011)
... avoid needless dialect ...
I'm very much in favor of that idea. You should try it sometime.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 6:40 pm
... and please don't be so pompous to label your post as "Seniors Only". You might just talk a couple of us seniors out of helping with an attitude...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 6:35 pm
Elliott Whitlow (6/14/2011)
I've reviewed that code and as I read it, you have to take advantage of a hack that allows you to use xp_regwrite as a non-privileged user coupled...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 3:36 pm
berzat.museski (6/14/2011)
Jeff, I must tell you that your solution is briliant as well!
Thanks for the compliment but, nah... I just used a variation of what is in the article. :-)...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 10:11 am
Gatekeeper (6/14/2011)
Alexey Voronin (6/14/2011)
What's this COALESCE(SUM(SalesTestData.SaleQty),0) ?You do not know ISNULL ?
ISNULL(SUM(SalesTestData.SaleQty),0)
They are interchangeable. Both are the same thing except COALESCE() allows for more than one evaluation.
Actually, they're not interchangeable...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 10:06 am
GSquared (6/14/2011)
"Grand Master at command line use," isn't likely to land a job.
Heh... I agree. For most, it won't. For me, it was a different story... a similar...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 10:00 am
Thomas LeBlanc (6/14/2011)
3rd party backup softwareThomas
I just love short, sweet, and accurate. Thanks, Thomas. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 9:56 am
Shawn Melton (6/14/2011)
Jeff Moden (6/13/2011)
Shawn Melton (6/13/2011)
SQLCMD is used mostly locally on the server
Thanks again, Shawn. The real question is "How is SQLCMD being called?" Are you calling...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 9:56 am
I knew I shouldn't have posted this on a Friday night. 😛 You good folks sure did come alive on Monday. Thank all of you a huge amount.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2011 at 6:44 am
tfifield (6/13/2011)
Jeff Moden (6/12/2011)
allmhuran (6/12/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2011 at 10:51 pm
AmolNaik (6/13/2011)
An alternate method to remove duplicates is to...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2011 at 10:13 pm
berzat.museski (6/13/2011)
However, I agree that GetNums is a cool trick to...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2011 at 10:09 pm
harry9katz (6/13/2011)
You have to add hour to both tables
SELECT cast(floor(cast(SaleTime as float)) as datetime)Saledate,DATEPART(hour,SaleTime) saleshour
,sum([SaleQty]) sumsales
into #salessum
...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2011 at 6:35 pm
DavidBridgeTechnology.com (6/13/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2011 at 6:19 pm
Shawn Melton (6/13/2011)
SQLCMD is used mostly locally on the server
Thanks again, Shawn. The real question is "How is SQLCMD being called?" Are you calling it through a job...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2011 at 3:51 pm
Viewing 15 posts - 33,676 through 33,690 (of 59,102 total)