Krishna,

Ganesh's suggestion is excellent with two corrections.

Let's say you are trying this for week 35.

1/1/2004 is week 1. So if you add @weekno (35) to it you will actually be getting...

Are you wanting just YOUR stored procedures or all stored procedured?

When I create my own sp, I save it to a script directory on my hard drive (I have folders...

Is there a trigger or script that could be saving the time as UTC (GMT)? The command GETUTCDATE() might be in use with your database.

Quick way to figure out if...

1. Please post in an appropriate forum.  this forum is for discussing the Question of the Day - not for individual's questions. The QOD is a test question that you can view...

I think you are getting truncated data.

2 10 1316

2      13

The 10 has been dropped and so has the 16. Is there any code converting or reformatting the RoleID result?

-SQLBill

Yes. SQL Server backup commands are designed to allow you to backup the databases while they are being used. Using those commands also cause very little impact on your users.

The...

Can you afford to take the databases offline for a while? If so, the BEST way is to detach the database and copy the .mdf, .ldf, and .ndf (if any)...

Wow! That's a strange way to keep dates and times.  First you have to tell us how to interpret the datetime value you have as a decimal. In other words, what...

What was the solution? Please post it as it might help someone else in the future.

-SQLBill

You moved the database to SQL Server 2000 from MSDE 2000.

1. did you move the procedure (I know this sounds like a dumb question - but depending on how you did...

It depends on what you are going to do with the date/time value.

1. Just display it. Then VARCHAR is good enough and you don't have to CAST or CONVERT it...

I agree with the previous posters....it's gotta be your application. The reason is that SQL Server does not STORE dates and times in any "date/time" format.

Per the BOL:

Values with the...

Forgot to add, one issue with GMT/Local times is during the change from DST to 'normal time' and back again.

Let's say the time changes at 2 am local (as it...

Yes, there can be issues. I am on the US east coast (Eastern Standard Time). The we are GMT-4 during DST and GMT-5 the rest of the year.

My database is...

Is the Windows 2000 box part of an active directory and your Windows NT box isn't?

Is the Windows 2000 box on a different network than the SQL Servers and the...