Forum Replies Created

Viewing 15 posts - 12,346 through 12,360 (of 26,486 total)

  • RE: Aggregating counts and getting cumulative counts by date

    CELKO (4/28/2012)

    You do not know that rows are not records. Since the crap you did post has only no null-able columns by definition is not a table. You do not...

    April 29, 2012 at 9:50 pm

    #1481018

  • RE: ssis do

    asranantha (4/28/2012)

    Hi Friends ,i have small doubt in ssis packages.

    suppose iam executing one package that time its take 5 minutes and next day i execute same...

    April 28, 2012 at 4:08 am

    #1480831

  • RE: How to create dynamic function

    poornipmca (4/28/2012)

    can u help me by telling what type of problems i may face by choosing any of this method

    CLR functions

    dynamic functions

    Every customer gets their own set of tables in...

    April 28, 2012 at 4:04 am

    #1480829

  • RE: How to create dynamic function

    poornipmca (4/27/2012)

    can any one help me out to choose with method will be suitable for multiple databases.

    1. Dynamic sp

    or

    2.clr functions.

    You really need...

    April 27, 2012 at 11:32 pm

    #1480795

  • RE: Sql Query to find invalid SSN Numbers

    capn.hector (4/27/2012)

    mwaniki1 (4/27/2012)

    I guess am not getting your question because i don't need to validate anything all i need is a query that returns any Employees (id, ssn, and name)...

    April 27, 2012 at 7:11 pm

    #1480782

  • RE: Sql Query to find invalid SSN Numbers

    mwaniki1 (4/27/2012)

    I guess am not getting your question because i don't need to validate anything all i need is a query that returns any Employees (id, ssn, and name) with...

    April 27, 2012 at 5:11 pm

    #1480772

  • RE: Sql Query to find invalid SSN Numbers

    mwaniki1 (4/27/2012)

    Basically looking to use a JOIN on the two tables to find invalid ssn using the invalid rules listed.

    You keep saying join to validate. What are you joining...

    April 27, 2012 at 4:17 pm

    #1480765

  • RE: insert into table variable

    ORDER BY

    CASE WHEN <whatever the column name is> LIKE 'Performance%' then 1 ELSE 0 END,

    <next column to order by>

    April 27, 2012 at 3:55 pm

    #1480755

  • RE: Sql Query to find invalid SSN Numbers

    To what level of validation are you attempting to complete?

    April 27, 2012 at 3:46 pm

    #1480751

  • RE: Are the posted questions getting worse?

    capn.hector (4/27/2012)

    L' Eomot Inversé (4/27/2012)

    Lynn Pettis (4/27/2012)

    L' Eomot Inversé (4/27/2012)

    GilaMonster (4/27/2012)

    Lynn Pettis (4/27/2012)

    Gail, without really digging into this, isn't this just an expensive NOP?

    Yup.

    On the plus side, SQL's smart enough...

    April 27, 2012 at 3:08 pm

    #1480736

  • RE: T-SQL Programming Query

    Sean Lange (4/27/2012)

    That can be complicated for sure. I have been in that situation and the way I handled it was to make the process a little more formal. After...

    April 27, 2012 at 3:00 pm

    #1480728

  • RE: insert into table variable

    Tables do not provide order, nor is there any guarantee of order. You must provide that order by using an ORDER BY on the select clause pulling the data...

    April 27, 2012 at 2:54 pm

    #1480718

  • RE: T-SQL Programming Query

    TeraByteMe (4/27/2012)

    That is the rosey side of it. But what do you do when their business requirements contradic themselves? When they refuse to see that they do and the next...

    April 27, 2012 at 2:51 pm

    #1480715

  • RE: T-SQL Programming Query

    Yes, and what makes you think we made things work out?

    It is frustrating. One question, when you are trying to explain the why not's are you talking techno-babel or...

    April 27, 2012 at 2:36 pm

    #1480697

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/27/2012)

    Lynn Pettis (4/27/2012)

    L' Eomot Inversé (4/27/2012)

    GilaMonster (4/27/2012)

    Lynn Pettis (4/27/2012)

    Gail, without really digging into this, isn't this just an expensive NOP?

    Yup.

    On the plus side, SQL's smart enough not to log...

    April 27, 2012 at 2:28 pm

    #1480690

Viewing 15 posts - 12,346 through 12,360 (of 26,486 total)