Forum Replies Created

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

  • RE: Correlate dbname and his dbfile (data+log)

    instead of sysfile select the name from master.sysdatabases

    February 8, 2006 at 4:07 am

    #619470

  • RE: Sending results of a querry via email

    xp_sendmail takes the @query argument. Check it out on BO , i hope this will help you.

     

    October 5, 2005 at 2:18 am

    #595082

  • RE: Variable column names in a table and or view

    I'm not sure if this is what are you trying to do but i hope it will help you

    declare @M1 char(6)

    declare @M2 char(6)

    declare @M3 char(6)

    declare @tmp_sql char(1000)

    select @M1 = '200506'

    select @M2...

    October 5, 2005 at 2:08 am

    #595077

  • RE: hours and minutes calculation

    if you change Phil's variables with your table fildes i think you get the right resuls

    for example

     

    create table dt (hhmm decimal(4,2)

    insert into dt values (3.30)

    insert into dt values (4.45)

    select rtrim(cast(cast((sum(floor(hhmm))*...

    October 4, 2005 at 5:38 am

    #594781

  • RE: Should be an easy Select, shouldn''''t it?

    try this

    select applicantid from aa

    where skillid = 1 and applicantid = (select applicantid from aa where skillid = 3)

    September 29, 2005 at 4:26 am

    #593969

  • RE: String manipulate

     try this one

    declare @STR char(50)

    select

    @STR = "

    September 26, 2005 at 4:22 am

    #592929

  • RE: String manipulate

    declare  @STR char(50)

    set @STR = "  where strs in ('40301','40301.16')   "

    select substring(@str,patindex('%(%',@str) + 1,patindex('%)%',@str) - patindex('%(%',@str) - 1)

    September 26, 2005 at 3:20 am

    #592914

  • RE: Displaying Dates in particular format

    select replace(convert(char(11),cast('2005-09-23' as datetime),13),' ','')

    September 23, 2005 at 4:57 am

    #592546

  • RE: Calculating percentages

    i think that this is the correct select

    select (426.0/852.0)/100.0

    September 22, 2005 at 7:50 am

    #592205

  • RE: Alter column

    try with the following code

    if you have constraints don't forget to add them

    BEGIN TRANSACTION

    SET QUOTED_IDENTIFIER ON

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

    SET ARITHABORT ON

    SET NUMERIC_ROUNDABORT OFF

    SET CONCAT_NULL_YIELDS_NULL ON

    SET ANSI_NULLS ON

    SET ANSI_PADDING ON

    SET...

    September 21, 2005 at 7:41 am

    #591756

  • RE: Text search Problem - part 2

    try this one

     

    create function select_points(@points char(3)) returns @tmp_table TABLE (RoutingString char(2000))

    as

    begin

     declare @point char(1)

     while len(@points) > 1

     begin

      select @point = substring(@points,patindex('%,%',@points) - 1 ,1)

      select @points = substring(@points,patindex('%,%',@points) + 1, len(@points))

      insert into @tmp_table...

    September 21, 2005 at 6:56 am

    #591712

  • RE: Text search Problem - part 2

    Try to use PATINDEX for example

    select RoutingString

    from routing

    where PATINDEX('%C%' , RoutingString) > 0 or PATINDEX('%K%' ,RoutingString) > 0

    September 21, 2005 at 5:06 am

    #591658

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