I think first and last date of year will always be same irrespective of what year is it. 😉

first date: 01/01/ year

last date: 31/12/ year

therefore, no need to use dateadd...

Hi Utsab

It entirely depends on what you want to achieve.

If the contents of file are going to be updated too frequently, i would suggest to load the file to...

Thanks All. Appreciate your quick response for big help. 🙂

Legal Disclaimer/Warning

Please remember that when using an SP you are not sure the outcome or effect it has should be done on test systems; never use anything that has not...

was doing research on internet, i found that i could use -b and -r tags in order to trap error messages, but i cant see anything in return from sqlcmd...

i don't know where i could use it but above all good to learn something new. 🙂

yes the database was marginally bigger than others.

You will need...

if you are going to create new table and then rename it, make sure you have a the table script of existing table with all table objects.

rbarryyoung (7/3/2008)

---

Here is a post that has as good example of a Split function that works very well. It use varchar(MAX) but you can change them to NVarchar(MAX).

As for...

a good question and great discussion. thanks all

Hi bpbhalerao

Can you please...

Even i am of same opinion as of Jeff's

James is right. If your query is not in any kind of variable, then only way out is to copy it in any text editor and replace 1 single quote...

Hi todd

you have to get rid of ',' at...

Ken

your script uses sp_MSForEachtable which is an undocumented procedure. As for knowledge, is it advisable to use undocumented procedures on production server as i cant hope for any support...