Forum Replies Created
Viewing 15 posts - 2,116 through 2,130 (of 2,645 total)
-
RE: Multiple disparate UPDATE statements in a SP
The END is just the end of a CASE statement.
If it runs already with no errors why do you think it might not run? -
RE: Finding recent date from two tables
Brandie Tarvin - Monday, October 15, 2018 11:15 AMsgmunson - Monday, October 15, 2018 10:19 AMRE: Is this query correct ?
Brandie Tarvin - Monday, October 15, 2018 11:04 AMRE: Finding recent date from two tables
;WITH CTE AS
(
SELECT MAX(X.TABLE_1Dates) NewestDate -- Newest Date From TABLE_1
FROM TABLE_1 A
CROSS APPLY(VALUES (A.StartDate),(A.EndDate)) X(TABLE_1Dates)
),
CTE2 AS
(
SELECT...RE: The long identifier
Budd - Monday, October 15, 2018 7:22 AMRE: Sorting by a column when the name is derived via a CASE statement
j.clay 47557 - Monday, October 15, 2018 8:09 AMThanks j.clay,
I think you would be better putting...RE: Is this query correct ?
Thom A - Monday, October 15, 2018 7:43 AMspectra - Monday, October 15, 2018 7:33 AMRE: Sorting by a column when the name is derived via a CASE statement
j.clay 47557 - Monday, October 15, 2018 7:40 AMRE: Are the posted questions getting worse?
Jeff Moden - Monday, October 15, 2018 7:35 AMRE: Is this query correct ?
spectra - Monday, October 15, 2018 2:50 AM
I dont understand the red marked part in my book.
Is this query...
RE: Sorting by a column when the name is derived via a CASE statement
j.clay 47557 - Monday, October 15, 2018 6:17 AMRE: SQL Server Restart
Admingod - Friday, October 12, 2018 4:01 PMRE: Multiple lines text insert into varchar(Max) column
adonetok - Friday, October 12, 2018 7:45 AMRE: Anyone see a problem with this?
I'm not sure from your question what the column name is for a person? but you would need a query like this to get the most recent row for each...
Viewing 15 posts - 2,116 through 2,130 (of 2,645 total)
