asked on Merge two queries into one
I want to merge the query into one
select id
from dbo.table1 with(nolock)
where cid = 622
if recordfromabove neq form.value then proceed the follow code
update table1
set id = 22
where cid = 622
Microsoft SQL ServerSQL
Last Comment
slightwv (䄆 Netminder)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
both the above are failing, if i try, think it like this
<cfquery name="getinfo">
select id
from dbo.table1 with(nolock)
where cid = 622
</cfquery>
<cfif GetInfo.id NEQ arguments.id>
update table1
set id = #arguments.id#
where cid = 622
</cfif>
I see no need to select the id first then update. A single update should work fine.
Can you post sample data and expected results based on the arguments.id value selected?
Can you post sample data and expected results based on the arguments.id value selected?
Open in new window