Viewing 15 posts - 1,996 through 2,010 (of 5,590 total)
How's this?
DECLARE @Output TABLE (Data1 varchar(5), seqvalue int);
BEGIN TRANSACTION;
BEGIN TRY;
WITH CTE AS
(
SELECT Data1,
RN = ROW_NUMBER()...
January 4, 2011 at 8:40 pm
You will first have to load the csv file into a staging table. You can do this by creating a #temp table with 50 appropriately sized columns, and then using...
January 4, 2011 at 7:56 pm
Dave Ballantyne (1/4/2011)
Do you even know what bit shift is ?
No... should I?
January 4, 2011 at 7:20 pm
Anil,
I'm not sure. The link that you gave only gives partial examples; if you have a sample XML that does this, we can try it. I'm not even sure if...
January 4, 2011 at 9:38 am
Craig Farrell (12/30/2010)
ProKelly (12/30/2010)
January 4, 2011 at 12:08 am
weharrelson (1/3/2011)
FWIW, We have weekly imports of ~25MB of XML. The sp_xml_preparedocument method ran circles around the new ways (x.data.value...)
BOL says that sp_xml_preparedocument needs to have the xml text passed...
January 3, 2011 at 7:10 pm
Geoff A (1/3/2011)
This is great info. Thanks Wayne.what do you think about making ALL x.data.values to be VARCHAR in the event that the XML is not well formatted?
For a standard...
January 3, 2011 at 2:12 pm
GSquared (1/3/2011)
WayneS (1/3/2011)
GSquared (1/3/2011)
Well, except from personal friends (including those already conquered by The Thread), or my wife. Those I answer.
Gus, are you implying that your wife isn't...
January 3, 2011 at 12:43 pm
GSquared (1/3/2011)
Well, except from personal friends (including those already conquered by The Thread), or my wife. Those I answer.
Gus, are you implying that your wife isn't your friend?????...
January 3, 2011 at 12:23 pm
Brandie Tarvin (1/3/2011)
CirquedeSQLeil (1/3/2011)
Happy Birthday Mr. President, Happy birthday to you.....:-DFYI, Jason, if I see you parading around in a slinky peek-a-boo like dress...
SOM! :w00t:
January 3, 2011 at 12:20 pm
Craig Farrell (1/3/2011)
Happy...
January 3, 2011 at 12:19 pm
Jack Corbett (1/3/2011)
Craig Farrell (1/3/2011)
January 3, 2011 at 12:18 pm
Viewing 15 posts - 1,996 through 2,010 (of 5,590 total)