Ah! So it was! Sounds like your community. 😛

I also did something interesting in this article, where I used DelimitedSplit8K to format a dynamic SQL string into lines, butit only works with strings that are up to 8000...

Maybe you need to take a look at this (by Jeff Moden):

Display More Than 8000 Characters [/url]

Here's another way to do the same thing but using a single CROSS APPLY of DelimitedSplit8K.

WITH SampleData ([Identity], Name, Col1, Col2, Col3) AS

(

SELECT 1,'Test1','1,2,3','200,300,400','3,4,6'

...

I'm not sure I understand the problem. The allowed @sql string is NVARCHAR(MAX) (as you defined in the post you linked to). So why would 7000+7500 characters be...

Jeff Moden (12/11/2013)

---

ChrisM@Work (12/11/2013)

---

Gosh, I'm surprised that with a title like this, there have been so few takers - and so little feedback from the OP. Maybe those sleepless nights...

In order to help you, you're going to need to help us by following best practices for posting a question of this type:

- Provide DDL (CREATE TABLE)

- Provide consumable...

saravanakumar.G (12/11/2013)

---

Hi,

You just modify the SP like below and it should work.

CREATE PROCEDURE spNewEmployee

@FirstName varchar(50),

@LastName varchar(50),

@skills SkillsTableType READONLY

AS

BEGIN

DECLARE @EmployeeID int

INSERT INTO Employees

(FirstName, LastName)

VALUES

(@FirstName, @LastName)

SET @EmployeeID = SCOPE_IDENTITY()

insert...

Luis Cazares (12/11/2013)

---

There's no need to use dynamic code. Here's one option and maybe someone could give a better one because I'm not so sure on its performance with big...

A CURSOR is probably not required.

I'm not sure what exactly you want to do when there are duplicates, but try this and see if it gives you what you're looking...

I think the key here is knowing what's in @UnknownValues when the user selected SSN and Address. Something like '03,04' perhaps?

Probably you need to get a better handle on...

The last thing I want to try to do is explain the implicit conversion rules SQL chooses to use in these kinds of cases.

Your best bet is to CAST the...

If you read that, you should also look at the discussion thread where I ran...

autoexcrement (12/6/2013)

---

I can't rival the other guys on this board, but I am using this as practice for myself and would like (constructive but friendly) feedback on the solution I...

Alan.B (12/5/2013)

---

dwain.c (12/3/2013)

---

GordonLiddy (12/3/2013)

---

This article is a complete ripoff from Itzik Ben-Gan's book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions! Nowhere is there any credits to the original...