Viewing 15 posts - 1,546 through 1,560 (of 4,087 total)
I think the error is in your logic, not in the functionality. I'm not sure what you're expecting the MIN of the ROW_NUMBER to produce, but it will always be...
November 3, 2017 at 8:50 am
Use a CTE to filter your target table.
Is the CTE able to make use...
November 3, 2017 at 8:24 am
November 3, 2017 at 8:13 am
You don't want to do this - at least not this way. You're trying to convert a denormalized table into a different kind of denormalized table. What you need to...
November 2, 2017 at 1:51 pm
November 2, 2017 at 11:53 am
I need to join two tables together - Master and Detail
Master Table:ID...
November 2, 2017 at 8:08 am
Use a CTE to filter your target table.
WITH Tgt AS (
select T.*
FROM @Targettable T
INNER JOIN @FilterTable f on t.bid = f.id
WHERE...
October 31, 2017 at 8:57 am
Joe,
First, don't you think it's time...
October 31, 2017 at 8:44 am
DECLARE @ClosedStuff TABLE...
October 31, 2017 at 8:21 am
October 31, 2017 at 8:06 am
use tempdb;
go
create table...
October 30, 2017 at 2:26 pm
The part in parentheses is just a Table Value Constructor and the v(TemplateName, Val) is just providing aliases for the fields returned by the Table Value Constructor. The CROSS APPLY...
October 26, 2017 at 11:35 am
October 26, 2017 at 10:18 am
Viewing 15 posts - 1,546 through 1,560 (of 4,087 total)