dynamic operator?

Question

Post reply

dynamic operator?

spin

Hall of Fame

Points: 3274
More actions
April 19, 2012 at 8:43 am

#255046

hi
i have an sql proc which i'm calling from excel
i want to pass in an account number as a variable which is fine. but i also want to pass in the operator. so either account no = 12345 OR account no <> 12345
can i pass the operator as a variable??
thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286602 More actions · Answer 1

yes

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Yes. You might want to elaborate if you want more info.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

spin Hall of Fame Points: 3274 More actions · Answer 3

i'm trying something like...

myproc (@operator varchar(7), @value varchar(25))

as

select col1, col2 from tbl1

where col1 @operator @value

is this kind of dynamic deceleration possible??

thanks

Cadavre SSC-Forever Points: 41690 More actions · Answer 4

spin (4/20/2012)
i'm trying something like...
myproc (@operator varchar(7), @value varchar(25))
as
select col1, col2 from tbl1
where col1 @operator @value
is this kind of dynamic deceleration possible??
thanks

Try something more like this: -

CREATE myproc (@operator VARCHAR(7), @value VARCHAR(25)) AS

BEGIN

DECLARE @sql AS NVARCHAR(MAX);

IF @operator IN ('=', '<>')

BEGIN

SET @sql = 'SELECT col1, col2' + CHAR(13) + CHAR(10) + 'FROM tbl1' + CHAR(13) + CHAR(10) + 'WHERE col1 ' +

@operator + ' @Dvalue';

EXECUTE sp_executesql @sql, N'@Dvalue VARCHAR(25)', @Dvalue = @value;

END

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

dynamic operator?

Cookies on SQLServerCentral