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 bkrike 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: cbeggan
  • Content: Threads
  • Order by date
  1. cbeggan

    Historical Records split over multiple tables

    We are rebuilding the functionality of a mainframe application on client/server application with relational database. The mainframe application provided 'history' functionality on the majority of it's screens. 'History' brought the user back to the previous version of the data and highlighted...
  2. cbeggan

    Maximum number of cols/table on an ASE 11.5 DB

    Folks, Here's a quick one. What is the maximum number of columns per table on ASE 11.5. From the net, it seems to be either a) a rigid 250 or b) a function of page size/column widths. However the data I'm looking at may be dated.... Also, can someone tell me the maximum number of tables per...
  3. cbeggan

    High-level DB schema design question

    Hi, I am looking at a DB redesign where I can identify two options for storing data records. In the design, there is a major need for flexibility. The data comes in a number of types (ie. some records contain many different fields than others). An example might be a store catalogue that...
  4. cbeggan

    Linked sever: 'SQLOLEDB' reported an error ....

    [code]Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'SQL0LEDB' reported an error. The provider did not give any information about the error. [\code] Am getting this error when trying to access a linked server. I have looked it up on MS.com and google. Seems like its not totally...
  5. cbeggan

    Using xp_cmdshell to BCP to ascii file

    Hi I'm trying to export data from a stored procedure. I am attempting to call an SP to do my select and throw the result set to a DOS ascii file. Now, my bcp command is built dynamically looks like this: bcp "EXEC server.db.dbo.sp_cms_output_client_data" queryout...
  6. cbeggan

    Update a table from identical table

    Folks, Can't seem to find this anywhere. I have a table, say Table_A containing rows with UniqueIDs, and another table, say Table B, of identical structure containing more IDs. Some of these are the duplicated in Table_A, some are different. I want to update Table_A from Table_B...
  7. cbeggan

    Error context in Stored Procedures / SP Portability

    Folks, I am implementing some SQL processing which will be kicked off from a windows batch file. This file will use osql to call an SP which contains nested SPs. (The batch file also calls some windows applications afterwards). The SPs will result in the creation of acsii output files via...

Part and Inventory Search

Back
Top