GSquared (12/2/2009)

---

Brandie Tarvin (12/2/2009)

---

Nope. That did NOT work. I even did a DENY INSERT on schema dbo and had the user's default schema as MySchema and had the proc saved...

If your beer is agonizing, stop drinking bud light.

Yes, I went there. 😉

I thought I did? I made very slight modifications to the code you posted(based off of Gus') above and explained all of them.

Please include the code you are using to determine true/false. You're giving us the variables that you're passing in and the data you're checking it against, but you're not...

My fault, I read this one a bit too quickly. I thought you were going to be constantly altering the lengths of the fields. I can definitely see...

Gotta tell you, between this and the last question about SET IDENTITY INSERT in a trigger, I'm a bit frightened about what is going on in your database. Are...

My pleasure. I wish I could give you a better answer, but without knowing the structure of the data/tables, any answer is potentially wrong.

Not really. You need sample data. The relationships of these 3 tables is very unclear. Are there tables linking them together like ClassStudent and ClassSubject?

The...

This may help you:

http://msdn.microsoft.com/en-us/library/ms177544.aspx

It only returns the redundant data if you select it. If you just use SELECT *, then yes, you'll get a ton of stuff you don't need, but doing...

Ordinarily, you'd accomplish this with joins between the tables. If you want to provide table structure / sample data (see the first article in my signature for how) and...

It was a valiant attempt at sample data, but unfortunately it's not quite there. Here are a few of the errors:

No insert statement for the table

Word often...

You're missing a ton of information here. Where are the values coming from?

FullName Address City Country

Ravi aaaaa aaa aa

Andy bbbbb bbb bb

Apollo ccccc ccc cc

Sounds like an EAV system....

Here's a slighly modified version of a function that I use for something like this. It requires a Tally Table. See the article on Tally tables in...

rons-605185 (12/1/2009)

---

Per Lynn's quoted reply below. Being new to SQL (my background was some light VB programming) I am unclear by what is meant by a set based solution. Most...