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!

  • Congratulations Chris 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: *

  • Users: dunko
  • Order by date
  1. dunko

    Teradata SQL syntax for UPDATE, submitted through BTEQ

    I don't know what release of Teradata you are on, but you should be able to create the view as a volitile temporarary table within your SQL without the need to run it seperately as described above. This is the method that Microstrategy for example uses to run complex multipart SQL against...
  2. dunko

    convert date to character 'YYYYMM' with substring and extract function

    or alternatively from BTEQ/ODBC: select data1, data2, cast((datefield (format 'YYYYMM')) as char(6)) as YearMonth from sourcetbl; Note: The cast to char(6) is only required if you are retrieving data via ODBC (if omitted it just comes across as the date field unchanged since it is...
  3. dunko

    Microstrategy clickstream implementation in production?

    It would not be hard to implement MSI to analyze clickstreams - there are a few data models around that are used by dedicated tools that might help develop this...&nbsp;&nbsp;<br><br>I suggest you have a look at SiteServer Express that comes with IIS - it loads the clickstream data into an...
  4. dunko

    Importing solids from AutoCAD

    Hi,<br> <br> I like to model 3D in AutoCAD R14 as I am familiar with the tools/interface. I have tried using DXF format to export geometries (some complex, some not so complex) to Dream3D (Corel 7.0), but AutoCAD solids do not appear to be imported correctly.<br> <br> Is there a way to import...

Part and Inventory Search

Back
Top