Forum Replies Created

Viewing 15 posts - 256 through 270 (of 402 total)

  • RE: How to make a UPDATE

    inf1154 (5/2/2012)

    thanks it walk but i gat another problem please it is in german

    /**

    * when i try to change this operator '= ' to 'IN' i get 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 2, 2012 at 3:27 am

    #1482252

  • RE: visibility/hidden property

    It's happened to us all at one point or another! No probs glad to help 🙂

    ==========================================================================================================================
    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 1, 2012 at 12:16 pm

    #1481986

  • RE: SSC Points System?

    Grant Fritchey (5/1/2012)

    Yep. A point per post. Varying points for the Question of the Day. So this is +1.

    At +12K points you must know the points system inside and out...

    ==========================================================================================================================
    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 1, 2012 at 8:08 am

    #1481804

  • RE: visibility/hidden property

    First will take the first row in the dataset (after all sorting ect) so in this case its not needed as we want all rows to be evaluated

    Cheers

    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 1, 2012 at 7:32 am

    #1481789

  • RE: visibility/hidden property

    Does this help?

    =iif(Fields!related_ticket.Value = " ", true, false)

    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 1, 2012 at 2:11 am

    #1481628

  • RE: varchar desc order

    BrainDonor (5/1/2012)

    One way to do this:

    CREATE TABLE #Temp(

    Rack_LocationVarChar(50)

    );

    INSERT INTO #Temp(Rack_Location)

    VALUES('c1'),

    ('c10'),

    ('c25'),

    ('c100'),

    ('c3'),

    ('c102'),

    ('c12'),

    ('c2');

    select *

    from #Temp

    order by Rack_Location;

    select...

    ==========================================================================================================================
    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 1, 2012 at 1:47 am

    #1481623

  • RE: varchar desc order

    Hi

    Assuming you only ever have one non numeric character at the beginning this should do the trick:

    DECLARE @TEMP AS TABLE

    (VALS VARCHAR(10))

    INSERT INTO @TEMP

    SELECT 'c1' union all

    SELECT 'c10' union all

    SELECT 'c100'...

    ==========================================================================================================================
    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 1, 2012 at 1:44 am

    #1481620

  • RE: First date of month for all date

    Using a Function is not the best was as it will have a negative impact on query performance.

    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

    April 30, 2012 at 8:14 am

    #1481260

  • RE: First date of month for all date

    These return DateTime the OP wanted Varchar :hehe:

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

    April 30, 2012 at 7:24 am

    #1481225

  • RE: First date of month for all date

    Hi

    Does this help?

    DECLARE @Date DATE = '13-05-2012'

    SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@Date)-1),@Date),112) AS Date_Value

    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

    April 30, 2012 at 7:21 am

    #1481221

  • RE: SSC Points System?

    A point per post I believe.

    You can also get points for answering the question of the day correctly the amount of points depends on how many have been allocated 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

    April 30, 2012 at 3:27 am

    #1481085

  • RE: Pull back up to the first Carridge Return

    Are you certain its a carrage return?

    This works

    SELECT Addr,

    CHARINDEX(CHAR(10), Addr, 1),

    LEFT(Addr, CHARINDEX(CHAR(10), Addr,...

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

    April 26, 2012 at 9:56 am

    #1479873

  • RE: Pull back up to the first Carridge Return

    Ryan Keast (4/26/2012)

    Thanks. I tried your code but get the following error -

    (2 row(s) affected)

    Server: Msg 536, Level 16, State 3, Line 1

    Invalid length parameter passed to the substring...

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

    April 26, 2012 at 9:44 am

    #1479859

  • RE: Pull back up to the first Carridge Return

    Edited as misread post

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

    April 26, 2012 at 9:24 am

    #1479831

  • RE: Datamart Design Methodology

    There are LOADS of links on the web here is one for the Kimball website, I'm not saying this is the definitive place to look for ideas and strategies but...

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

    April 26, 2012 at 7:54 am

    #1479737

Viewing 15 posts - 256 through 270 (of 402 total)