So if i have a hundred users who want the report than that a hundred reports which is going out oppose one report going to a central location with...

Let me re-word that, I want to fire a trigger when column2, column3, column5 and column9 are updated/insert (not the other six columns) so do I need to use the...

I didn't everything what was mention in this thread at the being, since "Select @@servername" is returning Null But "select SERVERPROPERTY('SERVERNAME')" is returning the new servername then I'm not going...

The Server was restarted, but yet the new name is not being accepted.

By restoring a copy of the 2K5 database onto the 2K8 database, I will have dataset's which point to the 2K5 db and not to the 2K8 database as well...

Never mind, Found the problems.

That sounds good but there it's about 200 reports I would have to do that to. It has to be a better way.

I' deleted the Encryption Key content, that seems to help But it comes up looking in a DOS format.

Thank you Wise One, that was it.

I didn't think so, but I though I ask however I was wondering why reports come up looking like a DOS Directory and not the SSRS background/look-feel.

Never mind, I figure it out (or what I wasn't doing).

The second statement you provide is correct but the only problem is that the year doesn't go up when going into the next year.

for example input: 12/01/2014 the...

I'm not clear on the last statement line From (Values........ Also if I use todays date and run the first three lines of code, the CorrectedVersion Date is the...

Looking at books online to get an understanding/some idea with Cross Apply with dates.

Thanks for your suggestion, it help. Using that statement you provided, if I want to subtract -7 day or 1 week in addition could I just add -7...