Viewing 15 posts - 1,021 through 1,035 (of 2,458 total)
Phil Parkin (1/27/2016)
-- Itzik Ben-Gan 2001
January 28, 2016 at 12:27 pm
Just a guess but perhaps, before saving as Excel file, you could change:
<summary>Errors were detected in file 'C:\Users\\Desktop\WS_Print.xlsx'</summary>
To
<summary>Errors were detected in file ''C:\Users\\Desktop\WS_Print.xlsx''</summary>
Note the two single quotes instead of...
-- Itzik Ben-Gan 2001
January 27, 2016 at 3:11 pm
Can you explain what you mean by "line" and perhaps show us what the correct output would be for the sample data that you posted.
-- Itzik Ben-Gan 2001
January 27, 2016 at 1:22 pm
I don't fully get what you are trying to do here. Can you post some sample data that shows what the desired output looks like?
In the meantime, here's a...
-- Itzik Ben-Gan 2001
January 27, 2016 at 1:18 pm
Brandie Tarvin (1/26/2016)
TomThomson (1/25/2016)
GilaMonster (1/25/2016)
Bandwidth, latency and data out of the country (for 1 and 3)
I see the same. Plus in the EU it's probably illegal to host the...
-- Itzik Ben-Gan 2001
January 26, 2016 at 4:12 pm
ramana3327 (1/26/2016)
We have an xml file in network share. I am not what are the columns in that xml files to insert into a table
SELECT * into XMLwithTest FROM OPENROWSET...
-- Itzik Ben-Gan 2001
January 26, 2016 at 3:18 pm
You did not attach anything. Can you attach the two versions of the query plans using just SSMS. I'm sure we can get to the bottom of this.
-- Itzik Ben-Gan 2001
January 26, 2016 at 3:05 pm
Ivanova (1/26/2016)
-- Itzik Ben-Gan 2001
January 26, 2016 at 9:19 am
No Namespace issues as far as I can tell. Here's a couple examples of how to parse your XML data:
DECLARE @xml XML =
'<xml xmlns:dt="urn:dt" xmlns:msxsl="urn:schemas-microsoft-com:xslt" dateofservice="1/1/2016 10:00" mmsid="201599999999" userid="dxxxxx9-xxx0-xxdb-xxx0-e8xxxxxxbcd" npid="dfxxxxx9-6xx0-xxxx-bxx0-exxxc1xxxxxd"...
-- Itzik Ben-Gan 2001
January 25, 2016 at 2:29 pm
Good editorial and good link to the StackOveeflow article.
I wonder how long resumes/CVs are going to be around. I could be wrong but kids in kindergarten today won't know...
-- Itzik Ben-Gan 2001
January 25, 2016 at 7:29 am
Should I normalize the data and create a table for client, assessments, assessment data (joined by assesmentID and clientID foreign keys)? Or should I create a denormalized data warehouse?...
-- Itzik Ben-Gan 2001
January 21, 2016 at 2:38 pm
Expanding on what Eirikur put together, here's how you could do it against a table (note my comments).
-- Sample data
DECLARE @table TABLE(stringID int identity primary key, stringTxt NVARCHAR(4000));
INSERT @table(stringTxt)...
-- Itzik Ben-Gan 2001
January 21, 2016 at 1:24 pm
I am also a fan of Redgate, never had any problems with it (I also don't work for Redgate). It's been awhile since I last used it but ApexSQL Backup...
-- Itzik Ben-Gan 2001
January 21, 2016 at 12:40 pm
Eirikur Eiriksson (1/20/2016)
Alan.B (1/20/2016)
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
-- Itzik Ben-Gan 2001
January 20, 2016 at 5:07 pm
Eirikur Eiriksson (1/20/2016)
Alvin Ramard (1/20/2016)
Ed Wagner (1/20/2016)
Steve Jones - SSC Editor (1/20/2016)
-- Itzik Ben-Gan 2001
January 20, 2016 at 12:54 pm
Viewing 15 posts - 1,021 through 1,035 (of 2,458 total)