You guys are my lifeblood, but I know I find myself more and more extending into pure SQL issues.
Can anyone recommend a good MS SQL forum for more advanced topics?
Along with that, if anyone has any experience with the following scenario, I'd appreciate any feedback. I seem to have lost my ability to paste into this window, so I'll summarize.
Through MS SQL Studio, I've linked to a second server. I run a query against the second server just fine.
Now I add a link to a table on the local server. The second server has an Invoice number that's actually type char(22), and the local server has Invoice number as type int. I link as 2nd.InvoiceNum = cast(Local.InvoiceNum as char(22))
SQL doesn't argue but when I try to pull that data from the local server, everything comes up as NULLs. When I add another link that's one to many, the row count doesn't increase.
That may be a bit too succinct, but I don't want to get into too much detail, unless I think someone has a notion about this.
Like I said previously, if anyone know some good support forums, I'd be grateful!