hahaha...it did it to me too!! "javascript" didn't show up!

thanks for the laugh first thing in the morning!! 😀

i've used...

i agree with this solution. usually...

i found my issue and am posting the solution just in case someone else runs into the same problem:

The data type was the issue. The Parameter 'DateRangeType' (Text data...

yes, you can use ' ' or n/a or anything else like that.

here's a bit of information on rules of normalization: http://qa.sqlservercentral.com/blogs/abhijit_desai/2010/09/07/noramlization/ However, in this case, you're looking at data that seems to have a clear relationship, so a...

are you creating one denormalized table using data from several views? i've done something like this recently and although it's labor intensive, it's not difficult to do. please...

thank you both Lynn and Sean - I appreciate your patience.

below is a more detail - i wanted to try to keep it simple but apparently i over-simplified the first...

hello all..thanks for your help. part of my problem was there was an extra character in the Pass_Fail values. ltrim and rtrim took care of that, then Count(iif...)...

unfortunately this didn't work either. 🙁

Hi Joie,

I need it to count the "P" only - result should be 5 but i'm getting 8, which is the total of all rows in this small test db....

Hi Fabrizio,

The course titled SQL Server 2008/R2 DBA is over 50 hours of video teaching and the cost is us$99 - url=http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx#ChapterListing][/url]. I am not affiliated with this company,...

fabrizio, it is a vid tutorial series so you could take it at your own pace.

Hi Jason,

I thought...

Hi Fabrizio,

I taught myself SQL with the help of some really great resources. I've found an instructor to be extremely helpful in explaining the in's and out's...Scott Whigham of...