matter2003

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

Reply To: Pull data from a set of dates based on multiple criteria

HanShi wrote:
Perhaps this code will get you started. It will extract the current month and calculate the last day of the previous month. In a CASE statement it will determine...

May 1, 2019 at 2:08 pm

#3601590
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

It appears the CROSSAPPLY is giving me the wrong ReportDate to the SUB_QUERY_CREATED_ON dates. I am not sure what is going on as I checked the RetVal and its providing...

March 29, 2019 at 3:54 pm

#2034224
RE: Creating a non-unique index

Jeff Moden? Are you the same person with the awesome splitter function?? I used your version and made a few minor tweaks to have it do what I needed it...

March 28, 2019 at 8:15 am

#2034098
RE: How to Mark a case as a 're-open' if the same Case Id occurred prior to the one being looked at

matter2003 - Wednesday, March 27, 2019 8:23 PM
pietlinden - Wednesday, March 27, 2019 6:31 PM

March 27, 2019 at 10:53 pm

#2034045
RE: How to Mark a case as a 're-open' if the same Case Id occurred prior to the one being looked at

pietlinden - Wednesday, March 27, 2019 6:31 PM
Do you mean like this?

SELECT *
FROM (
SELECT soh.CustomerID
, soh.OrderDate
, LAG(soh.OrderDate,1) OVER (PARTITION BY...

March 27, 2019 at 8:23 pm

#2034041
RE: How to Mark a case as a 're-open' if the same Case Id occurred prior to the one being looked at

pietlinden - Wednesday, March 27, 2019 5:21 PM
You can sort inside the partition. (Using AdventureWorks2008R2)
SELECT soh.CustomerID
, soh.OrderDate
, LAG(soh.OrderDate,1) OVER (PARTITION...

March 27, 2019 at 6:24 pm

#2034038
RE: How to Mark a case as a 're-open' if the same Case Id occurred prior to the one being looked at

pietlinden - Wednesday, March 27, 2019 4:24 PM
Then use LAG() and maybe ROW_NUMBER().
Any record with a non-null LAG() value will be a...

March 27, 2019 at 4:50 pm

#2034033
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

drew.allen - Friday, March 22, 2019 12:23 PM
matter2003 - Friday, March 22, 2019 12:13 PM

March 27, 2019 at 4:19 pm

#2034031
RE: How to Mark a case as a 're-open' if the same Case Id occurred prior to the one being looked at

pietlinden - Wednesday, March 27, 2019 4:08 PM
How far between open/close would count as a "reopen"? You can just use LAG() with...

March 27, 2019 at 4:11 pm

#2034030
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

drew.allen - Friday, March 22, 2019 12:23 PM
matter2003 - Friday, March 22, 2019 12:13 PM

March 22, 2019 at 1:00 pm

#2025274
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

drew.allen - Friday, March 22, 2019 12:04 PM
matter2003 - Friday, March 22, 2019 11:03 AM

March 22, 2019 at 12:13 pm

#2025255
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

Lynn Pettis - Friday, March 22, 2019 11:39 AM
matter2003 - Friday, March 22, 2019 11:22 AM

March 22, 2019 at 11:49 am

#2025248
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

Lynn Pettis - Friday, March 22, 2019 10:55 AM
matter2003 - Friday, March 22, 2019 10:48 AM

March 22, 2019 at 11:22 am

#2025243
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

drew.allen - Friday, March 22, 2019 9:06 AM
Part of the problem is that your UDF is a scalar function (not a table-valued...

March 22, 2019 at 11:03 am

#2025240
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post

Lynn Pettis - Friday, March 22, 2019 8:14 AM
Please post the code for the UDF. Also, did you actually post enough...

March 22, 2019 at 10:48 am

#2025232

Viewing 15 posts - 1 through 15 (of 19 total)