i dont own the rights to do so. the easiest work to do on this db is custom queries. i still dont understand how their subquery can work...

yup, I was able to work into their query. and i understand why your code works.

this is what they have, but occassionally call me when the query runs for...

i found out that i could check the registry to id the instances. MS wants me to backup and reinstall SQL.

SOFTWARE\\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL

http://sqlblog.com/blogs/buck_woody/archive/2010/03/31/list-sql-server-instances-using-the-registry.aspx

http://support.microsoft.com/kb/909967

lmu92, you've been a big help this far. I appreciate you sharing your knowledge.

I tried rewriting the calculation for the percent as (live_eq_y/live_not_i) * 100

When I try this it...

this is what i see

declare variable as a table

populate a table varible with data

create common table expressions using two queries

calculate percents using select statement with a cross join.

i'm not to...

id - live - disabled

===================

1 Y ...

How about a questions table (probably with a surrogate primary key

Then a policyQuestionDetails table with foreign keys to policy and questions -- probably best to store the answers here as...

i'm trying to reach the first normal form as described http://www.informit.com/articles/article.aspx?p=30646

i'm trying to figure out how to remove policy number becasue there are multiple questions and answers for...