Hi,

For that I went in and replaced the names being referenced using a script I downloaded from the sql scripts on this site.

Thanks everyone! All tables are now renamed 🙂

Thanks for all your help!!! I am working on the solution right now. Hopefully it will pass UAT 🙂 Thanks!!

Hi,

My reason is pretty simple, its customer related. We have customers that buy our software and input data-lets say today 3/7/2007. In that case the getdate() is todays date. However,...

Also, were you able to look at the file I attached earlier? Would that be a place for to start because I definitly dont want to introduce some sort of...

Hi,

On the server that I would change it on, I would want all system views procs, etc.. to see the date returned. Thats why I am looking into changing the...

Its not doing anything wrong. Its just used in too many places and in one environment I need it return a different date and want to be able to modify...

Hi,

Thats what I also thought but am trying to avoid the global replace. I did find the code attached in the .txt file. Just started going through it to see...

Thanks, I probably missed something and will go over. I was just going based on your top line of this is only a small example of what needs to be...

Yes, agreed, definite laziness but initially when tables with lets say 20 varchar fields are created the initial page size is huge. However, just my opinion is not getting through...

I've been attempting to get this working with my tables that I have. Still need some help. Could you please post, attach or email the actual solution for my tables...

Hi,

Ok, I have the exact requirements and will post the ddl to the 2 tables that are involved along with the select being run now. Any help would be greatly...

I am working with the developers to get the exact results they are looking for, they basically want to narrow it down so that the result set would actually be...

Thank you very much!

This is the code I am running:

declare @date datetime

set @date = getdate()

exec ('SELECT * INTO [IDPSystemFolders_Backup_'+cast(@date as varchar(100))+'] FROM [IDPSystemFolders]' )

This is the error:

Line 4: Incorrect syntax near 'cast'.

Thanks!