Hi Amrita,

Say, ur orders and orderdetail tables grow tremendously in that case anytimes joins would be better than subqueries..Becoz for a subquery for each outer query it will execute the...

Hey buddy, just a quick tip, y not create another object of type i.e. sp_OACreate 'ADODB.Command' and then try set the property using sp_OASetProperty for CommandType=adcmdstoredprocedure

and commandtext="ur proc name"..

By the...

hey it's ok buddy..sometimes same happens to me too 😉

Hi venku,

Just a comment here, y to use NOLOCK hint, i think sql Query Optimizer will choose the best hints so y to override the default behaviour and by the...

I tried thru QA, but it didnt work, I think your's is full backup and from Ent Manager, i guess u can do multiple backups for diff backups..I even tried...

Hi,

As per my knowledge, I don't think this is possible i.e. restoring multiple backups to a single database and also the thing here is, u cannot have multiple mdf files...

But u can't use a #temp or create table within function body..u will have to either go the stored proc way or create a 1 column paramater table if u...

Hi,

If I understand ur proc correctly, i believe this will run in a recursive fashion that means, whenever a delete statement is issued on orders table it will again invoked...

What is the message you are getting?

But the catch is how to execute this in a function i.e. i dun wanna hardcode "Nancy" instead of that i want to use say @lastname now, here is...

U can simply create a stored proc and pass parameter as createdate and then use insert statement to insert values into newusertable..

For coupons, as said u can use identity() function...

You cannot execute dynamic sql within a body of function unless its an extended stored procedure..u can do something like this in the body of function..

return(SELECT lastname

FROM OPENQUERY

(LkServer2,...

1.You can create a job setp and paste ur T-SQL in the step and the notifications you can define either a net-send operator or mail operator. But i'm afraid that...

Sridhar,

Nothing with Query Analyzer i believe!

Maybe, u can put this query in a job and notify u by a netsend operator/mail operator. 2nd option wud be to write a small...

i dont know have a win2k box to check this..if i get one, will let u know but i believe there might be some setting or mite be something in...