Source = variable passed as SP parameter, datatype nvarchar(max).

Destination is this table

Create Table MyTempTable(

FIELD1nvarchar(max),

FIELD2nvarchar(max),

FIELD3nvarchar(max),

FIELD4nvarchar(max),

FIELD5nvarchar(max),

FIELD6nvarchar(max),

FIELD7nvarchar(max),

FIELD8nvarchar(max),

FIELD9nvarchar(max),

FIELD10nvarchar(max),

FIELD11nvarchar(max),

FIELD12nvarchar(max),

FIELD13nvarchar(max))

BTW in terms of extra information or DDL I'm not sure what people want.

CSV data with a fixed number of fields (in my case, 13), and an unlimited number of...

Hi

Thanks for all the comments! Here's additional info to each responder:

@bitbucket-25253 : Thanks for the script, but as Craig describes, I need each on its own row,...

Thanks to everyone for the suggestions, I will certainly give them a go. As things go, I've been dragged off on to several other items since starting this one,...

Well actually I've managed to buy some time (don't ask how!), so any answers to this would still be hugely appreciated!

No limit.

I've resorted to a while loop, to hit each row with an update, but would still love a better approach as I'm using this in a few places (pardon...

Many thanks. That's pretty much what I've always done, except using IsNull instead of Coalesce (is it really faster?)

Was hoping there was a new way to do it 🙂

Thanks...

Hmmm..... that's an interesting idea. I may try it, but wouldn't that be likely to take a lot longer to run?

Yes, that's true. Very valid point!

True Howard, except that in my case, the second table *didn't* have a column of that name, but when typing the query, I had thought that it did.

Therefore where...

Big thank you to Chris Morris - Wow....I'm genuinely surprised. Didn't think after this many years I'd be caught out by sql syntax. I always use aliases in...

"my_table_2 might contain one row with other_field='value' . I think other_field to my_table_2.

if outer query field is referenced in a subquery query the subquery will fire for n outer no...

Hi

Thanks for the replies.

No CTEs, and yes I would have expected SQL to return the multiple rows error. But I would *not* have expected it to *not* warn me...

Hi

Sorry, pardon my ignorance, but what's a group? How do I create a group?

Brian

I might just add to this that when upgrading sql databases, we would run the same upgrade script against all databases on a sql server, which would include the blank...