Viewing 15 posts - 47,401 through 47,415 (of 59,064 total)
stax68 (11/4/2008)
Jeff M:What isn't true? I am talking about the limitations on passing table variables, not string representations of arrays, so the link provided seems beside the point.
Agreed... you can't...
November 4, 2008 at 12:54 pm
stax68 (11/4/2008)
Jeff Moden (11/4/2008)
http://www.sqlservercentral.com/articles/T-SQL/63003/
The author just didn't go far enough in showing how to use...
November 4, 2008 at 12:52 pm
stax68 (11/4/2008)
What isn't true? I am talking about the limitations on passing table variables, not string representations of arrays, so the link provided seems beside the point.
Can you...
November 4, 2008 at 12:51 pm
Nah... not true... in SQL Server 2005 and up, there's basically no limit to passing arrays...
http://www.sqlservercentral.com/articles/T-SQL/63003/
The author just didn't go far enough in showing how to use the EAV tables...
November 4, 2008 at 5:22 am
shalu (11/4/2008)
Is there a way to reduce the time taken for the Insert statement in the cursor ? I am just blank on this.
So is everyone else... that's...
November 4, 2008 at 5:11 am
You can thank Matt Miller for that little gem. I used to use RAND(NEWID), but CHECKSUM is quite a bit faster. Either way, don't need a loop because...
November 4, 2008 at 5:06 am
AnzioBake (11/3/2008)
BTW Jeff, where you able to use the random data generator?
Yep... made a couple of changes to it to make it run just a little faster... give it a...
November 4, 2008 at 12:43 am
Jonathan Kehayias (11/3/2008)
there are those out there who would opt for the simplicity of solving a problem in CLR over the required TSQL to solve the same problem...
Heh... that's exactly...
November 4, 2008 at 12:01 am
What do you want returned if 102 has NO entry for 2008-07-01, either?
November 3, 2008 at 10:16 pm
Heh... you have books with no names? :hehe:
November 3, 2008 at 10:05 pm
... and, before you get all fired up and start using that or any other concatenation function, you have to read the following to avoid some serious performance problems...
http://www.sqlservercentral.com/articles/Test+Data/61572/
It...
November 3, 2008 at 9:59 pm
Sridevi (11/3/2008)
I wrote a function and i got the result too.
CREATE FUNCTION select_concat (@A INT )
RETURNS VARCHAR(MAX) AS BEGIN
DECLARE...
November 3, 2008 at 9:55 pm
As someone else said in an earlier post...
M u s t... r e s i s t... t e m p ...
November 3, 2008 at 9:46 pm
I'll never understand this type of question.... you're on a forum with a bazillion questions and you ask where you can find questions? 😉
November 3, 2008 at 9:41 pm
Marios Philippopoulos (10/29/2008)
The main wait type is - by...
November 3, 2008 at 9:31 pm
Viewing 15 posts - 47,401 through 47,415 (of 59,064 total)