Why do you think you need to put common attributes in one table? If I had 2 different entities Person and Building and both entities had an address associated...

It doesn't look like a SQL Server problem to me. The SP will do exactly what you tell it to which is return a zero to the calling app...

Jack,

Great article. I implemented a similar solution (using Jamie's script to get the error description) but your's is a bit more elegant. I love the idea of...

Good to see things going in the right direction finally. Man, keeping up with this post has turned into a part-time job!!

Kudos on sticking with this one Lynn. You're a better man than I 😀

Yep, that'll do.

BTW....eliminating cursors is a great way to save keystrokes!!

foxjazz (3/13/2009)

---

Another point, why should someone that knows c# or vb and does it daily, have to learn t-sql.

Why can't t-sql accomadate that flavor of language just like the IDL...

You don't need a cursor for this. What you want to do can most likely be done with a few lines of code. Post an example of this...

As it stands, T-SQL is about the most simple language on the planet. Specifically, what problems are you having that you feel are the languages fault?

What you are suggesting will work. You should put a unique index on the Quotes.QuoteNumber column and lose the FK to your QuoteNumber table. They really isn't a...

Why not just put an IDENTITY column in your Quotes table?

Your CAST statement does not put the date into the format requested by the OP.

Alternately, you could generate a schema script and just re-create a blank DB. If this is something you have to do often, you could even take a backup of...

Vinod,

Why don't you make an attempt to write the query using the guidence that GSquared has given you?

If you still need help, post your work and we can help...

Two things. First off, the syntax you've proposed will not work. You cannot pass a DML statement as a parameter to a stored procedure. Secondly, you don't...