I think I understand what you are getting at, but some sample data highlighting what you are currently getting and what you want to get would help significantly. To...

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