Nope... you should almost never include an Order By in the view... (there are exceptions but this isn't one of them)... if the users want ordered data, they should include it...

Actually, it's not a cross join... I will agree that it creates many tiny triangular joins, but it creates no full cross joins.  And, it deletes a quarter million dupes...

Perhaps it's the difference in language and culture, Sandeep.  You post didn't sound right at all.  There is a way to ask for help especially on these types of forums......

Oooohhh.... now that's just plain evil   Hadn't thought about doing something that nasty

As for professors catching...

The command window will always "open" from the server... you can, however, run remote bat files... you just need to pass all file info as a UNC including the result...

Just my 2 cents... dunno if it is, or not, but the query should NOT be embedded SQL... you app should be calling a stored procedure for this and returning...

Did you just do someone's homework, Peter?  Hope you get an "A"

What would be more interesting is to ask why you think you need a cursor?  What are you trying to do?

http://www.w3schools.com

True... it appears to still have used an index... but notice it did NOT use an INDEX SEEK anywhere... instead, it used an INDEX SCAN which is quite slow compared...

That's exactly what I was talking about... if you "convert the two columns", you destroy most opportunities to use an index if one is available.  The method I displayed allows...

Thanks, Paul... I appreciate the feedback.

Rambling on a bit... If you consider that dates are nothing but underlying numbers that represent the number of whole and fractional days since midnight,...

TheDate column would also make a good clustered key candidate...  see my last post immediately above for how to get around the "joining with time" problem... it's a very common...

Sure... it's a very common request... and most folks do it the wrong way, in my opinion... they'll write some nasty (or nice) index killing formula in the WHERE clause of their...

Yep... spot on... couple of us have "Auxilliary Date Tables" that span many years to answer questions like what's the 2 Thursday of July of year xxxx, etc, etc.  Between...