Not to create more confusion, but what is the business need here? If you only want to return one row of data per account number, then why return the address...

Oh cool thanks 🙂

Your post most have come right as I was posting mine 😀

Right, but if I develop a cube using the evaluation edition on the server, when the time expires will I not be able to use the cubes that I designed...

I have a few full evaluation editions from the Microsoft books that include the 180 day trial and include everything. I know this because I am using one of the...

I figured out the problem.

None of my @sql = '' included the N'' in any statement. I converted every assignment to this and it works like a...

Jeff can you show an example of this?

Piotr.Rodak (1/7/2010)

---

Still, it looks like single string assignment cannot be longer than 8000 characters. To work around this, split your long sql string into parts and use + operator to...

Thank you for all the responses, I will try out a few of the suggestions here! However, I did find a solution though I have no idea why it works...

That is strange I am only returning some 6k+ characters and I still get a truncated (though very close to the end now) sql statement.

Is it possible because I...

Ok I do have the code fixed now but I am still running into the problem towards the end of my code. I pasted into word and it says there...

I think I finally figured the problem out!

For some stupid reason I had @sql = @sql + @sql + @Variable in 8 places! (waaaaay...

Varchar(max) isn't acceptable because it has to be nVarchar(Max). But that still has a character limit I have surpassed.

Is there not another way to get around that?

Thank you however, this completely changes the use of having parameterized dynamic SQL...

Surely there is a solution that doesn't involve rearranging the usage of sp_executesql

It's not him anymore that is the problem it is ME...the administrator to the entire server...

I was able to resolve his issue after some research but it was after I...

No ideas on this at all?!

Wow I like blowing stuff up so well that even the experts are silent 🙂