What ALZDBA said above is correct.

However, I would venture to say that you could, if you truely desired, to create a script that would do it. I...

Did you try using the CAST function?

CAST(0x0000000000000BB9 as DATETIME)

CAST(0x0000000000000BBA as DATETIME)

CAST(0x00000000000007D4 as DATETIME)

CAST(0x00000000000007D5 as DATETIME)

HTH

Fraggle

Just to clarify, you currently have a database named ABC on Server 1 that is contained in the Primary filegroup. You want to take a backup of ABC database...

Congratz man. Wish you the best of luck!

Brandie,

I tried sending you an email. Please let me know if you recieved it. If not, I can be reached at heaivilin@hotmail.com. I am interested in the...

Thanks for the explanation as well, as I now understand why the NTILE won't work in your case.

Fraggle

If it has been open a week, I would say kill it. Kill it hard.

Sorry to hear that Jeff. At least if you fix it, you will be...

This would be my ideal ranking. Using the 2008 year as an example

Select 6,1028,'High' union all

Select 2,924,'High' union all

Select 3,862,'Medium' union all

Select 4,724,'Medium' union all

Select 5,628,'Medium' union all

Select 1,569,'Low' union...

Those are not the results I get. I get 40% in ranked 1, 30% ranked 2, and 30% ranked 3 for the 10 Rows. So this is roughtly...

Have you tried using the NTILE function. Really designed to do just this type of stuff. Run this after inserting into the data into the #Sales table. ...

Sorry to scare you there Jeff. 😀

I just sent you a Test one. Did you recieve that?

Start -> Programs -> SQL Server 2005 -> Configuration Tools -> Surface Area Configurations

When the windows opens, select the Surface Area Configuration for Services and Connections. When it opens,...

I sent you one last night about it from your other post. Did you recieve it?

Sorry that was a typo. Meant to say I couldn't see any reason for it.