Thanks for your quick response but how can I set that into non military format?

I need additional detail. Thank you so much.

I'm using 64-bit

Thank you very much

I'm using 64-bit.

Thank you very much

I'm using 64-bit.

Thank you very much

Thanks for a quick response.I don't use hardcoded values that's why I'm using a cursor.Can you pls send me a sample script using a cursor?

Thanks in advance.

Hi,

Thanks for a quick response.

I've added below conditions on my program:

Internal_Lot_Number = @ILN

AND Station_Code = @oper

Thanks again.Good day and God Bless!

Thanks to happycat59! and Dave Balsillie! Good day and God Bless!

Thanks Dave.Aside from database,I also changed the source table that's why i need to recreate my cube.The problem is when i try to create new dimension i encountered this error:

"Unable...

Hi again.I already copied the cubes from production to test server.My question is that since the database has changed,do I need to create a new cube?

Thanks a lot!Good day and God Bless!:)

I'm using SQL Server 2000.I don't seem to have a shortcut to the SQL Server 2000 Management Studio anywhere.