Using getdate() as an example date:

select cast(floor(cast(getdate() as float)) as datetime)

Hmmm ... one way would be to create a calculated field on your table - call it 'concat', say, which is the concatenation of all twelve fields, replacing all nulls...

Not that I know of. A UDF will do this fairly easily - something like this:

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

create function dbo.ascii_big (@string varchar(1000))

returns int

as

begin

declare @position int,...

I cannot schedule anything more frequently than every minute - is that good enough?

Conditioning the DELETE is possible, but I'm not sure what condition you want. Can you be a bit more specific? Also, when you say that it doesn't work...

Hi Travis, this must be turning into a real pain in the you-know-what Just had a quick read through your code and...

If you perform a truncate on the temporary table every week before you perform the import (assuming that you do not wish to keep a history of what has been...

One way of approaching this is to import the files into a new intermediate table (which has no constraints) and to use standard SQL on this table to perform validation...

As far as I can see, you have solved your own problem:

SELECT

d.company, d.address1, d.address2, d.city_id, d.state_id, d.country_id, d.zip, dr.directory_roletype_id, x.eng_itemdesc

FROM

T_MTSTM_DIRECTORY d INNER JOIN

T_MTSTM_DIRECTORY_ROLE dr ON...

Never seen the error.

Maybe it's worth reinstalling the client tools on your PC and see whether that resolves it.

Does this happen for all databases, or just specific ones?

Do other users experience the same error?

Regards

Phil

Thanks Kemp ... yet another requirement that I didn't quite understand

Here's another version of your query that does not require wildcards:

SELECT * FROM...

Hi Jim

As far as I know, there is no 'date last updated' property for a database, so there is no straightforward solution to your question.

The following thread may be of...

If you are inserting a date into a table, why are you not using a datetime field to store it?

If you want to select just the date part of getdate(),...

Try this:

SELECT * FROM dbo.AGSVC_Idx_Res

WHERE neighborhood = 'MM_neighborhood' AND city = 'MM_city' AND PRICE BETWEEN 'MM_price_start' AND 'MM_price_finish' AND BEDROOMS >= 'MM_bed_start' AND (HIGH_SCHOOL LIKE 'MM_school' or...