Viewing 15 posts - 32,071 through 32,085 (of 59,102 total)
Heh... Ron beat me to it while I wasn't looking. 😛
While I'm here, pivoting phone numbers like this is quite contrary to what databases are all about. It might...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 10:40 pm
To do this, you need a "splitter" function and you need to learn how to do dynamic Cross Tabs. Here are two instructional articles that will help on that....
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 10:38 pm
Lexa (11/1/2011)
When are the CTEs used best? Is it true that procs that are called thousands of times a minute and store less than 100K of records are best...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 10:32 pm
Brian Ki (11/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 10:09 pm
Dev @ +91 973 913 6683 (10/20/2011)
That's what Views utilizing UNION are good for
Is it not a CLASSIC implementation in SQL Server (I believe SS2K), when we didn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 5:15 pm
Jorge Serres (10/31/2011)
Simply useexec sp_MSforeachTable 'sp_spaceused '
Oh... be careful, now. sp_spaceused in SQL Server 2000 doesn't always have accurate row counts. You have to use the "UPDATE USAGE"...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 4:48 pm
drew.georgopulos (11/1/2011)
I was strongly cautioned by Evil Kraig F's and Omar Ismail's responses, so we've split the difference...development stops at visual studio. once the report is...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 4:35 pm
ramanamreddy (11/1/2011)
what will be the code if the no.of columns are unknown like how to write the code dynamically???
Kind of like the code in the following article...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 4:24 pm
drew.georgopulos (6/21/2011)
I want you to know i am standing up at my desk to say Thank You immensely for your time and effort Mr. Moden!
drew
ps. this sucka...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 4:20 pm
Greg - KPS, LLC (11/1/2011)
I am looking at your sample and I have to ask one question:
By using master.sys.all_columns, aren't you limited to 1000 days?
I am looking at generating a...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 4:16 pm
Brian Ki (10/31/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 4:05 pm
Evil Kraig F (11/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 7:39 am
sdownen05 (10/31/2011)
Not a problem, Jeff. Thanks for calling me on that.....
However, I just noticed Ninja's_RGR'us post. That code is much better than mine.
Thanks, Steve. That's the spirit. Now...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 7:30 am
Kiara (11/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 7:22 am
Evil Kraig F (11/1/2011)
Jeff Moden (10/31/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 1, 2011 at 7:10 am
Viewing 15 posts - 32,071 through 32,085 (of 59,102 total)