Viewing 15 posts - 33,136 through 33,150 (of 59,102 total)
Do you have any experience with databases at all? Also, what is it that you've been doing for the last 10 years?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2011 at 8:10 pm
Sridoc2020 (7/24/2011)
Do you know how I can force to accept following name in above query which contains comma18765_McHaney,Packet,DI,4.2.10_1
At the risk of offending you, you have to start trying what I...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2011 at 7:00 pm
Jules Bonnot (7/19/2011)
Does anyone how unique this is? How many times I would have to run it before I found a duplicate.
select ABS(CAST(CAST((newid()) AS VARBINARY(5)) AS Bigint))
I did the analysis,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2011 at 3:10 pm
To add to BitBucket's answer... it takes two bytes to represent 1 character in NVARCHAR which is really "Unicode" of sorts. The first byte indicates the "country code" (or...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2011 at 10:44 am
So... enquiring minds want to know... did the latest code fix things for you or not? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2011 at 10:09 am
MuchLearnSoLittleTime (7/23/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2011 at 10:06 am
VERY interesting. Thanks, Orlando, especially for the datatype match reminder.
What's really interesting (interesting as in "very odd") is that the changes to the code actually made the table variable...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 24, 2011 at 9:47 am
bddupree (7/22/2011)
The workaround is to set the InteractiveHeight =...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 5:28 pm
Would you do me a favor then? Would you run my code example and post the results? I'm always curious as to what any given piece of code...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 5:20 pm
Ya know, Remi... I thought you were just joking.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 5:12 pm
opc.three (7/23/2011)
Bah! SELECT INTO! 😀
😛
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 3:37 pm
I just tried both of the following on my machine and they both work just fine. You don't need the double quotes after all. You do, however, need...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 3:15 pm
I don't know what others may get, but I'm seeing that a Temp Table solution is about half the CPU intensity and about 2/3'rds the duration of a Table Variable...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 3:00 pm
Sridoc2020 (7/23/2011)
those are not real file names, they are edited for privacy. Just they are not real. But real file names also consists these kind of characters. They are done...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 2:26 pm
Yep... I know. My apologies... Since you're doing relatively advanced work, I made the bad assumption you might know about the "REPLACE" function. Here's how to do it.
REPLACE(@FileName,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 23, 2011 at 2:24 pm
Viewing 15 posts - 33,136 through 33,150 (of 59,102 total)