This question was not originally...

Not much. Basically, concept was of tally table. I implemented with the memory table, which was supposed to...

You are right. But it is always to have...

if you are going for mirroring, this article might help you;

http://technet.microsoft.com/en-us/library/ms175511.aspx

Solution according to me is...

;With wcte as (

Select vTime,vValue,Row_Number() over (partition by Convert(DateTime,Convert(varchar(10),vTime,110)) order by vTime Desc) rno

from @vTable

)Select vTime,vValue from wcte where rno = 1

The question was;

I need to write a SQL-Server query but I don't know how to solve. I have a table RealtimeData with data:

Time ...

In SSMS, expand table B and go to keys. Right-Click FK and select modify. Under Table Designer, expand INSERT And UPDATE Specific, Unde Delete Rule Select Cascade. Then Save. Repeat...

While defining relationships, there is an option of "Delete Rule". You can set from there.

Considering Table A as Parent and Table B and Table C are chile tables with Foreign...

Why not to use cascade?

By using Cascade, If you delete from Table A, Record(s) from Table B and Table C will bve automatically deleted.

No question, No answer. I think that was OP's first post.

How are you recording the data on which you will generate the invoice. For example, an inventory invoice will definitely be based upon the Order and Order detail table. What...

It is better to go for Mirroring if you intend for the the same database structure to be used as of OLTP database.

I would suggest that if you are thinking...

You can also use Triggers for parallel insertion but it can slow down the Insert / update process. Using Service Broker can be helpful in this regard. Just initialize Service...

My suggestion is that it will be better to keep the Month End tables in De-Normalized manner.

I assume that you will be producing reports from this data or use...

Sorry. forgot to replace the table names in the cte.

DECLARE @MissingNumbers TABLE (N INT)

Declare @vMax int

INSERT INTO @MissingNumbers

VALUES (19),(20)

Set @vMax = (Select MAX(N) from @MissingNumbers)

;with wcte as (

Select Top(@vMax) ROW_NUMBER()...