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

You're making it too complicated. Forget script tasks - just set up your data sources like this

SELECT...

Yes, there is, but it's messy. It involves query INFORMATION_SCHEMA.COLUMNS and using the results of that to set up your output columns and so on dynamically. Far better...

Sorry, I don't understand why you want to create the columns dynamically. Do you require a different set of columns from your table each time the task is executed?...

Have you considered changing the query in your data source? Something like this:

SELECT RTRIM(col1), RTRIM(col2), ...

FROM MyTable

John

From memory, I think the sp_helprotect stored procedure and sysprotects system view are what you need. Also check membership of the db_datareader database role.

John

Yes. We use the query to report from all our servers to a central server. That is then compared against a list of databases that should have been...

What do you mean by a more printable format?

To run on all your servers at once, I think you can set up a job and target it at more than...

I'm not sure what you mean. Please will you provide some table DDL, sample data and expected results so that we can visualise it.

Thanks

John

Narendranath

I'm afraid this is the point where you need to go away and do your own investigations. If there's anything in particular you don't understand about any of those...

Narendranath

You have four options:

(1) Export to a text file or similar, then import from that file to the destination

(2) Use OPENROWSET

(3) Create a linked server

(4) Use SSIS (SQL Server Integration...

I think I'd do it like this:

(1) Create an Execute SQL task that dumps the results of xp_regread into a temp table. (You may wish to experiment with the...