Forum Replies Created
Viewing 15 posts - 181 through 195 (of 1,468 total)
-
Reply To: can not get cursor to work for me
CursorID is an integer, not a collection.
You need to declare a variable for each field that the cursor returns
-
Reply To: Simple sort makes query hang
SQL does not necessarily evaluate a CTE or sub-query when you think it does. It will un-nest them if it believes that it is more efficient to do so.
Watch the...
-
Reply To: Simple sort makes query hang
pdanes wrote:...
5. 6070. As I wrote in the initial post, I would expect the inner query to return these rows, a fairly small number, then give me the top one...
-
Reply To: startdate -1
The following code satisfies your requirement
SELECT t.Testid
, t.Status
, t.Startdate
... -
Reply To: startdate -1
So, taking a guess at what you are looking for ....
WITH cteData AS (
SELECT t.Testid
, t.Status
... -
Reply To: startdate -1
Shree23 wrote:I have repeated and loaded the insert statement
insert into table3 values ('1','Progress', '20210203'), ('1', 'Closed', '20220403'), ('2', 'Closed', '20220703'), ('2', 'Progress', '20220503')
it is showing wrong output
How to post data/code on a forum to get the best help.
Reply To: startdate -1
You are on the right track.
SELECT t.Testid
, t.Status
, t.Startdate
, EndDate = DATEADD(dd,...
Reply To: startdate -1
Your expected output is inconsistent.
That said, I believe that you need to look at the LAG function.
Reply To: Compare columns within the same row
I would add a priority field and add it to the order by.
So, using Scott's code, it would now look like this ...
SELECT d.ID, ca1.Amt, ca1.AmtReason
FROM #data...
Reply To: JSON structure positioning
I know nothing of JSON, but this looks like it is doingwhat you are trying to do
https://docs.microsoft.com/en-us/sql/t-sql/functions/json-modify-transact-sql?view=sql-server-ver15
Reply To: Get the Suggested employee to assign ticket
This looks like you are trying to create a catch-all query. You are on a slippery slope.
I have never worked with geometry data types before, but after a quick google,...
Reply To: Windows function : difference b/w current row and prev row of different column
Is there a difference in using an alias using the AS keyword as opposed to what you have done here for the Prev_end and Numday lines?
Functionally, there is no...
Reply To: Windows function : difference b/w current row and prev row of different column
In order to help us to help you, please provide data in readily consumable format (like this)
IF OBJECT_ID( 'TempDB..#Data', 'U' ) IS NOT NULL
DROP TABLE...
Reply To: row_number dates
You need to GROUP BY v.PatID, v.ProcValDate
Below is an expanded data set, with options to add "RN" by both the DateTime, and just the Date
IF OBJECT_ID( 'TempDB..#value',...
Reply To: performance question
You are correct in assessment of the field def....a catch all... so how in CODE based upon what I supplied can it be fixed?
Thanks.
The only way to get rid...
Viewing 15 posts - 181 through 195 (of 1,468 total)