Forum Replies Created

Viewing 15 posts - 211 through 225 (of 402 total)

  • RE: The Beer Cooler Thread

    Crabbies is a bit cheaper than Asda and you get a 12 pack case instead of the 8 pack case for a few quid extra

    I think I see a trip...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 31, 2012 at 2:46 am

    #1495055

  • RE: Package setup

    Take a look at this:

    http://www.sqlservercentral.com/stairway/72494/

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 31, 2012 at 2:06 am

    #1495036

  • RE: The Beer Cooler Thread

    I have to say I'm enjoying Crabbies alcoholic ginger beer at the moment

    +10000 !! 😀

    I'm quite fond of Banana Bread Beer - Sounds a bit unusual but it works!

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 31, 2012 at 2:01 am

    #1495034

  • RE: Insert Row Based on Another Row?

    Hi

    You can do this using NOT EXISTS

    DECLARE @TABLE AS TABLE

    (Groups INT, Application VARCHAR (50), PK INT)

    INSERT INTO @TABLE

    (Groups, Application, PK)

    SELECT 1970, 'blogs', 51284 UNION ALL

    SELECT 1970, 'collaboration', 51285 UNION...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 31, 2012 at 1:35 am

    #1495028

  • RE: Need help on transposing rows into columns

    Hi

    You will probably be better posting the DDL's rather than attachments as people may be unwilling to open them

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 30, 2012 at 4:30 am

    #1494553

  • RE: Uses of SubQueries Instead of Join-

    As you are nesting views (which isn't a good thing IMO anyway) within your query in order to script the sub queries for you we would need to see the...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 30, 2012 at 3:06 am

    #1494510

  • RE: datasources issuse

    Not 100% what you mean, but if you mean can you order the sequence that the dataflow executes then yes.

    In your dataflow task start with source 3 , then link...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 30, 2012 at 2:26 am

    #1494492

  • RE: Booked 70-450

    Sure you'll nail it next time Anthony..

    On the up side at least you've had some good news to offset the exam news! 🙂

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 30, 2012 at 2:14 am

    #1494488

  • RE: Uses of SubQueries Instead of Join-

    Thats exactly what I suggested on the original topic http://www.sqlservercentral.com/Forums/Topic1306422-391-4.aspx as the OP wanted to factor in holidays.

    Good places to start on a calendar table are these links

    http://www.sqlservercentral.com/articles/70482/

    http://www.sqlservercentral.com/scripts/Date/68389/

    Thanks...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 30, 2012 at 2:09 am

    #1494484

  • RE: Uses of SubQueries Instead of Join-

    Hi looks like you are trying to work out your Six Sigma phase duration excluding weekends?

    Have you considered using a calendar table for this it could save you quite a...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 30, 2012 at 1:55 am

    #1494477

  • RE: Chrome doesn't render report

    I had the same problem recently so did a bit of digging and it is a known issue

    I haven't tried this yet but this Link may help.

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 29, 2012 at 3:27 am

    #1494045

  • RE: delete data

    How many records are there in total in your table?

    The reason I ask is that you could SELECT the records you want to keep using a SELECT INTO statement to...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 29, 2012 at 1:38 am

    #1493995

  • RE: Reuse view?

    Don't get me wrong we do use views where appropriate I suppose I'm just a little more cautious these days (and maybe a little jaded ;-)) when it comes to...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 28, 2012 at 8:53 am

    #1493834

  • RE: Today, Tomorrow, This Week

    // will this return the current 7 days (This week) or the next 7 days from the current date time?

    The next 7 days from the current date, the SQL...

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 28, 2012 at 8:11 am

    #1493810

  • RE: Limiting the records?

    You could add ROW_NUMBER() in your query and process WHERE ROW_NUMBER() < 10000 , WHERE ROW_NUMBER() BETWEEN 10001 AND 20000 ect

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

    May 28, 2012 at 8:03 am

    #1493803

Viewing 15 posts - 211 through 225 (of 402 total)