Can you post the calculations?

When you say 'proper', what do you mean?

Phil

Instead of this:

SELECT @cmd = 'USE DELTEKCP'

execute @ret = sp_grantdbaccess @loginame, @name_in_db OUT

Try this:

set @cmd = 'USE DELTEKCP sp_grantdbaccess ' + @loginame + ', ' +...

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.