It's pretty complex, but your problem might be in the WHERE clause, specifically the

WHERE (((t2.Subrouteeffdate)=(SELECT ...)))

bit. If you have a record in t1 with no matching record in...

Maybe! Please provide more detail about what you are trying to achieve, as it isn't clear from your post.

Thanks Jeff - do you have any examples of this?

Phil

As far as I know, there is no native support in SQL Server for rolling back specific transactions, though I believe there are third-party tools that can do this.

But a...

It looks like you want to round down in all cases - this code should do the trick:

declare @a varchar(100), @b-2 varchar(100)

set @a = '0.4567777777778999999999345677777777777777777'

set @b-2 = '10.3456789002322222222222545465565767888888888888888'

select cast(left(@a, charindex('.',...

First point is that the result of your example equates to 1%, not 5%

Secondly, there is no explicit 'percentage' datatype. Not that...

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