Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 4,820 total)

  • RE: Remove a value from a union

    Meatloaf (6/23/2015)

    Hi,

    I have created a phone list and am using a union to be able to display letter category. However, what I would like to do is only show...

    June 24, 2015 at 8:29 am

    #1807765

  • RE: SQL 2008 - DTS export to Excel failing

    balasach82 (6/24/2015)

    ERROR is same for all these failures.

    IN CMD, I use DTSRUN /S SERVERNAME / E /N DTSNAME

    The same query is also used in job. CMD is executing from my...

    June 24, 2015 at 8:22 am

    #1807760

  • RE: Problem with trigger

    g5808599 (6/24/2015)

    Hello to everyone,

    0

    down vote

    favorite

    I've got this problem with this exercise apologize that we insert into the table friends that at start is empty some couple of friends

    Table Friends:

    ...

    June 24, 2015 at 7:59 am

    #1807749

  • RE: query about nulls

    sqlfriends (6/23/2015)

    I would like to query for two columns- either of the two returns null but not both.

    For example:

    If I use this

    Select * from students

    where requirementGradYear is null or...

    June 24, 2015 at 6:34 am

    #1807718

  • RE: SQL 2008 - DTS export to Excel failing

    balasach82 (6/22/2015)

    To further add, the DTS when run from Windows batch/command file runs fine. ONly when the dts is run from Job (using DTSRun), it fails with the error.

    Exactly what...

    June 23, 2015 at 2:47 pm

    #1807565

  • RE: get sql error why , can I not use one with block with 2 update statements

    Jacob Wilkins (6/22/2015)

    A CTE's scope is limited to the statement immediately following its definition, which is why the second UPDATE is throwing that error.

    There are a few things you could...

    June 23, 2015 at 7:32 am

    #1807349

  • RE: PERCENT_RANK()

    CPiacente (6/22/2015)

    I know floating is used for the data type for percent_rank(). I tried changing to something in a previous post but that didn't change the output at all.

    If you...

    June 23, 2015 at 7:14 am

    #1807341

  • RE: Replication delays

    steve.roberts 86619 (6/23/2015)

    Hi,

    I have two subscribers to a database replication. One in a data center 200 miles away and the other subscriber in the same rack.

    When I insert a tracer...

    June 23, 2015 at 6:47 am

    #1807327

  • RE: Looking for a better script

    adams.squared (6/22/2015)

    The question is about the joins. Not the actual data. If I presented you with all the scripts involved, it'd take you a couple of days to...

    June 22, 2015 at 1:46 pm

    #1807180

  • RE: executing a cte

    Luis Cazares (6/22/2015)

    I don't know Steve. For instance, I don't like to filter using joins as it won't make the intention evident. On the other side, I believe that you...

    June 22, 2015 at 1:29 pm

    #1807173

  • RE: Looking for a better script

    adams.squared (6/22/2015)

    You guys are making this more complicated. Forget the values. They are random and meaningless. Forget about trying to make an efficient route, I do not...

    June 22, 2015 at 12:53 pm

    #1807160

  • RE: Looking for a better script

    adams.squared (6/22/2015)

    The part is the part #. The initial data set is all the customers with that part. What the part is doesn't really matter either except that they...

    June 22, 2015 at 11:42 am

    #1807126

  • RE: executing a cte

    djj (6/22/2015)

    Thank you ChrisM@Work, I will not be changing the code now that I have conformation of what it does.

    It's always good to understand what code does before you change...

    June 22, 2015 at 11:25 am

    #1807122

  • RE: Looking for a better script

    I don't have a clear understanding of the data, nor am I sure exactly what the end goal is. You appear to be indicating that for a given...

    June 22, 2015 at 8:04 am

    #1807035

  • RE: PERCENT_RANK() problems

    CPiacente (6/22/2015)

    I probably will have to find another way but I have hundreds of records and in some case thousand or more. I will check that out however.

    I can't imagine...

    June 22, 2015 at 7:45 am

    #1807031

Viewing 15 posts - 3,601 through 3,615 (of 4,820 total)