Syntactical!

if @TransCode='TR001'

BEGIN

SET @p1 = dbo.AddFltAmount(@p1,@Flt_Amount) --here where i am getting error

END

....and dont put end if!

'Catch all' ,follow the link

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

This would just give 2 records from the entire result set, no? I thought OP wanted...

+ replace(str(datepart(hour,@tToday),2,0,),N'',N'0')

There is a comma after 0 and before parenthesis. By the way shouldnt u be writing dynamic sql at the end?

Explanation and test data are completely unclear!! but still tried my best.

It works just fine with this when I retrieve the data after update. What is the problem.

drop...

Reluctantly I am posting this as I am sure there IS a better way of doing it. But I could not think of any other thing apart from this now,...

Just to add to what Lynn has mentioned,

its a variable stored in memory for our operations, where would it 'commit/rollback' it to (no table or anything to go back...

This is called 'Title' case I guess. I dont think we have any built in functions in ss2k5 ( not sure about ss2k8). You might need to write an UDF...

I guess you have to create the server logins explicitly on 2005 (once you move your db). Users would be there at database level.

Not sure what you are trying to do, but to use the external dll, cant you just add it as 'reference' and then use it?

hmm.. along with your script include 'USE db2 GO' in your dynamic SQL and use sp_executesql to execute it.

http://msdn.microsoft.com/en-us/library/ms188001(SQL.90).aspx

BTW, as Doug.Williams mentions, you can use the fully qualified name...

Good site as J-F Bergeron mentioned 🙂

There is no point if we help you out and you wont learn. Can give hints as in for 2a its one of...

Magy (11/12/2009)

---

Oh ok,

Well each table will have a sessionID column that identifies which session the data belongs to.

A table row cannot exist without a sessionID entry.

So maybe...

u r welcome 🙂

Is this what you want at the top of your stored procedure?

IF OBJECT_ID( 'tempdb..#urtemptable') IS NOT NULL

DROP TABLE #urtemptable