I agree with the prior comments. This article requires a local (on-premise) SQL Server and Management Studio. There needs to be a way to schedule jobs in SQL...

This

Clearly the absence of any reply indicates that it can't be done. Bizarre though - SSDT clearly is exporting the schema AND data (which is supposed to be the...

Good idea, but about 10 minutes ago I sorted it out.

Just needed to run sp_updatestats.

All good after that.

Call this a case closed.

Update...Couldn't wait as this was an urgent request! (Aren't they all).

1st step. Created & saved a view with columns mentioned above, plus an extra LineNumber column.

View is this

SELECT...

Correction to the required solution:

Using the sample tables provided in original post, the solution is to get only up to 4 addresses, even if each ROWID has more.

Also, the result...

Close. 20 rows with 5 address columns.

Cheers all for those answers. I'll give them a go later today. For Chris, max no of rows is unlimited but in actual reality, I guess there wouldn't...

All good responses.

In the end I went with Dwain's first suggestion. Slight variation.

SELECT TOP 7 field1, field2, field3

FROM table

ORDER BY CASE field1

WHEN...

But that is assuming the numbers are static. What if they change all the time or any time the query is entered? I guess the user could enter his values...

Thanks - I ran that script for both different service login accounts.

Both times the script gave identical results:

auth_scheme SQL

login_Name sa

Bizarrely too, I also did a SELECT...

Dave,

Yes limitation is still there in 2008. And yes I have been frustrated all this time over the past few years. I am still finding that something that...

Thanks twillcomp and Adi.

I thought I had seen somewhere that it could be done in SSIS and wanted to pursue that further. The bcp (being a DOS command, or...

I guess from the silence that this is harder than what I thought.

Does no-one know how to get XML output (or really, just any SELECT output) to a file from...

Sometimes the answer is so obvious I miss it...Why has not anyone else suggested this?

And then I found out why...

My output is not the XML I need, it is

Job 'My...