Nice script. Very useful information.

Thanks.

Why to go hard way?

No need to Add column ColRowNo and update it.

I would go like this;

---------------------------------------------------------------------

-- Create Table and Insert data

---------------------------------------------------------------------

Create Table TestTable (RowID Int Identity(1, 1), Col1 int,...

If there is no info in default trace, than there is hardly any way to get the required info.

Apply DDL trigger for future.

Easy one...

regarding RDLC reports?

You can discuss RDLC reports with .NET developer around you.

In case of RDLC reports, you get the dataset on the frontend and then bind it with the report. You can check the dataset before binding it with report and...

ntext, text, image, or xmlcolumns cannot be used in an ORDER BY clause.

And cHelp is a text column.

OOps... didn't saw the page 2.

Select (select datepart(yy,getdate()) for XML Path(''))

+ '' +

(select datepart(mm,getdate()) for XML Path('') )

+ '' +

(Select datepart(dd,getdate()) for XML Path(''))

There might be another way as well...

Are you running report from front end?

Declare @vsql varchar(max)

Declare @vCols varchar(max)

Create Table vTable1 (id int, StudentID int, Dept varchar(10),BookID int)

Create Table vTable2 (id int, StudentID int, Dept varchar(10),BookID int)

Insert into vTable1

...

No problem...:-)

And Click on 'ADD Topic' button on the top to add a new thread.

WS,

then you should go for dynamic sql;

here is an example

Declare @vsql varchar(max)

Declare @vCols varchar(max)

Create Table vTable1 (id int, StudentID int, Dept varchar(10),BookID int)

Create Table vTable2 (id int, StudentID...

1. You should have started a new thread.

2. Please come up with the DDL statements and Insert statements of the sample data.

3. I hope this will help you;

Declare @vTable1 Table...

Good question..

And its because the datatype of the variables ( @lenStringArray and @lenDelimiter) is INT.