Something like this?

select t.transporter_name, a.state_id

from transporters t left outer join association a on

t.transporter_id = a.transporter_id

where state_id = 101 or state_id is null

Perhaps you could run Profiler to check the SQL Server side of the equation? Otherwise, I'm running out of ideas.

Good luck

Phil

So do you know at what stage in the process that the conversion is failing for these records?

I'm thinking it could be

a) Something in the logic of the conversion program...

So you've got everything you can find on your server set to US format and you're still getting d/m/y date format problems from somewhere?

So are you trying to make your SQL Server 'pretend' it is American? Don't know whether this will work, but you might try changing the control panel/regional options on...

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