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 Rhinorhino 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. cbeggan

    Historical Records split over multiple tables

    Sorry, to clarify, the question is asking about the 'presentation' of historical data from many tables, not the retrieval of same. The issue is about typical or best practice method for presentation of the data on the screen where it may not all have been updated at the same time. To be fair...
  2. 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...
  3. cbeggan

    from rows to columns

    Looking at my previous reponse, you need to add a maximum of 5 to the inner while control (using the counter variable). Then set the Reportline variable to add the 3 required fields, you dont need the ReportLine2 stuff. Your outer loop can still drive on alarm_id, the inner one on...
  4. 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...
  5. cbeggan

    from rows to columns

    Did this before seeing MeanGreens reply. Does the same trick in the same way, but uses a temp table to format the output a bit and enables it to be selected in one go (or bcp'd). Pretty much complete bar the report header, which requires another loop from 1 to @maxlength to concatenate the...
  6. 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...
  7. cbeggan

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

    Of course that should be Linked Server up there in the title of this post. Fittingly though, the problem is that the link is severed !! ------ Dublin, Ireland.
  8. 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...
  9. cbeggan

    Using xp_cmdshell to BCP to ascii file

    [Lightbulb flickers on] Thanks! This is what happens towards the end of 14 hour days! Was looking on local drives, will now check on the server! 8-) ------ Dublin, Ireland.
  10. 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...
  11. cbeggan

    Using Subquery to Get Difference

    Just a question for you on this one Terry (if I can post it here!). The SQL background I have is mainly Ingres, with a little Sybase thrown in. I am using SQLServer just these past few weeks. Anyway, question is, why is your LEFT JOIN faster? I would have thought (from Ingres experience)...
  12. cbeggan

    Update a table from identical table

    Thanks Terry, while it will require a little pre-processing on 'Table_B' your delete-then-insert strategy just might be a really tidy way to do it ! c. ------ Dublin, Ireland.
  13. cbeggan

    Using Subquery to Get Difference

    Also, I tested this on a DB here without bothering to join the subselect. I don't think there's any advantage in that. [ Someone else might disagree though!! ] e.g. select * from invoices where groupby_field not in (select top 10 groupby_field from invoices group by groupby_field...
  14. cbeggan

    Using Subquery to Get Difference

    Hi, Two things a) have you got more than 100 unique cust_ids ? Secondly, try this: SELECT d.cust_id, a.cust_name, sum(d.sales) FROM detail d left outer join customers a on d.cust_id = a.cust_id WHERE d.date>={?Start} and d.date<={?End} and cust_id NOT IN /*start subquery*/ (SELECT top 100...
  15. cbeggan

    Please Help with Unique Key Constraint error

    This might be a bit of a 'duhh' suggestion, and apologies if so, but have you done an sp_help on the table and checked out the constraints - there may be contraints on other fields. With a name like 'IX_arc_tblxCSA_AgencyName_1' it sounds like there may be more than one constraint on the...
  16. cbeggan

    Update a table from identical table

    Thanks, I suspect you are right w.r.t. using NOT EXISTS. However, I am trying to avoid using explicit column names in the UPDATE SQL.... c. ------ Dublin, Ireland.
  17. 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...
  18. cbeggan

    Error context in Stored Procedures / SP Portability

    Thanks for that. As I see I don't need to use +'s to assign a multi-line string to a variable (only change required to the SQLs is the use of twin single quotes), this may be the way forward... ------ Dublin, Ireland.
  19. cbeggan

    Varchar larger that 255 in SQL 2000

    Just had the same issue... Seems to be a Query Analyser display issue. Assuming you are using the Query analyser, you need to go to the Tools Menu, Select Options and the Results tab and set the maximum characters from 256 per column to a larger value. This is probably a bit late for you, but...
  20. 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