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

Luis Cazares (8/27/2012)

---

I guess it was wrong for me to read the 2012 version as it is less explicit.

But I still believe the OP won't have an option on creating...

Luis Cazares (8/27/2012)

---

I can't find a restriction for indexed views that involves outer joins http://msdn.microsoft.com/en-us/library/ms191432.aspx....

GETDATE() is a sql function. It will ALWAYS...

Nobody is going to be able to provide much assistance from what you have posted. We would...