Context: I am preparing this dataset to be used for an SSRS report, my goal is to split the list into about multiple parts (equally) for employees to receive. It will be used as a “task list” of sorts. I have tried two different ways, both of which are causing issues. Attempt #1 – Error is ‘incorrect syntax’: Attempt #2
Tag: ssrs-2008
SQL Query to return last week’s data
I am trying to run a sql query that will return last week’s data to the date. For example, today is Monday. I want to return last Monday’s data only. The prior week to the day. What I am doing is getting last week’s ARAging Snapshot for my company. (What the data was last Monday, compared to this Monday) Here
sql as i required want to calc week based on date of each month 1st day and also want week start and week end date based on week
Answer