Forum Replies Created
Viewing 15 posts - 16 through 30 (of 48 total)
-
RE: T-SQL Help on same table join
But the CTE has restricted to 2 cols only, as the table is BIG; retricting extra columns would be beneficial. Right ? -
RE: T-SQL Help on same table join
Phil Parkin - Sunday, October 15, 2017 4:39 PM -
RE: How to get columns which has null's
Try this and please let me know if that makes sense..SELECT CASE
WHEN (SUM(a.ISC1Null)+SUM(a.ISC2Null)+SUM(a.ISC3Null)+SUM(a.ISC4Null)) %3 = 0 THEN 'c1,c2,c3,c4'
WHEN (SUM(a.ISC1Null)+SUM(a.ISC2Null)+SUM(a.ISC3Null))... -
RE: Trigger error and comments on it ?
slava_th - Saturday, October 14, 2017 1:03 PM -
RE: Query Help
lkennedy76 - Friday, October 13, 2017 1:14 PM -
RE: Could not delete from specified MS access tables from SSIS execute task
bjeyakumar 89545 - Wednesday, October 11, 2017 11:38 PM -
RE: Compare two columns
Thom A - Monday, October 9, 2017 9:18 AM -
RE: Compare two columns
Thom A - Monday, October 9, 2017 8:53 AMTheCTEGuy - Monday, October 9, 2017 8:50 AMRE: Compare two columns
Thom A - Monday, October 9, 2017 8:42 AMTheCTEGuy - Monday, October 9, 2017 8:00 AMRE: Compare two columns
Don't know if this suffice the requirement. Below code is efficient than the above
select b.*,a.quantity from orders a
right join orders b
on a.orderid =...RE: Comparing 2 functions for any differences in the result set.
Jeff - Thanks for that article. It seems rCTEs are a performance bottlenecks. But the code above doesn't give wrong results.
Luis - i don't have scripts of functions...RE: Comparing 2 functions for any differences in the result set.
Phil Parkin - Friday, October 6, 2017 6:43 AM
