|
I'm trying to pull results from a database (sql server 2005) which takes 4 tables: Subscriber S, Member M, ClaimLines L, ClaimHistoryLines H
Query is as follows:
select S.SBSB_ID, M.MEME_NAME, (CASE L.CLCL_ID WHEN '' THEN H.CLCL_ID ELSE L.CLCL_ID END)...
Started by Andrew Jahn on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Infact stop using the obsolete syntax altogether....
Use the correct ANSII standard join syntax.
They don't play well together.
CMC_CDDL_CL_LINE L, CMC_MEME_MEMBER M LEFT OUTER JOIN CMC_CLDH_DEN_HIST H
don't mix obsolete implied join syntax with left join .
|
|
Is there a way to see the history or any other information of insertions into a specific table of an SQL Server database?
Started by MKam on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You could use a trigger
Create a trigger on the table watching for inserts, updates, and deletes I wouldn't do....
This adds extra overhead, though, so for this.
The trigger would insert into another table (a history table).
|
|
Is it possible in Word 2007 to create a revision history table automatically using track changes or some other method?
e.g.
Revision History
DateVersionDescriptionAuthor 16/09/20081.0CreatedJohn Smith 17/09/20081.1Fixed dumb spelling errorsColin Jones...
Started by John Hunter on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you feel up to it, you could also create a tool that ... .
With a table like you suggested, and then keep all your documents in a version control system under a separate documentation branch in order to have an automatic revision history.
|
Ask your Facebook Friends
|
If you have a table which holds history (updates, deletes) from another table, how would you pull an associated update row if it comes after a delete operation?
Table has the following columns not related to the data
ID int, -- Identity
OP varchar -- ...
Started by Scott Hoffman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Hi,
if you are absolutely sure the timestamps are identical for a delete and corresponding update you can do this:
select * from historytable as table1 inner join historytable as table2 on table1.Removed_Date = table2.Removed_Date where table1.OP = 'D... .
|
|
In my SQL Server backend for my app, I want to create history tables for a bunch of my key tables, which will track a history of changes to the rows.
My entire application uses Stored Procedures, there is no embedded SQL. The only connection to the database...
Started by pearcewg on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
Recommended ....
There is not likely to be any particular speed difference .
It's good for security, resilient to failure modes like people forgetting to add code to update the history table and so forth.
In the history table.
|
|
I have inherited a table with a structure something like this:
ID Name Timestamp Data 1 A 40 ... 2 A 30 ... 3 A 20 ... 4 B 40 ... 5 B 20 ... 6 C 30 ... 7 C 20 ... 8 C 10 ...
ID is an identity field and the primary key and there are non-unique indexes ...
Started by Sarcastic on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SQL Server 2005 (onwards):
WITH MostRecentRows AS ( SELECT ID, Name, Data ROW_NUMBER() OVER (PARTITION BY Name ORDER BY TimeStamp DESC) AS 'RowNumber' FROM MySchema.MyTable ) SELECT * FROM MostRecentRows WHERE RowNumber = 1
Assuming there are no duplicate... .
|
|
Dream I'd like to keep record of when a user changes their address.
This way, when an order is placed, it will always be able to reference the user address that was used at the time of order placement.
possible schema users ( id username email ... ) user...
Started by smotchkkiss on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
To set it up run the migration and add a history of the user....
It provides an audits table and model to be used in place of your map.
In this way.
This removes the need for your map table, and creates a sort of linked list .
|
|
Looking to move data from a table A to history table B every X days for data that is Y days old and then remove the data from history table B that is older than Z days.
Just exploring different ways to accomplish this. So any suggestions would be appreciated...
Started by Josh Harris on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You want a nightly cron job/mysqldump....
This seems straight forward.
Wrapping that up in a SPROC as Quassnoi suggests table to the other relatively instantaneously.
From the online table to the history table then do your deletes.
|
|
I've been scratching my head over this one all day, and am very stuck.
This is the SQL:
SELECT papf2.full_name
, pah3.sequence_num seq
, pah3.action_code
, pha.SEGMENT1
FROM hr.per_all_people_f papf2
, po.po_action_history pah3
, po.po_headers_all pha...
Started by 20100511 on
, 15 posts
by 4 people.
Answer Snippets (Read the full thread at oracle):
ACTION_HISTORY table ? Are those values for a SEGMENT ? Sorry, I have not stated my requirements for 'SEQ' zero and six, the first and last values in the po_action_history table for that PO FROM hr.per_all_people_f papf2 ,....
|
|
I know there is a search function. I know how to use it.
Most of the forum-goers do.
I've just finished reading a few old threads and the wealth of information this forum can put together is simply amazing.
So here is my suggestion: would a table of content...
Started by Daniel San on
, 15 posts
by 6 people.
Answer Snippets (Read the full thread at militaryphotos):
Table of Content of the Military History and Tactics Section, and military actions large and small throughout all of human history, including the parsing of politics throughout all ....
: ]
Chronological order? :cantbeli: Of course...
|
