|
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
|
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.
|
|
Hello,
I need some advises in an task regarding design and modeling of a history entity. the table / tables will be in MySql.
I have the following task for my company: to keep an history of all customers regarding their scoring. The scoring is calculated...
Started by maria_b on
, 15 posts
by 6 people.
Answer Snippets (Read the full thread at dbforums):
It's not about....
You may wish to consider creating a second table within which you can store may wish to consider creating a second table within which you can store the aggregated/calculated data query that doesn't help.
Option 1 for sure.
|
|
Hello,
I have a customers table with information about our customers (ID, login, name, contacts info, different options, TS column, and so on, ~15 columns, ~few hundreds of customers).
Now we need to send every-day-updates to our biggest customers (<...
Answer Snippets (Read the full thread at stackoverflow):
SELECT * FROM customer_updates_sending attributes that aren't associated....
history of updates, I personally, prefer the 2 table approach as it certainly allows for historical that stored in the existance of a row in a different table.
|
|
Can we able to delete HISTORY table entries from the Database? Will it cause any issues in CQ if we do so? Any Ideas ?
Thanks
Kiran.
Started by Kiran.Sankepally on
, 2 posts
by 2 people.
Answer Snippets (Read the full thread at ibm):
Hello Kiran,
Two things need to be said about this:
1) If you delete history data, charts.
|
|
I would like to log changes made to all fields in a table to another table. This will be used to keep a history of all the changes made to that table (Your basic change log table).
What is the best way to do it in SQL Server 2005?
I am going to assume...
Started by Gerhard Weiss on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It can view history of each row.
It quite the same as Log Explorer, but it is free .
Do whatever you want with the #TempTable, such as inserting those records into a logging table Log Rescue .
|
