Dang that sux, this would be much easier and cleaner with access to the db. What value is Assignee is it the full name? Is that what you wish to...

I am the noob here but when I create a Parameter for a query I find the table that just has say the assignees or users or location in...

Wow that plugin even does Active X. That's great because without Active X you cant print your reports.

I'm betting some may get irritated that you spamed this post 3 times. In my limited experince posting it once is enough.:-P

Thanks for the feedback Jeff,

This became a very valuable lesson in my eyes. I am already wanting to go down to the office and open up some of my previous...

Okay I really feel stupid after looking at this some more. :blush:

WHERE Column <>0

This "works" because NULLS are part of the three valued predicate logic. True, False and Unknown....

Oh dear god this will consume me tomorrow trying to figure this out. But I agree letting me try to do this on my own will make it stick. I'm...

Now I'm thoroughly confused? Why does that work? I thought NULL wasn't equal to anything. :blush:

Jeff, I'm so sorry this may be a very dumb question but in your examples when the column is NULLABLE why is that expression wrong? I just tested it on...

Very fortunately, SQL Server will frequently ignore an ISNULL on a non-nullable column but I agree... it makes for unnecessary clutter. And I also agree that doing things by...

I'm not sure if I'm even allowed to have a pet peeve as I have only been doing this a year. However one thing that has bothered me is every...

kimberly_lehman (6/6/2014)

So would you consider this a valid answer? "I think it's CURRENT TIMESTAMP but if I was blanking...

I got bored this morning. I'm sure someone else could do better and more accurate.

Luis Cazares (6/5/2014)

I could alias them and join them. 😀

SELECT *

FROM NorthAmerica na

JOIN SouthAmerica sa ON na.PanamaSouthBorder = sa.ColombiaNorthBorder

JOIN Europe ...

But how would you alias those continents?:hehe::hehe:

***Just Kidding