Forum Replies Created
Viewing 15 posts - 166 through 180 (of 10,143 total)
-
RE: SQL Query Modification Request
carlton 84646 - Friday, December 21, 2018 6:28 AMChrisM@Work - Friday, December 21, 2018 6:20 AMRE: SQL Query Modification Request
carlton 84646 - Friday, December 21, 2018 6:16 AMChrisM@Work - Friday, December 21, 2018 6:12 AMRE: SQL Query Modification Request
carlton 84646 - Friday, December 21, 2018 6:09 AMThe expected results should look like the following:
This will only take moments...
RE: Help Needed in Date logic
DECLARE @AppDate DATETIME = '2014-01-01'SELECT
[Month] = UPPER(LEFT(DATENAME(month,StartDate),3)),
StartDate,
[enddate] = CAST(EOMONTH(StartDate) AS DATETIME)
FROM (
SELECT TOP(DATEDIFF(MONTH, @AppDate, GETDATE())+1)
StartDate = DATEADD(MONTH, ROW_NUMBER() OVER(ORDER BY (SELECT...RE: Run away logical reads on stored proc causing timeouts.
With a lengthy output column list and only a few rows in the result set, this query is made for a key lookup using a skinny index to pack as...
RE: Hi Team , Please help.. I have data in one table based on same id we have data some specific column i need to get first NOT NULL value . Incase in 1st row NULL second row 200 3rd roe 300 we have i need to select second row 200 only.
DBA.A - Monday, December 17, 2018 6:56 AMRE: COALESCE Issues when controlling logic in a tvf
Try this, Steve. I've done something similar before:
SELECT MySecurityToken = COALESCE(d.c1, x1.c2, x2.c3, x3.c4)
FROM (SELECT c1 = MAX(something) FROM Table1) d
OUTER APPLY (SELECT c2 = MAX(something)...RE: TOP vs Max/Min: Is there a difference?
Mike, the more complex plan with nested loops etc is associated with the way you've chosen to assign the query result to the variable, not to the TOP operator itself.RE: Can it be improved again?
Run the two UNIONed queries separately to confirm that it’s the lower one which is the pain point. Assuming it is, strip away the...
RE: Can it be improved again?
-- Step 1: replace all of the subqueries with their APPLY equivalent:
SELECT
d.part_code,
x1.part_desc,
x2.specification,
d.odr_ref, d.dbcode, crcode,
d.ref_no, d.date, d.source, d.unit_cost,...RE: Logical Drives on a Solid State Platter
Jeff Moden - Monday, December 10, 2018 8:27 PM
