Make sure to read this post to understand how datetimes work in SQL Server

http://beyondrelational.com/blogs/madhivanan/archive/2010/06/03/understanding-datetime-column-part-ii.aspx

Steve Jone's code can be simplified to

SELECT IDval, DateStart, TimeStart

FROM dbo.DateTimeTest

WHERE ( (DateStart = '9/4/2010' AND TimeStart >= '20:00') or (datestart = '9/5/2010' AND TimeStart < '08:00'))

See also what you can do with row_number() function

http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx

Note that @s1 is declared as varchar(10) whereas @s2 as varchar(20). Use varchar(20) for @s1 and see the result. It gives the correct result

DECLARE @TB TABLE (id INT,name varchar(10))

INSERT...

Also if you want to show formatted dates in any front end application, do formation there. Otherwise to simplify the code, use a derived table

select mycol from

(

select *,convert(varchar(20),mydatecol,103) as mycol

)...

No. I don't any delay in this site. Check your network speed

Have a million row table and do running total using a triangular join

select col,

(select sum(col) from table as t1 where t1.pkcol<=t2.pkcol) as run_sum

from table as t2

This is alos for a Dynamic PIVOT

http://beyondrelational.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

The post in incomplete. Edit your post and content

You can also make use of row_number() function as described here

http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx

It is not possible to import data where there are different number of columns

When dealing with sql injection, here is a derived table approach that can avoid it

http://beyondrelational.com/blogs/madhivanan/archive/2010/05/14/derived-table-new-approach-to-avoid-sql-injection.aspx

Jeff Moden (2/25/2010)

Mike M - DBA2B (2/25/2010)

Well, you, a fellow named Tom(?), and I all used to try to help folks out on another SQL forum about 6 years ago....

For 32 bit version, here are some methods used to import/export to EXCEL from SQL Server table

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

It would be something like this

declare @tblcodes table(codeid int, code varchar(100), adr_id1 int)

insert into @tblcodes

select 1,' CB4560460D5946C49D9B286048CC11A7', 0 union all

select 2,' 5953BE4521634863B9D03137B7DBA3C4', 0 union all

select 3,' 97D40E6B7AF545AE94ED13DF1AF1C27F', 0

declare @tblcustomer...