Viewing 15 posts - 33,091 through 33,105 (of 59,102 total)
Luck may have something to do with it, Remi. I've never had any luck at running OSQL (old days) or SQLCMD when two SQL Server instances were named precisely...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 28, 2011 at 6:09 am
Ok, Rocky... here's some "starter" code that does what you want with the data you posted (see the first link in my signature line below for how to post data...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 28, 2011 at 5:59 am
Lavanyasri (7/27/2011)
Thanks in Advance .
We have one preprod and production server . All the time the CPU Utilization is 100% on production server . We...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 9:13 pm
Not so much EAV's and certainly not OTLT's, but I do use their smaller cousin, NVP's (Name/Value Pair), a fair bit especially if reporting is required. They're also quite...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 9:08 pm
rocky_498 (7/27/2011)
Here is my data
Add,Street_Number,Street_Name
123 Johnson St,Null,Null
22 Main Blvd, Null, Null
I want to split "Add" column end result should be like this
Add,Street_Number,Street_Name
123 Johnson St,123,Johnson
22 Main Blvd,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 8:54 pm
I agree... what are you going to do with the data generator once you've restored a copy of prod? Are you simply trying to obfuscate data?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 8:49 pm
Ninja's_RGR'us (7/27/2011)
Jeff Moden (7/27/2011)
btull89 (7/27/2011)
Thanks for all of the feedback! It was helpful.
I'll add to all of this. Use thoughtful comments and section headers. IT makes life a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 8:45 pm
Jim Wolgamot (7/27/2011)
A table variable seems like a better solution to me
In most cases, I'd agree. It's nice to have this wonderful trick available, though.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 6:19 pm
Here we go... think "Teach someone to fish...". 😉
If we take the working code that I previously posted and mark the sections that are static and those that are dynamic,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 5:59 pm
ng.work (7/27/2011)
If a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 5:02 pm
opc.three (7/27/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 4:59 pm
Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
From the website... kind of a buried link...
Important dates
1.Deadline for...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 4:33 pm
Roy Ernest (7/27/2011)
WayneS (7/27/2011)
Roy Ernest (7/27/2011)
Not much traffic on my blog I am afraid. Or else I would have written it already.. 🙂Where is your blog?
Here in SSC. I just...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 4:28 pm
GilaMonster (7/27/2011)
Jim Murphy (7/27/2011)
Useless post just to make 500.I hate when people do this.
I'd do one, but it appears I'm off by more than one this time...
Congrats on blasting through...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 4:19 pm
With exceptions, of course, many While loops will register 2 or 3 times the number of rows as there end up being in the result set.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2011 at 4:14 pm
Viewing 15 posts - 33,091 through 33,105 (of 59,102 total)