oops!! thought the checkboxes where radio buttons.

real cracker.

Light-weight is the key word there .

Its better not to script the LEN part . It is there in case the length of the bookid varies. The length of bookid could be less than or greater...

What about using a subquery. I have'nt given the full query and this is just a guess...

SELECT SELECT Documents.DocID,

Documents.Category,

...

I can see a QOTD dated Dec 3 2009 on my list. It has happened before.

I agree.

2 important things to take note of before deciding on your approach.

1) Whats the volume of data and what happens when the data grows large.

2) How do you propose to...

Yes you are right.

select @@identity returns last inserted value of the current session. I think your prepared statement is run in one session and the select @@identity in another.

I think that you dont need "dayofweek" column. StarTDatetime and EndDateTime should be enough. You can get the day(s) of the week from these dates.

Dayofweek column is in...

one more way using cross join

select c2.countryname, c.countryname from country c

cross join country c2

where c.groupid= c2.groupid and c.country c2.country

order by c.groupid

Run dbcc checktable on the table to see if there is any corruption with the table. If its a production environment run the command when there is very little load...

and why using dynamic sql to do a maintenance task. Also why are you shrinking the log file. Are you taking any log backups.

Whats the error that you are getting.

I tried a small procedure and found that USE Database does not change the execution context to that database specified in the USE Database....