Congratulations Gail, thank you for all the shared knowledge.:-D

Something like this?

WITH CTE([MemberName])AS(

SELECT 'Cazares, Luis' UNION ALL

SELECT 'Cazares, Luis A')

SELECT LEFT( MemberName, CHARINDEX(',', MemberName) - 1) LastName,

SUBSTRING( MemberName, CHARINDEX(',', MemberName) + 1, LEN( MemberName)) FirstName

FROM CTE

Have you tried it?

Example:

IIF ( [ES Fully approved data 1] = '', '', [ES Fully approved data 1] + ';') +

IIF ( [ES Fully approved data 2] = '', '', [ES Fully...

Could you post DDL and sample data on the way of INSERT statements so we can work directly on it?

This should do the trick, however, I can't assure you that because I have nothing to test on.

Be aware that you can't use ORDER BY in a TVF because it...

You have a declaration for a single statement table valued function but your function has multiple statements.

Maybe I can help you with the code but it would be easier with...

DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 0)

Is getting the first day of previous month.

DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0)

Is getting the first day of current month.

- '00:00:01'

Is substracting one second...

My knowledge in SSRS...

You can't use a variable with a comma-separated values string to be evaluated with IN().

You could as well try the Delimited String Splitter[/url].

Read the article and if you have any...

To build one set as John said:

DROP TABLE #TableA

CREATE TABlE #TableA

(

ID INT,

SourceData nvarchar(MAX)

)

INSERT INTO #TableA

VALUES(1, 'INSERT TableX VALUES( 1''Something'')'),

(2, 'INSERT TableY VALUES( ''Something Else'', 1)'),

(3, 'INSERT TableX VALUES( ''Something...

It's a great thing that you found an answer that will perform correctly and will be fast and simple to understand and an answer that will help you to learn...

And that's the original query.

Note that this thread is almost 4 years old.

This might do the trick as well.

SELECT DISTINCT IPCode, ID

FROM Profile p

WHERE EXISTS( SELECT IPCode

FROM Profile x

WHERE p.IPCode = x.IPCode

GROUP BY IPCode HAVING COUNT( DISTINCT ID) > 1)