Hi Ed

If, for a particular record in 'organization', a related record does not exist in the 'totals' table, all of the fields retrieved from the totals table will be NULL.

So...

In general, for readability ...

'On' should be used for joins between tables:

select * from tablea a inner join tableb b

on a.id = b.id

etc

'Where' should be used to filter the results...

Are you looking for all the combinations -

PRIM1 | A | B

---------------------

1 A1 B1

1 A1 B2

1 A1 B3

1 A2 B1

1 A2 B2

1 A2 B3

From your post, I'm guessing not....

Agree with you Joseph - same has happened to me several times, on the longer, more time-consuming posts of course. There must be a way round this that doesn't...

Something like this should get you close:

SELECT S.record_count,

max(T.trip_id),

S.compart_no,

T.boat_id,

T.boat_type,

S.recordor_id,

S.record_type,...

Have you posted this in the wrong forum, or is there some hidden T-SQL problem?

Use the isnull() function. Try this example:

declare @var1 integer, @var2 integer

set @var1 = null

set @var2 = 25

select isnull(@var1,0) as var1, isnull(@var2,0) as var2

Cheers

Phil

Here's another stupid way:

SELECT DATENAME(month, @month * 28)

-- where @month contains an integer between 1 and 12.

Can't see any more obvious way. It would perhaps be more elegant to...

Hi Russell - so what, exactly, are you looking for?

1) Are you looking for a way of randomly selecting a sample % of records from an overall population?

2)...

Wow! How accurate do you need to be?

The Money datatype in SQL Server helpfully rounds to 4dp, so that's possibly where things...

Hmmm ... if you follow the Dictionary.com definition a little bit further down the page, you get to this:

Main Entry: effect

Function: transitive verb

1 : to cause to come into being

2...

Hi Frank, check out this thread for more info on this.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=127527

Regards

Phil

Have you checked that the system date and time on the server are correct?

Fantastic, a conversation about grammar Sorry fhanlon, but going back to the Dictionary.com reference, if you follow the link for "Usage Note"...

I think in the question it should be 'effect', rather than 'affect' (otherwise, which UPDATE statement is affected?) - and, being a grammar nazi, I therefore got this question 'wrong'...