Awesome....that worked like a charm.

Thanks

Thanks Gail Shaw. This was really helpful.

More details on Default Trace:

http://www.mssqltips.com/tip.asp?tip=1111

http://www.sqlservercentral.com/articles/sql+server+2005/64547/

Ya it rebuild index. When we use the DBCC DBREINDEX 'tablename', it takes some time to rebuild it. And if in the mean time if a user queries the same...

Mistakenly posted to Integrated Services section as this is no way related to it and didn't find any option delete the same.

Sorry for creating confusion.

Thanks,

Ajit

Thanks buddy, this is what I am looking for.

gr8.

We cannot use GUID.

The existing table has a numeric field which need to be migrated to a distributed enviornment.

suggest??

First of all thanks to all folks responded to my query...

I have managed to get the output to a some extent...I would like to share the same with you guys....

Just for R&D....

I Just need the table /View DDL scripts and also sp text...

You can use Triggers (update triggers) for the same. Refer BOL for detailed syntax.

Cheers!

select max(sal) from Emp_Salary

where sal not in (select max(sal) from Emp_Salary)

Thanks all for responding to my query...

gr8 stuff....

Try This,

Step-1

----------

select     

IDENTITY(int,1,1) as IdentityVal,

InvoiceGuid     

    ,CreditNoteID

           ,InvoiceHeaderID

           ,InvoiceBatchID

           ,BillToAccountName

           ,InvoiceNumber

into #test2

from #test

where invoiceNumber in (select Distinct invoiceNumber from #test)

Select InvoiceGuid     

    ,CreditNoteID

           ,InvoiceHeaderID

           ,InvoiceBatchID

           ,BillToAccountName

           ,InvoiceNumber from #test2

where IdentityVal...

Check This Out:-

select month(REQ_DATE_COMPLETE)  Req_Month ,year(REQ_DATE_COMPLETE)  Req_Year,count(REQNO)

from REQ_DATE

group by  month(REQ_DATE_COMPLETE)  ,year(REQ_DATE_COMPLETE) 

order by year(REQ_DATE_COMPLETE) , month(REQ_DATE_COMPLETE)

This way you will have more control and more options to represent your data in different...

Hope this help.

Creating An Indexed View:

----------------------------------------------

The CREATE INDEX statement must meet these requirements in addition to the

normal CREATE INDEX requirements:

The user executing the CREATE INDEX statement must be the view...

I Think you want to update the Description [NewReport] from the Progarm master where a matcing ProgramId is matched.

Update NewReport

set program =  p.description

from program p inner join newReport nr on...