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...
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...
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...
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...
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...
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...
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.
[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...
[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.
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...
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)...
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.
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...
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...
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...
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.
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.