Viewing 15 posts - 52,561 through 52,575 (of 59,064 total)
Nuts (2/12/2008)
That exactly what I wanted
Just curious... which way did you end up going exactly?
February 12, 2008 at 8:38 pm
stricknyn (2/12/2008)
Seems like this should be pretty straight forward, but its not working. I'm trying to build a string with 7 characters from a random statement:
Declare @mn int
Declare @mx...
February 12, 2008 at 8:36 pm
I'm confused... I believe the cross-join is to generate a million rows... not to generate the 7 digits. Perhaps I was looking at the wrong post. Which one...
February 12, 2008 at 8:27 pm
Michael Valentine Jones (2/12/2008)
John Beggs (2/12/2008)
What boundary would you set...
February 12, 2008 at 5:52 pm
Heh... proof again... performance is in the code... water cooled CPU's wouldn't have made that query run any faster.
Nice job, Matt.
February 12, 2008 at 5:48 pm
Previews lie... not sure I'd take 100% stock in the preview any more than the trust I put in an estimated execution plan (which I don't trust at all ;)...
February 12, 2008 at 5:39 pm
Heh... correct... there's always that "one time" that justifies the cold water you have running through the garden hose to baseplate of the CPU in your server 😉
February 12, 2008 at 5:36 pm
Lookup_BI (2/12/2008)
but despite many suggestions..My boss[:alien:] is still sticking with his decision.
Crud... I've been there and done that... having a boss that wears a big ol' chip on his shoulder...
Sure...
February 12, 2008 at 5:29 pm
Greg,
Would you post one of your emails that has the correct format, please? Be sure to use a code window (Click on "IFCode" in the menu of the edit...
February 12, 2008 at 4:53 pm
antonio.collins (2/12/2008)
February 12, 2008 at 9:58 am
Yeah, Matt... I was afraid it would be something of that nature... too bad.
Micheal, I'm right there with you... compromise is to write code to generate static code. Have...
February 12, 2008 at 9:51 am
I took a look in BOL for Kishore's suggestion on using tablediff.exe.
Lemme quote...
The tablediff command prompt utility returns detailed difference information between two tables and can even generate...
February 12, 2008 at 8:00 am
You have to create a "share" to your directory... the share would be for the user that SQL Server logs in as... OR... if SQL Server was given super user...
February 12, 2008 at 7:25 am
felipe (2/12/2008)
Please corrrect if I'm making any mistake, but I think SQL creates an unique ID to each opened transaction.
If it exist, I need to get this ID number.
Thank...
February 12, 2008 at 7:22 am
Viewing 15 posts - 52,561 through 52,575 (of 59,064 total)