DAMMIT!!    I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!

Does anyone still follow this thread, and if so, can you give...

I ask because you can get a fairly efficient solution to the example above using the LAG() function instead of a join.   But this assumes that there are no other...

• This reply was modified 3 years ago by  The Dixie Flatline.

Edited to rephrase my question:

What if there were two 'F' rows preceding the 'S' row?

Do you only want data from the most recent 'F' row, prior to the 'S' row?

Will...

Jeff, one of the best things I ever heard about comments is this:

Comments don't exist to describe what the code is doing.    They exist to describe what the code...

Why go to all the work of coding a cursor?    It's easy enough to do set-based if you CROSS APPLY the STRING_SPLIT() function.

SELECT [ID], [SubName] =...

Just avoiding single aliases as a rule doesn't keep developers from using aliases like a1, a2, etc.     When there are just a few joins, I've never understood the panic...

A "band-aid" for complex multiline table-valued functions is to use them only to write the data out to a #temp table, which you can then use for subsequent queries with...

If you include the Vlookup amount in your second table, you won't even require a case statement.

declare @Table1 table (ID int identity(1,1) primary key, Amount int)
insert into...

Just to pile on, COUNT(expr) only counts non-null values, while Count(*)   counts rows.    See below.

declare @table table (RowID int, RowData varchar(20))
insert into @table
values (1,'Hi Mom'), (2,...

Couple of ways to solve this.   First, you could do the following.

1. Use the OUTPUT clause in conjuction with your delete to save the deleted AIDs to  a temporary table.

...

Perhaps.    I was just going by his language that says the columns contain nulls.     I don't think he ever used the words "all" or "only".

Back to Jeff's point, the code as written will only return a hit if ALL rows are NULL for a particular column.   If even one row has a non-null value,...

While I understand at least one reason why CTEs don't automatically generate a spool file for re-use, I have always wondered why there wasn't an object that you could re-use...

You can run the query and output the data as a CSV, which Excel can load as a spreadsheet.

EXCEPT  is great.   But to be clear, it doesn't require that the tables have identical structures, it compares the results of two queries.    You can select a subset of...