Hi Sandhya

Here an example:

CREATE TABLE test

(

column1 int not null,

column2 int not null,

CONSTRAINT PK_test PRIMARY KEY CLUSTERED (column1),

CONSTRAINT AK_test_column2...

I would also prefer the usage of stored procedures. If you write the SQL to the report you may not be able to assert if all reports still work.

Greets

Flo

So he is either a power user or I commiserate with him 😛

To your question:

I don't think...

Hi

If your sample fits to your business requirement just avoid the nested INSERT-EXECUTE:

USE tempdb

GO

IF (OBJECT_ID('tbl1') IS NOT NULL)

DROP TABLE tbl1

GO

CREATE TABLE tbl1 (id INT, txt VARCHAR(100))

GO

INSERT INTO...

Hi

Did you have a look for linked servers? This should be your solution. Here a little sample for the usage:

DECLARE @LinkName SYSNAME SET @LinkName...

Hi

Sorry, but I don't understand your question. Do you have a DDL and some sample data?

Greets

Flo

Hi

Some questions:

* Why is the usage of a cursor requirement?

* What is the reason for the recursion?

* Is the requirement that this shall be executed always when new data become...

Hi

I've never used the OUTPUT feature but had a look to BOL. Seems that it returns the cursor as output.

Why do you not just return the data as SELECT from...

Perfect! 🙂

Try this:

declare @xml xml

select @xml = '<Test>

<value>50</value>

</Test>'

set @xml.modify('replace value of (/Test/value/text())[1] with "100"')

select @xml

Greets

Flo

Hi

Maybe just attach a text file with your sample. 😉

Greets

Flo

Hi

Did you try sp_executesql?

USE tempdb

GO

IF (OBJECT_ID('test') IS NOT NULL)

DROP TABLE test

GO

CREATE TABLE test (id INT, txt VARCHAR(100))

GO

INSERT INTO test

...

Hi

Please either mask your xml < and > or attach an example file. 😉

Greets

Flo

You're welcome!

🙂

Hi

Guideline for calculations in SELECT section is a scalar user defined function instead of a procedure. It may be possible to call a procedure with OPENQUERY but maybe have a...

Hi

Try this:

DBCC SQLPERF ( LOGSPACE )

Greets

Flo