Can anyone please explain or refer an article as to how the str worked out to give the results.

It's always good to learn new concepts , even though I got the question wrong.:-P

A nice explanation to the Locking and Isolation Level article can be viewed at :-

http://www.sqllion.com/2009/07/transaction-isolation-levels-in-sql-server/

Sorry Matt, cannot move over to use SSIS.:crying:

I believe we can add an "OR " clause to the query to get the 20120101 record into the result set.

[code="(SELECT *, ROW_NUMBER() OVER (PARTITION BY Customer_id ORDER BY date,...

Seems you have got a class -assignment , either case I guess ,you have not understood the SQL concepts well or have not studied them. Please go through and I...

Use a UNION ALL --> in case you want all records from both the tables.

Use a UNION --> in case you want to eliminate duplicate records.

Use cross join

Try this ..

create table dbo.testvalue (datevalue datetime,value int)

insert into dbo.testvalue

select '2012-01-02',0 union all

select '2012-01-08',0 union all

select '2012-01-11',0 union all

select '2012-01-15',0 union all

select '2012-01-03',1 union all

select '2012-01-04',1 union all

select '2012-01-05',1 union...

Check IEEE Xplore for new research happenings in fields of your choice. You can also check into International Journal of Database Management which is an academicia and industry collaboration journal.;-)

This may sound a bit pre-historic, but, to get hold of the problematic query(s) in a batch you can run it in batch by batch. This way you can see...

You must understand the basic normalization concepts to create the database. As far as my understanding of normalization (as per Codd:- key,only the key and nothing but the key) I...

Thomas Abraham (1/5/2012)

---

Thanks for the easy and straightforward question. Sometimes not having to think hard first thing in the morning is great.

And then I started thinking ... but WHY can't...

Hi,

More information about the restriction can be found at the below link;

http://support.microsoft.com/kb/2297053

Could anyone please guide , as to, under which scenario should one opt for such concurrent activity ?