Viewing 15 posts - 23,791 through 23,805 (of 26,484 total)
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...
November 11, 2008 at 9:56 pm
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...
November 11, 2008 at 9:53 pm
Sounds like a good use of a Tally table. Read the following article, it should help you out. If not, let us know.
November 11, 2008 at 9:47 pm
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.
November 11, 2008 at 9:26 pm
This is actually a continuation of the following thread:
http://www.sqlservercentral.com/Forums/Topic600148-338-5.aspx#bm601093
November 11, 2008 at 9:15 pm
Seconded -- to agree with a motion presented during a meeting, usually resulting in a vote on the motion. Check Robert's Rules of Order.
November 11, 2008 at 9:01 pm
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...
November 11, 2008 at 5:18 pm
Okay. That explains why I have never heard of a natural join. I've never had the opportunity to work with Oracle.
November 11, 2008 at 4:48 pm
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...
November 11, 2008 at 4:39 pm
I'm done.
November 11, 2008 at 4:04 pm
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...
November 11, 2008 at 3:54 pm
Never heard of a natural join. Could you provide more context in which it is used? That might help.
November 11, 2008 at 3:46 pm
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...
November 11, 2008 at 3:35 pm
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...
November 11, 2008 at 3:14 pm
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,...
November 11, 2008 at 3:09 pm
Viewing 15 posts - 23,791 through 23,805 (of 26,484 total)