Added an additional test:

create proc dbo.MyTest (

@StartDate datetime = null

)

as

begin

set @StartDate = isnull(@StartDate,getdate());

select @StartDate;

return...

You can't use the fuction getdate() as a default. You need to do something like this:

create proc dbo.MyTest (

@StartDate datetime = null

)

as

begin

...

rbarryyoung (9/30/2008)

---

Jeffrey Williams (9/30/2008)

---

tbeadle (9/29/2008)

---

As for the other paragraphs - basically, you cannot have the following:

SELECT ...

FROM table1

LEFT JOIN table2 ON table2.fkey =...

A quick fix may (or may not) be to add the user to the db_ddladmin role in the database in question.

I haven't found anything else as of yet.

😎

You asked:

This is the only subquery I see:

...

I will have to do some research, but the developer is full of it when it comes to needing to have to use sa to create temp tables.

I'll let you...

Full Backup - Everything is backed up.

Differential Backup - Everything that has changed since the last Full Backup is backed up.

Incremental Backup - Everything since the last Incremental Backup is...

What exactly is the error you get?

Have to comment on the snow. I live in Widefield (or as my parents like to say, North Pueblo), and we get very little snow on average when compared...

Jack Corbett (9/30/2008)

---

Sorry, my question was meant to be funny. I do know what BI is,...

Some sample data, a table for the sample data, and the expected output would help greatly. Preferable, all of this should be done such that all we have to...

Actually, to be precise, it...

mixalissen (9/30/2008)

---

UPDATE t

SET count_Successful_modulesOfProgram = CountModulesOfProgram

FROM @tmp t,

(

SELECTcert_cand_programs.candidate_fk,

COUNT(cert_cand_programs_fk) AS CountModulesOfProgram

FROM cert_cand_programs

INNER JOIN cert_cand_programs_details ON cert_cand_programs.pk = cert_cand_programs_details.cert_cand_programs_fk

INNER JOIN Exam_Candidate...

dfine (9/30/2008)

---

Hi,

I don't think you can disable the idnex.

instead you can drop and re create it.

If your table contains huge no of records with clustered index created

then re creating...

Actually, that's one of the reasons they state in BOL for disabling an index. Go to books on line and check out ALTER INDEX.

😎