Change your ON Statement to derivedtbl instead of tbl_photo_comments.  Also, I don't think once you do that that your code will work.  You are attempting to join on Photo_id but...

What are you trying to accomplish by this?  MSDE is for development and NOT PRODUCTION.....

Please dont multi post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=191581

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=191586

How long do the individual queries take?  What is the expected run time agreement for the customer?  What happens if 1 query fails but all the others work?

Link from http://www.support.microsoft.com http://www.microsoft.com/sql/evaluation/overview/default.mspx

Sounds like whatever login you are using (or attempting to use) doesn't have the proper permission to update the Registry.  I would get with your security folks and make sure...

Ok.  <setting down soapbox>, <getting on soapbox>, <deep breath>...

Q.  WHY do you need the new column in the middle of your table?  A.  Because someone wants to see it that...

I think it might help if you posted WHERE this position is...

Another reason for the # of records to go up is that NOT all of the records from table B have a Y flag. It stands to reason that...

so YOU are the reason I was soggy last week. I was blaming my mom for flying in. I live in Tampa

Remi,

We had a developer (no longer with us) that coded a WHERE Statement (PARTIAL portion) to be WHERE fieldx 'D'. We app. passed a data amount (now...

Whatever custom permissions you set I would script out.  This way when you patch you can re-apply them.  Patches drop\replace system items and there is no way to prevent this...

#1 grab a test machine that you can destroy

#2 after you have wrestled it to within an inch (centimeter) of it's life getting it set-up for your use try

#3 Install...

When you CAST'ed the DATETIME you lost the seconds.  You cannot get them back from already CAST'ed values.  However, Try this conversion for FUTURE date conversions IF you need seconds... ...

I would do the following PRIOR to going down that path:

1.  Have the customer run CTRL+L with the guts of the SP in QA.  This will show the "estimated" execution...