Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 5
Newest
 Editor
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 5 votes cast
Feb
2
accepted Compare Timestamp Difference Between Consecutive Records
Feb
2
revised Compare Timestamp Difference Between Consecutive Records
Added additional information
Feb
2
asked Compare Timestamp Difference Between Consecutive Records
Jan
28
accepted Return Distinct Records by Category Based Multiple Column Values
Jan
28
revised Return Distinct Records by Category Based Multiple Column Values
updated
Jan
28
asked Return Distinct Records by Category Based Multiple Column Values
Jan
27
comment Get 2 Most Recent Records By Product
Works great. Thanks for the help.
Jan
26
accepted Return Bit Value based on previous records by Category
Jan
26
accepted Get 2 Most Recent Records By Product
Jan
26
revised Return Bit Value based on previous records by Category
Added additional information
Jan
26
comment Return Bit Value based on previous records by Category
Sorry about this, but how would the query be modified if requirement was there needed to be 4 or more failures in last six records? So if there were 4, 5, or 6 failures in the last six records FOUROFLASTSIXFAILED would return TRUE. If there were only 1, 2, 3 records for a given MAKEID that would return FALSE because there at least needs to be 4 failures in previous six records. Thanks so much for the help.
Jan
26
comment Return Bit Value based on previous records by Category
Sorry for not being clear. There has to be 4 failures in last 6 records. If there are only 1, 2, 3, 4, or 5 rows that doesnt meet the condition, so would return FALSE. If last 6 had 5 or 6 failures that too doesnt meet condition, so would return FALSE. Thanks.
Jan
26
asked Return Bit Value based on previous records by Category
Jan
26
awarded  Editor
Jan
26
comment Get 2 Most Recent Records By Product
So sorry, but I need additional logic. I added the information in the original post.
Jan
26
revised Get 2 Most Recent Records By Product
Added additional information
Jan
25
asked Get 2 Most Recent Records By Product
Jan
25
awarded  Supporter
Jan
25
accepted Set Value Based on Number of Records with Certain Values using SQL Server
Jan
25
comment Set Value Based on Number of Records with Certain Values using SQL Server
Yes - that will work too. The only criteria is there needs to be three different levels of the same control.