Hi,

As you said we can use the SQLCMD to execute operating system commands by indicating the " !! " before the command.

I have created a POC on using OPerating...

Hi,

I am not clear on what issue are you facing. But I have tried to create a test scenario. I have taken 1 test table and Test excel file. Test...

ramakantshankar (6/14/2011)

---

Hi Rajesh,

I have created same scenario using the data discussed in your question as below:

CREATE TABLE PIVOTING(NAME VARCHAR(4),DATE DATE, SIZE INTEGER);

INSERT INTO PIVOTING

SELECT * FROM (

SELECT 'AAAA' NAME,...

Hi Rajesh,

I have created same scenario using the data discussed in your question as below:

CREATE TABLE PIVOTING(NAME VARCHAR(4),DATE DATE, SIZE INTEGER);

INSERT INTO PIVOTING

SELECT * FROM (

SELECT 'AAAA' NAME, CAST('04/15/2011'...

Hi,

You can apply join on the result set of two stored procedure. Following is an example showing the use of OPENQUERY for achieving this:

Syntax of OPENQUERY used in...