Not who I thought...

Luis Cazares (9/4/2012)

---

A small change in the query:

select

program,

Completed_task,

timestamp

from

WorkQueue

where type IN ('Software', 'Hardware', 'Software/Hardware')

and status...

Should do something like this:

with basedata (

name,

addy,

ph,

grade

) as (

select

name,

...

Have you looked at DATETIME2 and TIME? They can go to 7 decimal places in precision and DATADIFF will go to nanoseconds if I remember correctly. Also, I...

SQL_NuB (9/4/2012)

---

Lynn Pettis (9/4/2012)

---

SQL_NuB (9/4/2012)

---

that date is in the table, so when I do select max(timestamp) from workqueue,...

Sean Lange (9/4/2012)

---

sivajii (9/4/2012)

---

it read this

http://www.sqlservercentral.com/articles/Indexing/68439/

here i didn't understand

if there is an simple example means i can i understand easily

select * from sys.indexes

select * from sys.index_columns...

Or something like this:

select

program,

Completed_task,

timestamp

from

WorkQueue

where

((type = 'Software' and status = 'Active')...

SQL_NuB (9/4/2012)

---

that date is in the table, so when I do select max(timestamp) from workqueue, that's the most...

How do you decide what date you want from your data?

Depending on your data, since we are now in September, and you want data for say 2012-08-29 where you may have data from before and after this date you may...

eugene.pipko (9/4/2012)

---

Do you think I am receiving following message because my data is stored in nvarchar(max) column?

--------------

Msg 241, Level 16, State 1, Line 9

Conversion failed when converting date and/or time...

Give this a try. Any questions, please ask.

create table #temp

(SchoolName varchar(12),

GradeCode int);

insert into #temp values ('SchoolName', 1);

insert into #temp values ('SchoolName', 2);

insert into #temp values ('SchoolName', 3);

insert into...

Both do the same for me:

with testdata as ( -- this cte is only used to provide the test data for the code below

select

cast(dt.MyTime as time)...

eugene.pipko (9/4/2012)

---

Thanks for replies,

Trying to use your last solution in the query and get an error:

--------------

Msg 241, Level 16, State 1, Line 9

Conversion failed when converting date and/or time from...

After seeing Luis's code, retested mine without the stuff, it still works:

with testdata as ( -- this cte is only used to provide the test data for the code below

select

...