Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 text file , stored procedure with parameter , excel file

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-14 : 08:01:42
Manish writes "i have text file with 2 values
fromdate&lastdate in notepad which user supply..
on this basis i want to select all the rows from sql server 6.5 Storedprocedure with 2 parameters @fromdate @lastdate

i want to store these results into excel file. how it is possible

for this i need only 1 batch file. which i will run on command prompt
and excel file be there with all results from stored procedure.

means

input:text file with parameter fromdate,todate
processing :stored procedure with parameter ,
output:excel file with all results
(:
pls help i am in urgent need..
manish"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-14 : 09:08:32
1 Copy the text file values to table and then query
2 To export to EXCEL, refer this
http://sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -