Viewing 3 posts - 1 through 4 (of 4 total)
select @mystring=REPLACE(@mystring,name,value) from @tab
We don't sort tables. The entire relational world is based on the concept that absolutely no assumptions can ever be made on the physical order of...
TommCatt
In theory, there is no difference between theory and practice. In practice, there is.
August 30, 2013 at 1:39 pm
Here's two other ways of doing it. First, write a query returning the rows you want to keep:
-- Query 1
select *
from #UserSession us
where us.LastUpdated...
TommCatt
In theory, there is no difference between theory and practice. In practice, there is.
April 30, 2013 at 6:09 pm
Here's one way not using analytics or outer apply. At first I used a CTE but I removed that to use an inline view instead even though CTE's were not...
TommCatt
In theory, there is no difference between theory and practice. In practice, there is.
April 30, 2013 at 11:40 am
Viewing 3 posts - 1 through 4 (of 4 total)