As others have already stated, you need to provide more details. What...

david_a_wallace (8/28/2012)

---

Thanks for your help, I'll keep on with this method of making numeric autonumber IDs instead of using things like people's names.

The reason the ContainerTypeID is in the contact...

Sean Lange (8/28/2012)

---

You can also expand the table in SSMS. You can click and drag the "Columns" folder to a query window and you will have comma separated list of...

You can also expand the table in SSMS. You can click and drag the "Columns" folder to a query window and you will have comma separated list of all the...

david_a_wallace (8/28/2012)

---

OK I have tried to take the advice given (thanks for giving it) and change the database table structure, I have linked the tables into MS Access and drawn...

Jan Van der Eecken (8/28/2012)

---

Just a question: Why would one want to pass a DATE to ISDATE()? Surely that should always return TRUE, even if it is NULL (which it...

david_a_wallace (8/27/2012)

---

Thanks for your help.

The problem I have with using IDs as keys is the user will see the IDs instead of the text on the main forums and would...

More importantly than getting the desired output....do you understand what that function does? Can you explain it somebody else? Keep in mind that YOU are the person who has to...

sivajii (8/27/2012)

---

thanks

dwain.c

it was working fine

can u plz give one idea is there any chance to avoid null value instead of that...

ylsvani (8/27/2012)

---

Thanks for the response. Here are the scripts for the above

I am new sql server. I am trying to get the following data. I have 3 different tables

create table...

Hi and welcome to SSC! Your post is so vague nobody can do much to help. We would need to see ddl (create table scripts), sample data (insert statements) and...

Jeff Sims-413169 (8/27/2012)

---

I have a table that is storing the data file information. I need to pull out of that table the SUM of file_sizes located on each...

Looking at your problem a little bit you seem to not know how to properly reference other tables. You seem to routinely reference data so that is ends up being...

david_a_wallace (8/27/2012)

---

It doesn't seem to have the answer though that link.

It says "The series of cascading referential actions triggered by a single DELETE or UPDATE must form a tree that...

A simple search from google of BOL should provide you this type of stuff. A simple google search for "sql server foreign key cascade update" returned the following as the...