Tuesday, December 8, 2009

the query did it

Creating a query tu update a field in a new table with the same data to be filled in with.

--== the query who did the miracle
select 'update operator set operation = %' + Operation+'%', 'where id = ',' ' +id+'','%' from mySourceDataBase.dbo.Operator

--== the result

update operator set operation = '{0}.Contains("{1}")' where id = 1
update operator set operation = '{0}.NotContains("{1}")' where id = 2
update operator set operation = '{0}.StartsWith("{1}")' where id = 3
update operator set operation = '{0}.EndsWith("{1}")' where id = 4
update operator set operation = '{0} == "{1}"' where id = 5
update operator set operation = '{0} != "{1}"' where id = 6
update operator set operation = '{0} > "{1}"' where id = 7
update operator set operation = '{0} < "{1}"' where id = 8
update operator set operation = '{0} >= "{1}"' where id = 9
update operator set operation = '{0} <= "{1}"' where id = 10
update operator set operation = '{0} == ""' where id = 12
update operator set operation = '{0} != ""' where id = 13
update operator set operation = '{0} == {1}' where id = 18
update operator set operation = '{0} != {1}' where id = 19
update operator set operation = '{0} > {1}' where id = 20
update operator set operation = '{0} < {1}' where id = 21
update operator set operation = '{0} >= {1}' where id = 22
update operator set operation = '{0} <= {1}' where id = 23
update operator set operation = '{0} == DateTime.Parse("{1}")' where id = 31
update operator set operation = '{0} != DateTime.Parse("{1}")' where id = 32
update operator set operation = '{0} > DateTime.Parse("{1}")' where id = 33
update operator set operation = '{0} 'fickler' where id = 34
update operator set operation = '{0} >= DateTime.Parse("{1}")' where id = 35
update operator set operation = '{0} <= DateTime.Parse("{1}")' where id = 36
update operator set operation = '{0} = {1}' where id = 57
update operator set operation = '{0} <> {1}' where id = 58


No comments: