View Single Post
  #1 (permalink)  
Old September 19th, 2006, 10:18 AM
rit01 rit01 is offline
Friend of Wrox
 
Join Date: Oct 2005
Location: , , United Kingdom.
Posts: 173
Thanks: 0
Thanked 2 Times in 1 Post
Default Passing the Column name as the Parameter

Hi All

I have been scouring the net this afternoon trying to find out how to pass in the column name as a parameter within my sproc. It sounds as though it is bad practice but I cannot think of another way to get the same results.

This is what I was attempting:

SELECT DISTINCT @columnname From tblTable

Does anyone have any other ways to acheive the same objective?

Many thanks

Rit
__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER
Reply With Quote