Forum Replies Created

Viewing 15 posts - 16 through 30 (of 49 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 ?

    First solve the problem then write the code !

    October 16, 2017 at 4:47 am

    #1963782

  • RE: T-SQL Help on same table join

    Phil Parkin - Sunday, October 15, 2017 4:39 PM

    This query gets you part of the way there, I think:
    SELECT a.Name,
     ...

    First solve the problem then write the code !

    October 16, 2017 at 4:35 am

    #1963779

  • 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))...

    First solve the problem then write the code !

    October 16, 2017 at 4:14 am

    #1963778

  • RE: Trigger error and comments on it ?

    slava_th - Saturday, October 14, 2017 1:03 PM

    Hello,

    I have multiple triggers which do similar things, like updating some summary field of one...

    First solve the problem then write the code !

    October 16, 2017 at 2:59 am

    #1963769

  • RE: Query Help

    lkennedy76 - Friday, October 13, 2017 1:14 PM

    I have been look at this all day and need some other eyes, when I...

    First solve the problem then write the code !

    October 15, 2017 at 6:47 am

    #1963724

  • RE: Could not delete from specified MS access tables from SSIS execute task

    bjeyakumar 89545 - Wednesday, October 11, 2017 11:38 PM

    I am working in  migration project to upgrade current sql  server 2008 SSIS jobs...

    First solve the problem then write the code !

    October 12, 2017 at 12:42 am

    #1963314

  • RE: Compare two columns

    Thom A - Monday, October 9, 2017 9:18 AM

    Using the vTally table, i created a table with 10,000,000 rows:
    SELECT TOP 10000000 *,...

    First solve the problem then write the code !

    October 9, 2017 at 9:22 am

    #1962850

  • RE: Compare two columns

    Thom A - Monday, October 9, 2017 8:53 AM

    TheCTEGuy - Monday, October 9, 2017 8:50 AM

    First solve the problem then write the code !

    October 9, 2017 at 9:01 am

    #1962844

  • RE: Compare two columns

    Thom A - Monday, October 9, 2017 8:42 AM

    TheCTEGuy - Monday, October 9, 2017 8:00 AM

    First solve the problem then write the code !

    October 9, 2017 at 8:50 am

    #1962841

  • RE: 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 =...

    First solve the problem then write the code !

    October 9, 2017 at 8:00 am

    #1962827

  • 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...

    First solve the problem then write the code !

    October 6, 2017 at 11:35 pm

    #1962718

  • RE: Comparing 2 functions for any differences in the result set.

    Phil Parkin - Friday, October 6, 2017 6:43 AM

    TheCTEGuy - Friday, October 6, 2017 4:53 AM

    First solve the problem then write the code !

    October 6, 2017 at 6:50 am

    #1962607

  • RE: Assistance with Query

    SQLSACT - Friday, October 6, 2017 5:06 AM

    Hello All
    I have the following table...

    CREATE TABLE [dbo].[Space](
        [DBName] [varchar](128) NOT NULL,
        [BFileName] [varchar](128) NOT...

    First solve the problem then write the code !

    October 6, 2017 at 6:42 am

    #1962604

  • RE: Comparing 2 functions for any differences in the result set.

    Here is something strange i found   - Can anyone help me explain why is this that the scan counts are less in the below code

    declare...

    First solve the problem then write the code !

    October 6, 2017 at 5:11 am

    #1962594

  • RE: Comparing 2 functions for any differences in the result set.

    Hey Luis - Please review the code below - will this perform better from your code -

    declare @st datetime = DATEADD(YY, DATEDIFF(YY, 0, GETDATE())...

    First solve the problem then write the code !

    October 6, 2017 at 4:53 am

    #1962593

Viewing 15 posts - 16 through 30 (of 49 total)