Viewing 15 posts - 49,306 through 49,320 (of 59,066 total)
Will you never have anything with more than one space or punctuation? For example, will you ever have something like "new york, ny"?
July 9, 2008 at 7:19 am
This looks like a classic "Cross Tab Report" and the method for creating one (it's pretty simple) is in Books Online...
That not withstanding, how different questions and categories do...
July 9, 2008 at 7:15 am
isn't moving productions db's to vmware better?
I wouldn't move Production to VMWare if I had a choice... Development? Sure... just not Prod.
July 9, 2008 at 7:12 am
Nicely done, Gail... It shows that the Convert method takes about 4 times longer than the DateAdd/DateDiff method... While someone may not be working on a million rows, anytime...
July 9, 2008 at 7:05 am
I just fixed the $*$#&! smiley faces that showed up in the above code... 😉
July 9, 2008 at 6:51 am
You don't need the overhead of a "split" function for this... just a Tally table. Please see the section titled "One Final "Split" Trick with the Tally Table" in...
July 9, 2008 at 6:47 am
Oh yeah... almost forgot... there is one faster method... convert to Float, distribute Floor, convert back to DateTime... but most people don't use that because it only brings a little...
July 9, 2008 at 5:53 am
I prefer the method that Gail listed... it's all "math" and that makes if faster than character conversions. It also keeps it as a DateTime datatype so that other...
July 9, 2008 at 5:50 am
sql_novice_2007 (7/9/2008)
ID Names
1 david,peter,sam
2 john,kevin,marsh
3 brian,broad
I...
July 9, 2008 at 5:46 am
It's not @@ScopeIdentity... It's SCOPE_IDENTITY().
Now that you put it that way, though, I think you might want to try the new OUTPUT clause in 2k5... that can give you a...
July 9, 2008 at 5:27 am
In that case, I'm amazed at how many different peoples have apparently adopted the Arabic language as their own... just look at their code 😛
July 9, 2008 at 5:17 am
Grant Fritchey (7/8/2008)
July 9, 2008 at 1:14 am
I can't help on the XML stuff... but you may want to consider using SCOPE_IDENTITY() instead... @@IDENTITY will return the wrong number if, for example, you have a trigger on...
July 9, 2008 at 12:57 am
chazcross (7/8/2008)
Im having some trouble writing a query to return results the way i would like it.
It's important to know how many titles you might have per company... if it's...
July 9, 2008 at 12:49 am
indraprakash (7/8/2008)
Hi,round function not gives proper output
floor is right.
Ummmm.... why do you think that? Using the optional 3rd parameter of ROUND makes it behave like FLOOR but with...
July 8, 2008 at 10:53 pm
Viewing 15 posts - 49,306 through 49,320 (of 59,066 total)