GilaMonster (11/10/2008)

---

Seeing the code makes all the difference. It's not technically parameter sniffing.

That form of catch-all query does not perform well. Firstly the optimiser can't make accurate predictions with all...

CTE's aren't temporary tables. They are much more related to derived tables.

If you post in a SQL Server 2005...

Read BOL (Books On-Line), it will explain the different options available on the BACKUP command. If, after reading BOL, you still have questions, just ask.

Problem: Not enough information. We are guessing at what needs to be done to help you solve your problem. We need the whole story to be able to...

Lot of data, no information. What error are you getting?

You don't roll back. Do you have a current backup, prior to your erronous update? If so, you will need to restore it under a different name, and...

As long as what is written is the authors own work, why not? Each author has a different perspective on a topic and presents the information from that perspective....

I was looking at your a code a bit more, and it looks like it would still be used in a row by row fashion. What we really need...

The problem you have is that you can't use INSERT, UPDATE, or DELETE statements inside a user-defined function to update database objects (tables).

It is related to how the parens are used in the joins. Looks like the FROM clause needs to be rewritten.

I thought I had read a technical paper on the Microsoft MSDN site about this before, but I can't seem to find it now. I did find a link...

ajaykini (11/7/2008)

---

Thank you Lynn

The db structure is:

UserID | UserName | UserPwd|Address|ReferID|PositionType |regdate|SponsorID|UpdateDate|FranchiseeID|MemberType|ParentId|Reentry| Unit

Sample data would look like:

10000|rrs|rrs123|abc street, mumbai|9999|Left| 11-02-2008|9999|11-03-2008|9999|Bronze|0|N|

1

Hope i have provided the right data in a proper...

Garadin (11/7/2008)

---

This isn't a problem anymore (it almost was, I was 90% of the way done with a forum post when I figured it out), but due to how weird/interesting...

First, you don't really need to be using a cursor.

Second, read the article in my signature block below, and follow its advice and post additional information on this thread. ...