Forum Replies Created

Viewing 13 posts - 421 through 433 (of 433 total)

  • RE: plz explain the concept of newid() and rowguidgrid in create table command

    newid() is a function that returns a uniqueidentifier.

     

    rowguid is a setting that you can place on a uniqueidentifier datatype column to allow it to be used for replication.  All tables that...

  • RE: case when problem in query

    this may be cleaner

    case when col1 = 1 then 'yes'

    case when col2 = 1 then 'no'

    else

    'maybe'

    end

     

    note that if a condition is met then it stops looking so if...

  • RE: case when problem in query

    nested case statements look like this

    case when col1 = 1 then 'yes' else

    case when col2 = 1 then 'no' else

    'maybe'

    end

    end

     

     

  • RE: Got error when issue cmd line with DTSRun

    when you run it manually are you logged into the server or are you on a workstaion connected via enterprise manager? 

    where is the dll file located?

  • RE: Fixed width text import

    I have had this problem getting fixed lenght from a legacy machine where the final field was not always populated.  I wrote this vbs script to pad the rows and...

  • RE: Select most recent record

    try this, it won't delete the data but should display what you are looking for

     

    SELECT    TimeOfCapture, Value1, Value2, Value3) FROM         FactoryTable

    join (select max(timeofcapture) as maxtoc from factorytable group by convert(varchar,timeofcapture,101),datepart(hh,timeofcapture)

    WHERE     (MONTH(TimeOfCapture)...

  • RE: A nice way to start the week

    938 Can't find a better way then bouncing him off the tree top.

  • RE: Changing FTP target from IP address to DNS name

    if you are just looking go find the name associated with the ip address then use ping -a ipaddress from the command line.   

  • RE: How to know new records

    you would also need to create a modify_date field with an update trigger that sets it to getdate() on record update to track the updates

  • RE: Export non-uniform records to one Text file destination

    vbs scipt to append:

    set fso=createobject("scripting.filesystemobject")

    set nfl = fso.createtextfile("c:\\pathtoresultfile\resultfile.txt")

    set fl= fso.OpenTextFile("c:\pathtofile1\file1.txt")

    do while not fl.atendofstream

     nfl.writeline fl.readline

    loop

    set fl= fso.OpenTextFile("c:\pathtofile1\file2.txt")

    do while not fl.atendofstream

     nfl.writeline fl.readline

    loop

    set fl= fso.OpenTextFile("c:\pathtofile1\file3.txt")

    do while not fl.atendofstream

     nfl.writeline fl.readline

    loop

    nfl.close

    set nfl=nothing

     

     

    or you can use

    select...

  • RE: DTS package with a parameter

    If the list of files is in a table you could build a DTS loop to import all of the files.  If you want to import all of the files...

  • RE: run exe by passing parameter in scheduled job

    The other option is to put the comand line with argument in a batch file and run the batch file from the scheduler.  If your month end jobs are all...

  • RE: run exe by passing parameter in scheduled job

    Have you tried putting the exe into an execute process task in a DTS package and then scheduling the DTS package?  The task is designed to take parameters for executables.

Viewing 13 posts - 421 through 433 (of 433 total)