No automation in your files is a good thing...you'll still need to install additional...

[Opinion] Simpler-to-read syntax:

DECLARE @StartDate DATETIME = '2011-11-17 03:17:14.000',

@StartTime DATETIME = '1899-12-30 04:34:47.993'

SELECT CAST(CAST(@StartDate AS DATE) AS DATETIME)...

I am pretty sure this has nothing to do witht eh fact that your using SSMS 2008 by the way, this has to do with how SQL Server looks for...

Double-post...direct replies here: http://www.sqlservercentral.com/Forums/Topic1081364-149-1.aspx

Best_boy26 (3/20/2011)

---

Do you know any easy way to get the data for this from exisiting table and exisitng data to post as a sample... ? I mean from SQL Studio...

It's best not to use SQL Server to access Excel. Microsoft does not stand behind any use cases where Excel is being accessed from unattended server-side code:

http://support.microsoft.com/kb/257757

Ideally you should request...

If you don't know how to write C# code then why do you want to convert this code to C#?

If you are serious about using C# as your chosen .NET...

Koen Verbeeck (3/21/2011)

---

All the way down, there is a general...

Create a staging table on the same filegroup as your partition, use SWITCH to move the data from your table partition into the staging table. You can then TRUNCATE the...

Using the example Column data you gave what does the actual line of text look like in the file? 1|2||4|3 ?

Check out http://www.connectionstrings.com

Check out http://www.connectionstrings.com

I was a full-time C#/SQL dev 4 years ago (80/20 split) and I could not stand SSIS when it first hit the scene because it seemingly made things so much...

I made up some DML since you did not provide any :Whistling:

INSERT INTO dbo.root(root_id)VALUES (1)

INSERT INTO dbo.subroot(subroot_id, root_id)VALUES (1,1)

INSERT INTO dbo.tempxml(subroot_id, childnodes)VALUES (1,'<data value="test"/><data value="test2"/><otherdata value="test3"/>')

With your...

Thanks for playing along too...I thought this might be doable using the Pivot transformation however I have decided 'no'. If the elements were Child1, Child2, Child3, Car1, Car2, Car3, etc....