Viewing 15 posts - 286 through 300 (of 1,248 total)
March 15, 2017 at 7:03 am
You need to include the two columns in the #Temp table that you reference in the subquery. It doesn't matter that they are present in the permanent tables, they need...
March 10, 2017 at 7:13 am
March 9, 2017 at 5:13 am
Do you know when you've explained to a user at least twice that unless they fix their data and pay for the changes necessary to map two entities directly, the...
March 9, 2017 at 1:21 am
I'm absolutely sure that the data didn't change because the only person that could have changed it was me. The report is based on a data warehouse that is loaded...
March 8, 2017 at 6:55 am
March 7, 2017 at 12:14 am
Heh... the reason why Google "doesn't" help here is because you've not Googled enough. 😉 ...
March 6, 2017 at 1:53 am
March 3, 2017 at 8:38 am
February 3, 2017 at 3:14 am
I've gone down a route that doesn't require anything that's not out-of-the-box.
CREATE TABLE #temptbl
(
c1 VARCHAR(100)
)
INSERT INTO #temptbl
SELECT ', , , , ,...
February 3, 2017 at 2:57 am
February 1, 2017 at 8:55 am
February 1, 2017 at 1:13 am
Viewing 15 posts - 286 through 300 (of 1,248 total)