Forum Replies Created

Viewing 15 posts - 2,266 through 2,280 (of 3,544 total)

  • RE: DTS Problem

    See here

    http://support.microsoft.com/default.aspx?scid=kb;en-us;236605

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 6, 2005 at 7:19 am

    #571217

  • RE: Pass table name to stored procedure2

    quoteOR - as someone  suggested above use dynamic sql

    Either/or, swings and...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 5, 2005 at 10:13 am

    #570918

  • RE: Remove Zero

    quoteYou seem to be the expert on paterns

    Who me! No...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 5, 2005 at 10:10 am

    #570913

  • RE: Pass table name to stored procedure2

    In that case you will need to use OPENDATASOURCE if the database is known or OPENROWSET if both server & database is parameterized

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 5, 2005 at 9:57 am

    #570907

  • RE: Pass table name to stored procedure2

    Also bracket the values to stop injection, ie

    [databasename].[username].[tablename]

     

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 5, 2005 at 7:39 am

    #570862

  • RE: Remove Zero

    or

    SELECT SUBSTRING([name],PATINDEX('%[^0]%',[Name]),LEN([Name])) FROM @A

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 5, 2005 at 7:34 am

    #570861

  • RE: Dynamic record counting

    quoteBefore someone else complains

    Not me Remi  I wasn't complaining, honest

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 4, 2005 at 8:20 am

    #570683

  • RE: Dynamic record counting

    Bet not Remi

    Like the solution though

    But aren't you teaching bad habits, using system tables, tut tut...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 4, 2005 at 7:53 am

    #570657

  • RE: BCP COMMAND

    What account is SQL Server service running under, if it is Local System then it will not be able to access the network, see the following from BOL

    When xp_cmdshell is...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 4, 2005 at 7:43 am

    #570654

  • RE: Dynamic record counting

    You need to include the single quotes for the tablename data in the insert like this

    EXEC ('Insert dbo.MgtTable_Records (Table_Name ,No_Records)

     Select ''' + @tablename + ''',Count(*) As Counter From ' + @tablename...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 4, 2005 at 7:28 am

    #570647

  • RE: Datetime problem in transform data task

    If you check Stewart's 2nd post he defines the format of imported column as yyyymmddhhmm or (yyyyddmmhhmm)   and therefore ISDATE will not work as...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 4, 2005 at 3:44 am

    #570607

  • RE: The Internet will be safe again!!!!

    In general I would agree with the xxx domain but agree with jay about some content may not wish to be there.

    If this is to be voluntary then it would...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 1, 2005 at 8:00 am

    #570326

  • RE: Convert various dates to 2 INT columns

    Ok I'll try (and wait for the fallout )

    SELECT CAST(SUBSTRING(CardExpDate,1,2) as int) AS [CCExpMonth],

    CAST(CASE WHEN SUBSTRING(CardExpDate,5,2) > '50'

    THEN STUFF(SUBSTRING(CardExpDate,3,4),1,2,'19')

    ELSE SUBSTRING(CardExpDate,3,4)

    END...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 1, 2005 at 7:44 am

    #570311

  • RE: Question of the Day for 01 Jul 2005

    But the question stated SQL Server 2005

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 1, 2005 at 6:58 am

    #570293

  • RE: Datetime problem in transform data task

    if DTSSource("Col009") = null then

        DTSDestination("Col009") = null

    elseif Trim(DTSSource("Col009")) = "" Then

        DTSDestination("Col009") = null

    else

        DTSDestination("Col009") = mid(DTSSource("Col009"),1,4) & "/" & mid(DTSSource("Col009"),5,2) & "/" & mid(DTSSource("Col009"),7,2) & " " &...

    Far away is close at hand in the images of elsewhere.
    Anon.

    July 1, 2005 at 4:37 am

    #570268

Viewing 15 posts - 2,266 through 2,280 (of 3,544 total)