Very nice question Steve. I thought that answer should be 5. But immediately I corrected myself as there is 1 primary and 4 secondary replicas 🙂

Here it is (there can be another better solution as well)

with cte1

as

( select col1,col2 from @t

),

cte2

as

(

select col1,col2 from @twhere col2 is not null

)

select col1,coalesce(col2,(select top 1...

Your query is not very clear. I am putting up a scenario, hope this is what you are looking for:

CREATE TABLE test

(

process_name varchar(10), process_date datetime, process_value int

);

INSERT INTO...

Don't forget to check out the latest SQL Server 2012 book coming your way:

http://tsql.solidq.com/books/tsqlfund2012/

Itzik Ben-Gan's awesomeness 🙂

-Lokesh

+1

The only key is to set-up and get-started. The sooner you do the sooner you learn.

Some time back I was also in the same state of mind, I referred the link below (short and nice explanation):

http://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/

Hope this helps

Lokesh

Thanks Paul. Wonderful trick for my implementation.

Lokesh

Could some please help me with this. I need to implement this in a project.

Thanks, Lokesh

thanks for your link. I have already seen this before. the real challenge here is to define range function. As mentioned above if I assign a status range from A...

+3

But someone from the moderator's team should have checked this before posting 🙂

Further to what Wayne has written:

In order to use this full back-up to restore the datbase, we also need to apply the transaction log on top of the restore. This...

+1

I think, there should be transaction 1 commiting before Full backup reading ends.

Friend, for details check the book -->

SQL Server MVP Deep Dives, Volume 2

PART 1 ARCHITECTURE EDITED BY LOUIS DAVIDSON

1. Where are my keys? by AMI LEVIN

One more link: http://www.youtube.com/watch?v=cbJ-xaBfWLM&NR=1&feature=endscreen

Above link is totally in agreement with Gail Shaw's explanation