Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. quatermass

    OPENROWSET

    ...single quote as being the end of what is to be executed and will attempt to run that and the remenants of the string. It will try to run select x.*,getdate() as datum from openrowset(''SQLOLEDB'',''SERVER1'';''user'';''pw'','' select anr,alist,aidnr, (select sum(bpstueck) from...
  2. quatermass

    datetime conversion

    ...The format 109 wants the format to be mon dd yyyy hh:mi:ss:mmmAM (or PM) Using the replace function creates that format. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and Scissors)...
  3. quatermass

    Create a folder using Date

    ...right("00" + val_in, 2) end function This can then be passed into the CreateFolder function at the end of any root path you want. Hope it helps ************************************************************** Rock is Dead (Long Live Paper and Scissors)...
  4. quatermass

    Pivotong rows to columns

    ....... With the number of columns you need to create, it may be easier to try to use syscols to help generate the case statement. Hope it helps ************************************************************** Rock is Dead (Long Live Paper and Scissors)...
  5. quatermass

    BCP Newbie needs help

    ...line set @as_select = 'bcp "DATABASENAME..ct_rl2cpcs"' where DATABASENAME is the database which holds the ct_r12cpcs table. Hope it helps ************************************************************** Rock is Dead (Long Live Paper and Scissors)...
  6. quatermass

    appending a file in DTS package

    ...if it doesn't exist. Given that the file is for reading only, this doesn't make sense. Try removing the final "True" Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and Scissors)...
  7. quatermass

    Cognos 8...Can't connect Contect Store to MSQL 2005 Express databse

    Olivia Apparantly, the port for 2005 Express is randomly assigned and can be viewed through the SQL Server Config Manager. Under Network Config and on the IP addresses tab, is TCP Dynamic Ports, this value is the one which you will need to connect the Content Store on. I think the port can...
  8. quatermass

    Update the date to match the first record changed in a group

    ...I used Access) you should use the original code to generate a new table, and replace the existing one with the new one. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  9. quatermass

    Update the date to match the first record changed in a group

    ...= t2.Status This gets the min status date as a sub-select and assigns it to each of the PO records with the same status Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  10. quatermass

    Line Chart - Suppressing Display of 0's and Nulls

    ...'prefilter' to the end of the field/calculation. For the prefiltered fields, it will be as if the filter were not added. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  11. quatermass

    DTS import, Add 2 columns Date and Source

    ...for the transform, make the source a sql statement rather than a direct table/view source. The sql statement will be along the lines of select *, sysdate, 'PICK' from table where sysdate is the pick sql command for the current system date c) in the transformations for the job, highlight...
  12. quatermass

    Transforming columns to rows

    ...into a SQL table As the source for the transform, use both the excel data and the 7 record 'day' table with the following sql statement select a.*, b.* from 'excel data' a, 'day table' b Note there is no join. Create an activex transform and use code as follows: start code: dim retnet...
  13. quatermass

    VBA Sql Syntax

    ...data formatting. In which case, either change the variable data type, or put conversion functions into the sql statement. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  14. quatermass

    SQL Query. Duplicate Records in Data

    ...in the group by clause. That will then give you all of your 'duplicated' fields as a single record with the latest date. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  15. quatermass

    Skip Row in CSV import in a DTS

    ...= DTSSource("Col001") & "-1" End If x = DTSTransformation_OK end if --end code Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  16. quatermass

    Change Database in Catalog

    Hi, Have you renamed the database in the Catalog Tables section on the right hand side of the Menu>>Catalog>>Tables screen? The 3 database icons represent (from the top): The database definition (from the database drop down) The SQL Server database name (where data is actually stored) The user...
  17. quatermass

    DTS packages

    ..."message" I hope that this is clear enough for you. I know it works as I use it to re-use batch files in my own DTS packages. Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  18. quatermass

    DTS: Conditional Load

    ...cn.open "SQL SERVER NAME", "USER NAME", "USER PASSWORD" 'get the count for the source table str = "select count(*) from DATABASE..TABLE" set rs = cn.execute(str) no_recs = rs.fields(0).value 'close objects and set to nothing cn.close set rs=nothing...
  19. quatermass

    catalog block

    ...want to change the catalog, you can take a copy of the catalog, make the changes in the copy and then overwrite the main catalog. Regards, Kevin ************************************************************** Rock is Dead (Long Live Paper and...
  20. quatermass

    Problem in COGNOS

    ...unique identifier). There will be a date on each record returned, but the value will be the same for each customer number. Hope it helps Kevin ************************************************************** Rock is Dead (Long Live Paper and...

Part and Inventory Search

Back
Top