Provide sample script and data for the same

You can simply do it using your flag variable

Example

If @strFlag = 'Not Join'

BEGIN

Select * from FirstTable

END

If @strFlag = Join'

BEGIN

Select *...

Or Involve a table column in where clause you can use below mention query.

DECLARE

@ObjectName varchar(11),

@ColumnName varchar(20),

@message varchar(80)

DECLARE column_cursor CURSOR FOR

SELECT OBJECT_NAME(C.OBJECT_ID), C.NAME

FROM SYS.COLUMNS C, SYS.TABLES T

WHERE...

What query or process you used for exporting data into sql server??

In Store Procedure defination you always use use SP parameters with in where clause. So at least with this query you can easily identify what parameter used for what purpose.

For finding the all list of parameter used in SP you can use below mention query.

SELECT sp.name, parm.name AS Parameter, typ.name AS [Type]

FROM sys.procedures sp

JOIN sys.parameters parm

ON sp.object_id =...

Kindly write down your code here with same script.

So it will provide you fast help

what kind of row id du you need.

If you need row id which is stored in your table then you can use table's identity value for the same

😉

Kindly used sql code tag for writing any sql query.

And also post same data for batter view.

Provide the test script for the same.

Dear,

Kindly provide the test script for batter analyze.

Regards

Vijay

Yes Paul, But for Smaller String We can use.

XML also have validation as it don't support spacial character like "&"

/*

Name:

SplitString

Parameter:

1) Seperator

2) String

Details:

This function is used to split string with specified...

Yes You are right. Thankx for another solution

I think Pivot is used for show aggregated data

in Your case test below mention code

DECLARE @T TABLE

(ID INT IDENTITY, NAME NVARCHAR(200));

INSERT INTO @T (NAME) VALUES ('A1, A2, A3');

INSERT INTO...

Unpivot is the best way to achieve this task.