Dynamic Search Conditions in T-SQL

You could do something like this :

Select * from dbo.Orders O where O.Type = 0

And (@FromSalesOrderID IS NULL OR O.OrderID Bewteen @FromSalesOrderID AND...

Still doesn't require dynamic sql. I'm not mad at you but at everybody who suggest these solution. Still 30 columns is not that long to write since you...

delete from tblorderline where OrderID in ( select OrderID from tblOrders where Offercode = 'NWZ')

Why do you guys keep posting dynamic sql solution when he clearly doesn't need one????????????

If he's too lazy to write a 3 column update, and by the way the same...

You'll have to create a table that'll keep all the possible label values by language then set the captions at run time everytime you load the forms.

Don't be too hard on him... you'll get there long before us .

He needs to know which line of the code in the sp is currently executing.. hence we suggested debugging.

Sorry Noeld... didn't reread the initial post after Corey said it didn't work. Looks like he should reread his own posts too .

Now...

Noeld's fix :

change the return line to this :

return @result

Ya... so much control and I didn't even realize it :-).

Check this out... it runs 19 times faster than the function solution (and could be even faster with less casts) :

dbcc dropcleanbuffers

go

Select OrderId, ProductId, UnitPrice, SUM(CAST(SUBSTRING(CAST(UnitPrice AS VARCHAR(40)), PkNumber,...

Ya mybad.. just remove that part of the query :

GROUP BY TEST_DATE

Can someone explain why the first query I posted didn't work in this context?? I can't reproduce this behavior on my server.

Can't you run this??

Select dtValidDates.txtDate from

(SELECT txtDate

FROM Table

WHERE ISDATE(txtDate) = 1) dtValidDates

WHERE CONVERT(DATETIME,dtValidDates.txtDate) BETWEEN '01/01/2003 00:00:00' AND

'04/30/2005 23:59:59'

SELECT

SUM(CASE WHEN QUESTION1_SCORE = 0 THEN 1 ELSE 0 END) AS Q1

, SUM(CASE WHEN QUESTION2_SCORE = 0 THEN 1 ELSE 0 END) AS Q2

, SUM(CASE WHEN QUESTION3_SCORE =...