Please post the DDL for your table and the DML for your data.

Please post what you have so far.

Sounds like a proprietary SEQUENCE to me. Can you refactor?

Your proprietary sequence (you called it ID) had to start somewhere so you must have a seed. Since all proprietary "ID"s...

In short, yes.

Try this:

SELECT CONVERT(DATETIME,'15 Feb 2011 12 am',121) as my_date ;

Are you asking about a scenario when moving data between two tables on different instances?

I'll assume yes.

BULK INSERT will not do this but OPENROWSET or OPENQUERY using a Linked Server...

My first thought was to use the SSIS object model in C# to execute the package and then attach to events that would allow you to end a process early...

What is the value of the package property "ProtectionLevel"? You can find this by right clicking some open area on the Control Flow design area and choosing properties.

Chances are you're trying to read a Unicode file as ANSI or the end of line character in your file connection in SSIS (e.g. {CR}{LF} ) is different from the...

Kevin Dahl (2/22/2011)

---

I have actually tried doing the pivot and building the IN clause dynamically (using this approach http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx), but it turns out that the column names actually end up...

Lutz has a point...dynamically generating a crosstab query would require approximately the same level of effort from you and would almost certainly perform better than a PIVOT. My code example...

As with most things...it depends. Performance absolutely CAN be affected by sharing a SAN across multiple SQL instances. There are many different types of SANs...some allow you to isolate your...

Building a PIVOT query dynamically is a viable option. Using your DDL I created a simple PIVOT query:

SELECT pvt.RecordID,

pvt.Variable1,

...

Nope...the [Server Name] column appears to be appended by the IDE, not on the server-side.

You said are going to put all the proc executions into SQL Server Agent Jobs so I would recommend looking into the logging functionality available within SQL Server Agent. Within...

There are ways to "tune" Linked Server queries by deciding between accessing remote data using either 4-part naming or OPENROWSET OPENQUERY. As Craig mentioned depending on how your query is...