Jason-299789 (2/7/2013)

---

I know the one you're talking about GSquared, Gail made a lot of very interesting points and I think Paul also added a few comments about inplace updates.

The...

thanks again ; will read that out ..

And coming...

ChrisM@Work (2/7/2013)

---

There was a thread covering exactly this, fairly recently. I'll try to track it down. IIRC the conclusion (for most...

HildaJ (2/6/2013)

---

I'm very new to TSQL so my apologies for my lack of experience. Really working on it : ) So instead of using a cursor what would...

ALI100 (2/6/2013)

---

SetFormattedValue =CASE

When rg.ReferredFieldType='NUM'

Then CAST(#PointedMslValues.Value AS NUMERIC(18,cAST(rg.ReferredDecimalPoints) )

more cases .

END

I am generating a dynamic query which is giving error actually it...

Yes , An edit regarding this ;

For staging tables cleaning , one job should do the...

m.rajesh.uk (2/6/2013)

---

I need a plan to cleans all the tables in a database for every 9 months.

what are the best ways to do that.This time period can be...

purushottam2 (2/6/2013)

---

I want to update data on condition based, if condition met then only update else left it.

I was using CASE statement but i realized in CASE there is no...

+1

Thanks for the question.......

purushottam2 (2/5/2013)

---

Id columns i have just given for reference, in my case TVF will always return 1 row but in table may have multiple id. So i think it...

Pablo Campanini-336244 (2/4/2013)

---

Hello

1.- What would be the code to insert some columns from a deleted record into a different table.

2.- Can I update a field on a table when an...

vanapandi (2/5/2013)

---

thank you sir,,,i got result...i want to improve my knowledge in sql server..can you suggest me..

i am also finally got result by using sub query...whether it is wrong way

...

Jason-299789 (2/5/2013)

---

I'm not suprised it took a couple of hours looking at the query you have loops with cursors which is going to drag performance down into the basement and...

Lokesh Vij (2/4/2013)

---

Here you go:

CREATE TABLE Payment

(

PaymentHistoryID INT,

paymentID INT,

...

Please provide the ddl ..

follow this link for best practices to post :

http://www.sqlservercentral.com/articles/Best+Practices/61537/