Viewing 15 posts - 38,881 through 38,895 (of 59,072 total)
If you're looking for a "perfect" copy of production to put into development and have a decent SAN, then you could use a "SAN Snapshot" (has nothing to do with...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2010 at 7:04 pm
You CAN post code... look at the "IFCode Shortcuts" when you create a new post or reply to one. Surround your code with one of the shortcut "pairs" of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2010 at 7:08 am
WayneS (4/14/2010)
Jeff Moden (4/14/2010)
Wayne... just split on the "=" sign using SUBSTRING and CHARINDEX. It doesn't need to be Pivoted using a CrossTab to be used very effectively.
I utilized...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2010 at 6:25 am
skjoldtc (4/14/2010)
I've known...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2010 at 3:07 pm
WayneS (4/14/2010)
bill.brazell (4/14/2010)
As for the output, I'd prefer that it not include the name of the delimiter, only the value. i.e. "Ping"...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2010 at 2:59 pm
Heh... actually, I've added more comments in the form of a usage example and some extra credits... My intent is to do a long overdue update on the Tally...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2010 at 5:45 am
John.Sansom (4/14/2010)
In the United Kingdom there is...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2010 at 5:28 am
abrar.ahmad-1058946 (4/13/2010)
------------------- :exclamationmark:[/font]
or they...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2010 at 5:19 am
{edit} Machine dependent code removed. Sorry folks.
I ran into a bit of a buzz saw with the new split function that I previously posted (and have removed from this...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 9:53 pm
{edit} Machine dependent code removed... sorry folks.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 9:44 pm
Heh... ya did it to me again, Wayne. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 8:54 pm
I don't know the answer to your question but I have to ask... why do you want to do this? :blink:
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 8:28 pm
rpatil22 (4/13/2010)
ALTER TABLE ProdMachine
ALTER COLUMN MachineID Varchar(10) NOT NULL
error -
Msg 5074, Level 16, State 1, Line 1
The index 'IX_Clust_ID' is...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 6:28 pm
homebrew01 (4/13/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 6:17 pm
cjohn5552 (4/12/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 13, 2010 at 5:32 pm
Viewing 15 posts - 38,881 through 38,895 (of 59,072 total)