Viewing 6 posts - 1 through 6 (of 6 total)
This is what we actually came up with after all the great help on here to fuel the brain:
Update [ad import]
Set ADBU =
replace (substring([distinguished name],
patindex('%Workstations,OU=%', [distinguished name] )+
charindex(',',...
March 4, 2010 at 5:57 am
lmu92 (3/2/2010)
There are numerous solutions available.
One pretty fast solution is described at the end of the Tally Table article referenced in...
March 2, 2010 at 10:57 am
Christopher Stobbs (6/17/2009)
As requested above could you post the...
June 17, 2009 at 7:30 am
Christopher Stobbs (6/17/2009)
try this:
UPDATE isd
SET [rstatus*] = i.[rstatus*]
FROM dbo_ISD_Lease isd
LEFT JOIN [dbo_Remedy Import] i ON isd.spconcat = i.rconcat
WHERE isd.[rstatus*] != i.[rstatus*]
edit:
YOU MIGHT WANT TO PUT AN INNER JOIN THERE
not...
June 17, 2009 at 6:18 am
Florian Reischl (6/17/2009)
Do your column names really contain "*" or are you about to create a old style LEFT JOIN?Flo
Yes, my columns really do have an * in them. ...
June 17, 2009 at 6:16 am
Um, not sure what the i is for? was that shorthand?
June 17, 2009 at 6:15 am
Viewing 6 posts - 1 through 6 (of 6 total)