I don't know whether this will be of any help, but here is some code that returns a list of tables/columns and defaults within the current db.

select table_name, column_name, column_default...

Thanks Andy

A couple here.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=153039#bm153082

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=152271#bm152956

A couple of other limbo posts have been answered since I wrote my comment. It might just be the Christmas break, but you know how it...

I second all of the good feedback about this article and have another suggestion. I have posted several solutions recently - well, I thought they were solutions

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...