As I said in an earlier comment, and as Sam said, check the RetainSameConnection property of the task. If that doesn't work, use a global temp table (but don't...

This should get you started. You can use it to create a table valued function, which you can CROSS APPLY to your table to get the results you're looking...

True, but I was assuming both versions are 64-bit. Saurabh doesn't specify.

John

Saurabh

You might consider installing the development tools on a client PC instead of on the server. That way, you can keep your development separate from the function of the...

Then you'll need to use the Windows scheduler to invoke sqlcmd and run your stored procedure.

John

Besides, as far as I know, sysadmin logins have full access to the server, even overriding any DENYs that may be in place. This applies even if you drop...

It's good practice to remove the BUILTIN\Administrators login and just grant access to those who need it. Be very careful when you do this on a clustered instance, though...

Temp table is necessary, not table variable. A table variable only lives for as long as the batch that creates it.

John

Nobody used the phrase "CASE statement", did they? It's a difference, granted, but an important one?...

Use CASE instead of IF.

John

Ken

I think there's a property of the package called Delay Validation. Try setting that to True. That way, SSIS will not try to check that the Excel files...

Search this site for "gaps and islands" - that should get you started.

John

I think the UNION or UNION ALL operators are what you're looking for.

John

TheSQLGuru (3/25/2011)

---

Computed columns would have them paying the price for computations over the course of the entire month. Probably best to take the hit once, unless the data is...

Rohit

You're breaking the laws of normalisation by having redundant data in your table. Why not change the columns you are updating to computed columns instead?

John