OK - may not be a great design, but it's very a common way of doing header/detail relationships.

So you now have several accounts which have got 19 header records but...

How is the DocID field (the primary key?) in ac_docdetail generated? Is it an IDENTITY field?

Regards

Phil

You can do this in SQL -

insert into tblImage(acid, image)

select xxxx, t1.image

from tblImage t1

where t1.acid = yyyy

xxxx is literal text and should be replaced with the new account number...

So even though the item field may not exist at all in table1, you still want a row to appear in your resultset?

Does item 100 appear in some other table?...

Why not just create a check constraint on the primary key (eg ID = 1). PK is NOT an identity field, so repeated insert/delete should be no problem.

@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