Search results for query: *

Hello, I am trying to count how many menbers have a flag in 14 flag fields in a table.I have a table called Identified and i have those 14 flag fields that can have 3 answers (Y, N, -) in them. How would i do a count for those 14 flagged fields? i can do them independently but that seems a...

Hello, I am trying to convert an Oracle script that uses (+) outer join sign so a SAS program that runs multiple scripts can run this as well. This script is to get an Assessment taken with all questions whether they answered them or not and return all the responses. Responses have data in the...

I was wondering what a good book to learn more advanced Oracle sql would be. I have a book i started to learn sql with years ago and now need to learn more since 11g has more features then i am aware of and need to learn. Book i started with is: SQL Queries for Mere Mortals(R): A Hands-On Guide...

I am trying to code to get the responses from a questionaire. I have to find people who based on previous questions who said "no" and and now on more recent questionaire said yes to same Question)Id. I have the tables matched to what they need but i am having problems with how to check the...

Hello, I am tring to write sql to find the quarter for a date field and would like the results by quarter along with member count. So i have a date field from a table. I am getting messed up using the extract function to get the month from the date field and then finding the quarter it belongs...