Could you Able to Post with some more information to understand your requirement,so that we will try to help you

Regards,

Rajesh

Hi,

if you have only five columns you can use pivot table to change columns to rows and coalesce function will move to non null values up ,you will get the...

Hi,

@@SERVERNAME will give you the local server name

Rajesh

Thanks a lot,Nice approach and Good Implementation without cursor

Rajesh

hi ,

write a select query using a full outer join between the two tables on orderid where orderId is null

will select only the differnce in orderId between the two...

Hi,

Hope this link will help you

http://msdn.microsoft.com/en-us/library/ms177410.aspx

Rajesh

Can you post the exact scenario by creating some example tables and error state ,so we will try our level best to help you

Rajesh

Hi,

Try to update the table with no Duplicate keys and then insert into other table

I think, this is what you are looking.

Rajesh

Declare two variable and set the variable to store the result of aggregate column of each select Query

select 'Total', Variable1, Variable2

Hope this is your expected result

Regards,

Rajesh

Hai AVB,

TRy out this check constraint , Hope this will suit your requirement make slight changes if necessary

create table tlb_test

( tbl_test_id int identity,

RefType varchar(20) null,

EngCode...

Thanks steve,

I did the same and it worked fine

Regards,

rajesh

Thanks Greg,

I did that and worked fine

Thanks and regards,

Rajesh

Many Thanks for your Kind Information

so,now i think it is better to create another table instead of changing the identity increment as you suggested

Regards,

Rajesh

Hi Zahran,

The Code You Suggested will only change the identity start value,but i want to change the identity increment value by other increment value.

For eg: Currently, i have an identity...

Here is what I am trying to do

GO

CREATE ASSEMBLY ActiveDCom FROM '\Comms\ADCom\ActiveDirectoryCom.dll'

WITH permission_set = unsafe

go

CREATE Aggregate ADUserFullName

...