yes that is pretty easy to select them and check what value is there its just the update i am struggling with. here is the select

select P.Id, P.Desc...

you are right, but for now i think if you have the expertise for such an update statement please let me know.

thanks

Yes but what for existing users, they are already in different locations and i think this is the best way to do it.

any ideas??

i need an if else in my...

the logic is to trace where the user is in the application at a certain period, and display the information on the application accordingly. So i added a column and...

Please forgive my dumbA** the insert will automatically add teh new seed if the identity specification is assigned to increment by 1. but i would still like to know...

thanks LAurie

however when i use the query in production environment i get the same result 4 times is there any other way i can accomplish this

I have to drop the column after i drop the contraint, unless i can force a column drop that have binding values somehow

thanks for the reply i also have to make sure that the date is between last two days or 10 days as

ID Date User action

1 8/4/2012 12:10:36 A Something

2 8/4/2012...

I changed the trigger but the trigger is still now working , any suggestions ??

CReate Trigger [AddDate] on [dbo].[Status]

for Update,Insert ...

I am using the replace function, the problem is that it never goes to the else part it will always find the first part of the statement

Sorry for the confusion,

yes i have to insert into table A and then ensure that similar ID's are concatenated into a single row of data as i displayed in my...

Thankyou

now the issue is that there are multiple Rows that have similarID's and i need to update columns with same ID's into a single row, I think i can use...

thanks for the script, I did get the answer i don't believe there is any way we can delete multiple tables( the whole table with the contents in it, not...

Sorry for the confusion

This is what i am trying to do

whenever a product or products are made inactive on the company table i want to make that company inactive...

Thanks Jason

as i sort of knew it was hihgly unlikely but i just wanted to see if someone had an idea

thanks again