@tmpUserAccounts is being declared as a local variable, with a datatype of table. So it is different from a temporary table. It should therefore be possible to SET...

One idea that is a little simpler is for each user to have a count of "open" posts. If the count is 1 or greater, display a message every...

The timestamp datatype is provided by SQL Server as a simple way of versioning records in a table - among other things, it enables you to track which rows have...

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