HTH.

I forgot to mention that there's also another one like this :

sp_msForEachTable that does pretty much the same thing but for all tables in the database. Those sps...

It's basically an hidden cursor that you can use to execute a dynamic sql statement against each database

run this to see what I mean :

EXEC sp_MSforeachdb 'Select ''?'''

it'll return...

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