-- Solution 2: Join, Subquery, CASE WHEN -- get item_id of the second item (by date) they sold for each user (having only two sales records on or before o1.order_date) ...

Latest commit History History 50 lines (45 loc) · 1.63 KB master SQL-Summary-TSQL / Subquery / Advanced-Subquery / ...

You're assuming that joining against that subquery is bad. Have you profiled it and/or timed it and/or looked at the execution plan? Fetching data is what RDBMSs are designed to do. Doing it over ...

I'm trying to assign rows in a table to a random variable entirely in Transact SQL (This is MS SQL Server 2000, sp3). I've got it working perfectly except I can't use a variable inside my subquery ...