I can't explain it, but here is a quote from BOL:

SELECT @local_variable

Specifies that the given local variable (created using DECLARE @local_variable) should be set to the specified expression.

It is recommended...

Yep, if the datatypes of 'Handled' and 'ServiceLevel' are integer, then the result of your calculation will be an integer.

You could try the following, to force the result to be...

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