Hello Asha,

There is a possibility of restoring the files which you are having right now:

1. If the files are from SQL Server version 7 and want to restore on to...

Hi Paul,

Try this...

UPDATE DBO.SALES F

SET F.CATEG = CASE

    WHEN DERIVEDTBL.TOTAL_VALUES = 0 THEN 'cat0'

    WHEN (F.[VALUES] / DERIVEDTBL.TOTAL_VALUES < 0.1) THEN 'cat1'

    WHEN (F.[VALUES] / DERIVEDTBL.TOTAL_VALUES < 0.2) THEN 'cat2'

    WHEN (F.[VALUES] / DERIVEDTBL.TOTAL_VALUES < 0.4) THEN...

Hi,

Sorry wrongly posted into this forum.

Hi Pradeep,

If you have installed SQL Server 2000 on a new machine and would like to have the databases in running condition.

Solution:

If you are having  .MDF files for all the...

Hi sntiwary,

Before executing your stored procedure, click ctrl + k, so that the execution plan will be set to on. Now you run the query, here you can find 3...

Hello CSDunn

The error you are getting lies in the order by clause statement.

FROM tblLocation LC

Inner Join Student_Data_Main SD On LC.Location2=SD.SchoolNum

Inner Join Teacher_Data_Main TD On TD.TeacherID=SD.TeacherID

Inner Join tblMMStanTestScores TS On...

Hi,

I could solve the problem.

Hi Frank,

Thanks once again for the effort put in. The query is working fine on my local server, and when it is run on the live it is playing. I...

Hi Frank,

Thanks for the reply. I have modified the query and checked, but the same probs. Is there any other way of working it?

Hi ThomasH,

Are you talking about when the identity value reaches the max value of the data type?

Yes i want to know the max value of the data type "int"...

Hello Michael & Alkanfer,

Thanks for your reply. From your replies, i can use the keyword "WITH ENCRYPTION" on user-defined functions, triggers and views except tables. This is a tip for...

Hi All,

Nobody has responded. I am providing the requirement in detail.

Since 3 days i am trying to write a process by using XP_CMDSHELL external procedure to zip files.

My...

Hello Markus & Antares

Thanks for the reply.

If i receive an .mdf file, i can directly attach the database by providing this mdf file as per your guidance, so that...

Hello Jeremy & Rajesh,

Thank you very much for your suggestions.

Ravi

Hello Jeremy,

Thanks for the help. But i want the creation to be dynamic ie., the date should be taken automatically while creating the folder in "D:\MSSQL\BACKUP\DATE\FILENAME.DAT".

We are having the...