When I inserted first time it gave me the same getdate(). After your comments I tried agian and got diffrent result for getdate().

But if the requiremnet is to get the...

Can you explain your requirement clearly ...

As per my understanding I've written the below query,

select * from mfRepositoryErrors where errid in (select max(A.rn) from (select row_number() over ( partition by...

declare @opt char

set @opt='R' -- Set your required parameter value

select * from #trades

WHERE

(

CASE

WHEN ((@opt = 'A' AND parentTradeId is...

create procedure [dbo].[selectMediCalProcedureCode]

@CodeID int

as

begin

set nocount on

select ProcedureID

from hrp_CrosswalkProcedureCode

where Entity = 'Medi-Cal'

and ProcedureID in( select * -- explicitly specify the column name if you have mutiple columns in cln_ServiceInstance table

from...

Have a look to this link :

http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx

Thanks for notifying me.

I do take care of thread age before posting any comments.

Its depends on your individual decision. If you want to test yourself then you can go for certification.

After all getting certified in a product is not at all a waste...