That's what these indicate :

just move the case the to departement id depending on the james of the row and that'll work.

Select * from master.dbo.SysDatabases

Select db_name()

Haven't said anything yet .

Sounds almost impossible... you want to show the data for one thing, but not for the other... but for the other too???

You can do something like this, but I'm not totally sure it solves the problem in this case.

select AOofficeName as Office, count(ARid) as totReferrals ,case when UserName IN ('james1', 'james2')...

That the kind of threads that Sushila swore to participate in only on Fridays.

Nothing in particular comes to mind... except all those sex related traits.

I was reffering to a sum(case) solution but that should do it... unless we don't have all the info.

Is it Friday already??

Blue menu on the top - Ressource - Script

SO???

Select..

isnull(Diffe, @Defaultvalue)

What are you not getting?

Try the exemple I showed you, it's pretty straight forward... this is something you must learn before using.

You'll hve to use the isnull technic... that's the simple way around this one.

No, just don't include the column in the insert if you don't insert it. If this is a general statement, then you have to do something like this :...