Results 1 to 4 of 4

Thread: Use variable parameters in a TSQL stored procedure

  1. 09-12-2012, 04:32 PM #1
    lcsw
    lcsw is offline Registered User
    Join Date
    Sep 2012
    Posts
    2

    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?
    Reply With Quote Reply With Quote
  2. 09-13-2012, 08:04 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Use t-sql in excel?
    Reply With Quote Reply With Quote
  3. 09-13-2012, 08:12 AM #3
    lcsw
    lcsw is offline Registered User
    Join Date
    Sep 2012
    Posts
    2
    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.
    Reply With Quote Reply With Quote
  4. 09-14-2012, 08:45 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Can you post table schema with some sample data and results you like to see?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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