Forum Replies Created
Viewing 15 posts - 1 through 15 (of 53 total)
-
RE: Maximum of date values
saintor1 - Tuesday, January 8, 2019 7:12 AM -
RE: sum a column value till a specific value and get after howmany times of sum its equal
Neil Burton - Tuesday, January 8, 2019 1:35 AM -
RE: Quoting Identifiers
Though I chose the option that has been marked correct, think the more appropriate answer would be "None of these. QUOTENAME() takes only one parameter" as the second...
-
RE: Write Conflict
barry.nielson - Monday, August 20, 2018 5:31 PM -
RE: Upper Case Lower Case
rjjh78 - Tuesday, May 1, 2018 9:14 AM -
RE: ASCII ProperCase Function
Michael L John - Tuesday, December 12, 2017 8:20 AMRE: ASCII ProperCase Function
Michael L John - Monday, December 11, 2017 11:11 AMRE: ASCII ProperCase Function
ChrisM@Work - Monday, December 11, 2017 9:57 AMRE: ASCII ProperCase Function
Note also that the semicolon is a statement terminator, not a statement initiator.
Noted, thank you.
Convert this to an iTVF and your performance gain will be greater still.
RE: ASCII ProperCase Function
Nicely done, but there are couple of drawbacks
1. The function doesn't handle the non-alpha characters in the input string. See what happens if you use ' CONVERT tHis to 1...RE: help with query
Try the below code
SELECT * FROM Test AS A
WHERE A.Type = 'Non-IT'
AND NOT EXISTS
(SELECT 1 FROM Test AS B
WHERE A.ID = B.ID
AND B.Type = 'Manager')
RE: Ranking the Records
kiran.rajenimbalkar (6/26/2015)
Thanks Sir,its working fine for few columns but I do have more then 5 columns in my sql and its not giving the proper ranking using DENSE_RANK function so...
RE: Ranking the Records
Try the below code
SELECT DENSE_RANK() OVER (ORDER BY id,NAME) AS rnk
,id
,NAME
,order_key
,order_key_rank
FROM abc_order
ORDER BY order_key
,order_key_rank
Viewing 15 posts - 1 through 15 (of 53 total)
