You forgetting people that I am using SQL Mobile Everywhere, so the use of sub-queries (only allowed in IN Clauses) isn't permitted, and @@ROWCOUNT doesn't work

Hi, and thanks for the replies.

That seems to work on the desktop but not on my SQL CE Mobile for some reason. Maybe it doens;t like INNER JOINs on UPDATE...

Thank you very much for this Jeff. I forgot about my post, but just remembered it as I need it.

Top stuff

Maybe a snapshot of some data may help

QuestTreeUID ShortDesc LongDesc ParentUID QuestNodeUID

14SmartwasteSmartwaste ...

Query...

SELECT I.InspectionUID,

A.AnswerSetUID,

I.QuestionTreeUID

FROM tbl_NSP_Inspection I

RIGHT OUTER JOIN tbl_NSP_AnswerSet A ON (A.InspectionUID = I.InspectionUID)

WHERE (I.QuestionTreeUID = 2)

AND (A.Completed = 0)

AND (DATEPART(DAY, I.CreatedDate) < DATEPART(DAY, GETDATE()))

Results returned...

00089_0000002616,2

00089_0000002616,2

00089_0000002616,2

00089_0000002616,2

00089_0000002616,2

00089_0000002616,2

00089_0000002609,2

00089_0000002609,2

00089_0000002609,2

00089_0000002609,2

00089_0000002609,2

00089_0000002609,2

Query...

SELECT I.InspectionUID,

A.AnswerSetUID,

I.QuestionTreeUID...

Hi this query was for SQL Server Mobile and it doesn't make use of Sub-queries or TOP -

Thanks

Tryst

There is a need for the time day as it is used for reporting on. I don't want to write this data into a separate column each time an inspection...

I want to show a list of inspections for each for each day where each Inspection undertaken has a calculated column added to it that determines the time difference between...

Hi stax68,

yes it is because the Description column in the table is Unique. Is this the problem then?

Tryst

Good morning all

Nagabhushanam Ponnapalli - your query works perfectly. But ideally, I'd like to wrap it up in a query without using a...

Hi, and thanks for the replies people.

One issue, I am to run this query on a handheld device against SQL CE 3, which doesn't allow stored proc's i believe. I...

Hi all,

and thanks for the replies.

If I had gone with the first two replies, that would have made my example, which was...

"I live in the town which is near this...

Hi and thanks for the reply Sergiy.

When I go into the Design Table screen and change the data type, the Generate Script button is greyed out until I press the...

Thats sorted it.

Thanks Jeff (and all).

Tryst

Hi, and thanks for the reply people.

I will attempt your solutions when I load up query analyer.

To answer Pam's question, I am trying to get the date from the datatime...