Hi and thanks for the reply.

I am not using a SP, and also, the join doesn't happen all the time, its only when a PREFIX is satisfied.

Thanks for the low down, John. Very helpful.

I guess I was trying to do too much in a WHERE clause, but breaking down each requirement into its own sub-query seems...

Right, thats interesting.

We already us SQL Server 2005, so will look into it.

But I worked for a company in the past who used SQL Server 2000 and they had a...

That seems to have done it! Thanks very much.

I am going to be checky here Is there anyway you can just give a...

Thanks for the replies people.

SQL Mobile only allows Sub Queryies that reside in the IN clause, the 2nd query here will not be valid.

I will try the first one, but...

Hi all,

yes it seems that derived tables is DEF not allowed in SQL mobile, and also queries that contain statements similar to the following will cause an error...

WHERE (CreatedDate =...

Hi all,

and thanks for your replies.

Not sure on DERIVED TABLES, but looking at this article, it seems it is allowed.

(http://msdn2.microsoft.com/en-us/library/ms174633.aspx)

I do know that the TOP keyword is not...

I have managed to get this to work by using the following query (quite messy query )

SELECT*

FROMtbl_NSP_Inspection

WHERE((CreatedDate >= DATEADD(d, DATEDIFF(d, 0, GETDATE()), 0))...

Ok, I am going to throw a spanner in the works here, as it seems that I need todays date (as in my orginal requirement) but then need the next...

"Well, I suppose it was meant as "if today is the first of a month, yesterday is the last day from previous month". Trystan probably wanted to avoid solutions based...

Thats exactly what I am trying to solve Vladan

But your query also returns rows that have a QuestionNodeTypeUID of 6, though it does...

But we have databases across many client sites. The upgrade.sql script we have contains all teh legitmate SQL scripts that will bring the client databases to to date.

I would be...

In our work we have a database upgrade script that we run on client sites to ensure that client databases are kept up to date and in a working state.

When...

Thanks for the replies guys.

John: That is a very neat way of doing it. So can that query be applied to all cases where you need to convert/switch values (so...

Thanks for the replies guys.

I will try these out, and then get back to you.

Thanks again.