I'm done.

We need the DDL for the tables and views you are working with. This means generating the create scripts using SSMS. We then need sample data to work...

Never heard of a natural join. Could you provide more context in which it is used? That might help.

We are going to need the DDL for the tables and the view (for SQL Server 2005, not Oracle), sample data (in the form of insert statements) to load into...

You seem to be doing a lot of work to write a CLR trigger that uses embedded sql to accomplish what could be done in straight T-SQL code.

What is the...

I'm seeing multiple errors in the code in your post. Can you provide us with what you are trying to accomplish with this procedure? From what I see,...

Seeing that the table definition you posted earlier doesn't have the base types used, you are going to have to start comparing the base data types between the view and...

Also, an observation. BOL will answer many of your syntax questions. BOL should be your first place to look when in doubt about T-SQL syntax. Learn it...

What is this trying to accomplish?

where

C.CustomerID is null

AND CAST (A.Customer_Status AS int(2))

Jeff Moden (11/11/2008)

---

Oh my... I just remembered where the heck such a requirement for all positive numbers may have come from... PeopleSoft software. Seems like the last folks that...

ajaykini (11/10/2008)

---

Hi Experts,

I have developed a web based software for a Multi level Marketing Company where one member joins and then gets 2 members below him - one on the...

Seems to me that a stored procedure, a temp table and a variation on the running count would give you what you need.

What do you think, Jeff?

Not sure how you would do this, but it sounds like the application should control the application, starting it and ending it (commit or rollback) and that the stored procedure...

Start by reading the article identified below in my signature block. Also, try explaining what the purpose of the trigger is to accomplish.

Oh, one more thing. Post all the above here on this thread. If you need to, zip everything and post the zip file. If you PM it...