Viewing 15 posts - 8,491 through 8,505 (of 8,761 total)
MVIT (4/26/2014)
But in the procedure before processing the date, I need to convert the date
to...
April 26, 2014 at 1:40 am
Scott Arendt (4/25/2014)
I will agree that it is a personal preference and completely meaningless unless enforced.Also, my personal preference is No_Underscores!!
Do not want to underscore any preferences but I find...
April 25, 2014 at 11:08 am
Luis Cazares (4/25/2014)
More than a simple order by is needed. You need to use CROSS TABS (or pivot if you want to complicate yourself :-P)
I really did miss something (he...
April 25, 2014 at 10:00 am
Unless I missed something, you just have to add an order by clause.:cool:
April 25, 2014 at 9:34 am
Another way of doing this:
😎
SELECT
T1.ID
,DET.AILS.value('Age[1]','INT') AS Age
,DET.AILS.value('Name[1]','NVARCHAR(128)') AS Name
,DET.AILS.value('City[1]','NVARCHAR(128)') AS City
FROM dbo.Table1 T1
OUTER APPLY T1.XML_Uncompressed.nodes('Details') AS DET(AILS)
April 25, 2014 at 8:03 am
Looks more like a wishlist than requirements to me.
😎
April 25, 2014 at 4:02 am
Best bet is to find an ODBC driver for Btrieve (Pervasive SQL), at least that's what the files look like.
😎
April 25, 2014 at 2:17 am
amela.ajanovic90 (4/25/2014)
How do you mean share? The entire thesis will be published by the University, all the responses are of course anonymous. 🙂
Something like posting a link to it here...
April 25, 2014 at 1:19 am
Koen Verbeeck (4/25/2014)
It's still all or nothing (and I'm OK with that). I see no reason why one would want to switch off logging during an execution.
I agree, cannot see...
April 25, 2014 at 1:13 am
For SSIS 2008, the simplest way I have found to manipulate the logging is to use a Scrip Task in a "Master" package.
As the logging is initialized before any...
April 25, 2014 at 12:44 am
exec sp_help 'procedure name'
and check the output
😎
April 24, 2014 at 11:18 pm
Some more information is needed as the file attached is not in any (obvious) standard format.
Which software produces the file? Are there any ODBC drivers available?....
😎
April 24, 2014 at 10:50 pm
allamsanjeev (4/24/2014)
Haven't done any such step? If you can be more elobrative would be of much needed help.Thanks
Open up command prompt (cmd.exe)
type: net start
and hit enter
the output should be:
These Windows...
April 24, 2014 at 10:14 pm
Will you share the work when it is finished?
😎
April 24, 2014 at 5:06 pm
Could you post the xsd and some sample xml, hard to tell what is happening without more info.
😎
April 24, 2014 at 4:50 pm
Viewing 15 posts - 8,491 through 8,505 (of 8,761 total)