Certification is designed for professionals with at least 2 years of experience using the products.

Like this?

DECLARE @sql nvarchar(MAX) = N'',

@Table nvarchar(128) = N'Test'

SELECT @sql = N'SELECT

TT.PK

,X.COL

FROMdbo.' + QUOTENAME(@Table) + N'TT

CROSS APPLY

(

' + STUFF(( SELECT N' UNION ALL

SELECT TT.' +...

There's a problem with your sequential number generator. It's explained in here: http://www.sqlservercentral.com/articles/T-SQL/74118/

Here are 2 alternatives. One is using NOT IN as in your original query, the other is using...

You should try using bcp, it should use less resources to accomplish what you're doing. 😉

I'm sorry, this forum is specialized in Microsoft SQL Server, so...

Forget what I said earlier, you should be able to do it, you just need to unpivot one table.

SELECT wo.fldWorkOrderID,

wf.fldWorkOrderFixID,

fldValueId1,

...

I would say that you're stuck with the 6 outer joins.

The problem is that you're joining on different columns from your WorkOrders table.

So what's the problem? What is impeding you to do what you need?

Can you share sample data (no need for real data) for UsrList and LOG_UsrAccess tables? Also the expected results from that sample data.

Thank you.

Care

You can use Notepad++ and the option "Search in files".

You could possibly use a Regular expression as "<CommandText>*.SELECT", without the quotes.

Remember that reports are simply xml files.

John Mitchell-245523 (7/11/2016)

Luis Cazares (7/11/2016)

Mohit Dhiman (7/11/2016)

Can't see why this should not work. Which version...

chick-chicky-boom

Mohit Dhiman (7/11/2016)

Can't see why this should not work. Which version of SSIS are you...

rattlesnake