... rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows
This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes ...
... JOIN
[EQUIPMENT] eq
ON
eq.EquipId=re.EquipId
WHERE
re.RoomId=@GivenRoom
AND
re.SetId=@setId
This seems to have problems because when there are no matching rows (so zero results), BIDS ...
... to do the following:
-- 1) Migrate all users except any matching the new admin in J30
-- 2) Migrate user who's ID in J15 matches the new admin ID in J30
-- 3) Recover odduser's ne ...
... Name] ''
Note that this excludes all the data that doesn't have a matching label. Which can be a major part of your charts if this is a normal part of your database. In my example, the team members ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.