Update Table on Real Time, SQL query req.

[farhanmazhari]

Hi All,

Here is the scenario, I have a table called "Table1" which updates on real time basis, i want to copy the data from Table1 to my newly created Table2 which is having 2 columns, Number and Count.
While copying the data from Table1 to Table2 if it founds matches record in "Number" column then it increments it to 2 in Count column.

Need query for above mentioned scenario.....any help will be remembers in good wordings.....

[Janos™]

You can check the below code that makes a complete EOD table from Realtime table (tested on MSSQL 2008, but should work on 2005 as well).

SELECT Symbol, Date, Value FROM
(
     SELECT *, ROW_NUMBER() OVER(
         PARTITION BY symbol, DATEPART(yy, date), DATEPART(y, date)
          ORDER BY date desc) AS ord
     FROM Realtime
 ) AS t
 WHERE ord = 1