lmu92 (4/23/2010)

---

Rob Schripsema (4/23/2010)

---

As Imu92 said, you don't give us a lot of details about how the data will look, but assuming it is all consistent with your sample and...

As Imu92 said, you don't give us a lot of details about how the data will look, but assuming it is all consistent with your sample and there are only...

Do both WWW and WWW1 have indexes on ABC, A1, A2 and A3? And updated statistics?

Depending on how the tables are being used, it may or may not be wise...

Very clever, Wayne. I like that.

Oops, not ON DELETE CASCADE, I meant to say, ON UPDATE CASCADE.

Sorry.

Did you say that the 'path' column serves as the primary key on this table? Strikes me as a little odd....

I've never faced this exact situation, but it seems to...

Did the Sunday full backup complete successfully?

Should I still add the ISNULL check? I am not sure how you do that in the IF statement. I was only thinking you do ISNULL like so: ISNULL(value,...

I think we need more info. Your code here will just concatenate a first and last name. In a query, you'll get one row per record, not a list. The...

No apologies necessary. We were all newbies once...

Why a loop?

Why not just the following:

EXEC proc_student '2010-01-06'

EXEC proc_student '2010-01-07'

EXEC proc_student '2010-01-11'

EXEC proc_student '2010-01-20'

EXEC proc_student '2010-01-25'

Like you said, UPDATE is used to update values within the table - it is a DML (Data Manipulation Language) command. What you want to do is modify the structure...

When I run the sproc the "FromYear" and "ToYear" are displayed as below:

FromYear ToYear

1905-07-30 00:00:00.000 1905-07-30 00:00:00.000

The right display should be FromYear 2009 and ToYear 2010

Why are my parameter fields...

mec (4/14/2010)

---

I always thought the reason you can't use include on clustered indexes was that it brings no benefit, as essentially you read the table when reading a clustered index...

I think you need to provide more info before anybody here can help you.

What does the table schema look like?

How are you detecting the duplicates? Is THAT the process that...