I think I am writing this incorrect somewhere however cannot see it so getting some other eyes on it. If you re-write the query please do from beginning to end because it gets confusing at times.
I think the bold s incorrect however with little sleep I am having trouble. Thanks guys.
use test
go
update testtable
set isdelted = convert(varchar(32), 0x31)
where testcolum in ( 'value', 'value', 'value')
Hi @DBAEng,
what is the data type used for isdelted column and to what value (
convert(varchar(32), 0x31) ..........????
) are you trying to update it.
Add row number which resets to 1 on record column changes 1 Answer
HOw to check Delete indicator. 1 Answer
Solving Simple SQL Query Table Vertical to Horizontal 0 Answers
sql joins 1 Answer