Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need help parting out a name column
I have a table with a "name" column that I need to part out to seperate columns of first name, middle, last name. Such as John Doe John | | Doe Mary A Smith Mary | A | Smith Bob Van Hushen Bob | | Van Hushen... -
Frequency of payments
I am trying to find the most frequent payment amount in a sql table spanning a 12 month period for 300,000 individual accounts. Does anyone know how I would go about writing a query in SQL to return the most frequent payment and the number of times it occurs throughout the 12 month period... -
adding columns with null values
I am having a problem trying to sum data where some columns have null values in them. I return null when I should be returning a value due to the null in certain cells. col001 col002 col003 150 100 null (col001+col002+col003) = NULL Can anyone tell me how I can sum these... -
Null Value when adding data
Question, is there a way to sum values in columns when there are some with null values in them? I have tried this and my output is null as a sum when null values are in certain cells I am sum or adding up? Does anyone know how I could get around this? I am not able to turn off null values in...
