Hi

You can use the following Query:::

This Query will create a table of same structure:

select EmployeeID,ln1,ln2 into Record from acesslog where 1=0

Regards,

Amit Gupta..

Hi,

Ok Then you can follow these steps and confirm to me it worked or not.

1) Start SQL Server in single user mode.

2) Go to your control panel and services....

Hi,

Use this Query :

select * from authors order by 1

select * from  (select top 5 * from authors order by au_id desc) a

order by 1

Regards,

Amit Gupta.

Hi,

RAMA

CAN YOU PROVIDE TO ME SUCH .mdf file , only then i can provide you to a best solution because i have to do some R & D  on it.

Regards,

Amit...

Hi,

pls. can you explain it in practical way.

1) i have mdf file which is offline.

first i have to restore it ? but i failed to restore it.

How i can do...

Hi,

To achieve this you have to use the trigger for insert on that table,

and in this trigger you can insert the inserted row in the second table with using of...

Hi,

I have already done these steps but these are not effective one for me.

My mdf file has one or more corrupt pages, so i can't execute even a single query...

Hi,

Your table 'del_screen'  contain identity column.

To insert all the values you must specify all the column names of a table. and

set IDENTITY_INSERT on

Thanks.

Regards,

Amit Gupta

Hi,

You can use the View to solve Your Problem::

Create View Vw_Calculations

as

select (select Result from metricResults where metricid=1) - (select Result from metricResults where metricid=2) 'Sale-Budget',

         (select Result from metricResults where...

HI,

Use this Query::

select distinct empid from emp where depid in(1,2)

Regards,

Amit Gupta

Hi,

Use this Query i think it would help you to remove the time part in your dates ::

SELECT  convert(datetime,convert(char(12),GETDATE(),111))

Regards,

Amit Gupta

Hi,

Use this Query in your related Db :

select object_name(constid),object_name(fkeyid),object_name(rkeyid)

from sysreferences

Regards,

AMIT GUPTA..

Hi,

I have an idea. You can use the temporary tables in place of cursors.

Regards,

Amit Gupta ..

Hi,

Use isnull to handle nulls in Sum.

Select sum(isnull(col,0)) from TABLEA

Regards,

AMIT GUPTA..

Hi ,

Can you send Your Query  what you are writing ?

Regards,

Amit Gupta