|
|
|
SSC Journeyman
 
Group: General Forum Members
Last Login: Thursday, July 02, 2009 2:23 AM
Points: 87,
Visits: 184
|
|
what is a t-sql statement to store the sql results in an excel sheet.
suppose i have two valieables @s and @b
normally i use select @a to display the value of @a
i want to store the values of the two variable in an excel sheet.
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Monday, June 22, 2009 4:48 AM
Points: 1,759,
Visits: 3,754
|
|
nabajyoti.b (1/2/2009)
what is a t-sql statement to store the sql results in an excel sheet.
suppose i have two valieables @s and @b
normally i use select @a to display the value of @a
i want to store the values of the two variable in an excel sheet.
Here's an excellent article which will get you started.
Since you're using SS2K5, have you considered using SSIS?
Low-hanging fruit picker
For better assistance in answering your questions, please read this.
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, July 02, 2009 2:23 AM
Points: 87,
Visits: 184
|
|
i am well aware of what SSIS can do.
But i wanted to direct two variables to an excel sheet.
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Monday, June 22, 2009 4:48 AM
Points: 1,759,
Visits: 3,754
|
|
nabajyoti.b (1/2/2009)
i am well aware of what SSIS can do.
But i wanted to direct two variables to an excel sheet.
In that case, the article will show you how, with examples.
Low-hanging fruit picker
For better assistance in answering your questions, please read this.
|
|
|
|
