-
Use variable parameters in a TSQL stored procedure
I am new to TSQL and this is the first time I have encountered this situation.
I have a very simple sql statement...SELECT field FROM database where item=?
I would like to use the cells in column D in my Excel sheet and place the field returned in column E of the same row.
I have no idea how to do this...any suggestions?
-
-
Yes...I use Get External Data and use my SQL server as the Database.
In the connection that is created, I use an SQL statement to get the data.
-
Can you post table schema with some sample data and results you like to see?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|