Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: how to clear the sql transaction log?

    Thakns.

    helped a lot.

  • RE: simplifying code

    Jeff Moden (10/21/2007)


    No, no! The Tally table in this code was just to have a table to demonstrate from... I copied it from the previous post that MrPoleCat posted......

  • RE: simplifying code

    Jeff Moden (10/20/2007)


    Not sure what you're trying to do, but here's a different angle... think of it as a "set-based IF" 😀

    SELECT TOP 1

    ...

  • RE: how to remove numbers from strings?

    Jeff Moden (10/20/2007)


    vadimt (10/18/2007)


    the first solution didnt work. because of the Tally i didnt implement.

    i dont need it as a function because i need it only in one place in...

  • RE: simplifying code

    mrpolecat (10/19/2007)


    declare @id int

    select @id =( select top 1 n from tally where n > 5)

    if @id is not null

    begin

    print 'yes'

    print @id

    end

    else

    begin

    print 'no'

    print @id

    end

    thanks.

    i knew it was supposed to be...

  • RE: how to remove numbers from strings?

    Jeff Moden (10/18/2007)


    the first solution didnt work. because of the Tally i didnt implement...

    ps.

    meanwhile the client "revised" some specs, so i do need these numbers now. but i still need...

  • RE: how to remove numbers from strings?

    Max Yasnytskyy (10/17/2007)


    I have found an interesintg function in msdb, seems like it is working much better

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE FUNCTION [dbo].[udfTRANSELATE] (@mixedString AS varchar(max))

    RETURNS varchar(max)

    as

    BEGIN

    DECLARE @resultString...

  • RE: how to remove numbers from strings?

    Greg Snidow (10/17/2007)


    This ought to work. Jeff Moden helped me with a couple of these, and I think this is one of them, but I can not remember exactly,...

Viewing 8 posts - 1 through 8 (of 8 total)