If it is an 'I' then 0 else 1.

Jeff, been try to help him, but we can't even get him to help himself. I have pointed him toward your...

First question I have, do you have a backup of the msdb database? If not, why not.

If you don't, start reading BOL (Books On-Line). You should be able...

Sounds like a good use of a Tally table. Read the following article, it should help you out. If not, let us know.

http://www.sqlservercentral.com/articles/TSQL/62867/

I have nothing against which to run your script. You haven't provided us with the tables or sufficient test data to do anything except guess.

This is actually a continuation of the following thread:

http://www.sqlservercentral.com/Forums/Topic600148-338-5.aspx#bm601093

Seconded -- to agree with a motion presented during a meeting, usually resulting in a vote on the motion. Check Robert's Rules of Order.

Bingo. Then add a little bit more for cushion. If you determine that the log should be 5 GB, make it 6 or 7 GB to add some...

Okay. That explains why I have never heard of a natural join. I've never had the opportunity to work with Oracle.

I want you to actually read the article I keep telling you to read. I want you to help us help you. If you can't provide the necessary...

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,...