Search results for query: *

I'm not sure this can be done, but I have a report that in manually updated in Excel for distribution. The client would like to have it automatically sent monthly using SSRS. The reports shows trending of membership from month to month based on data from a table that gets populated with a SQL...

I am trying to construct a dynamic pivot query for a report that uses a company period counts table for monthly membership by chapter. What the table has a column for the year and a separate column for the month as there is a stored procedure that fires monthly to populate the values for the...

I have a field in a survey results table that was populated with jscript code for the recommended action based on a set of answers. The field name is g.Risk_Validation. Data inside looks like this : {n1} == 7C2A4E1F-D2AB-4263-A1D5-78B93C4C0E90 || {n1} == B5F6DDC7-FCF2-4209-8F1C-D974B2158AAE...

I am tried several approaches to this and searched for an answer but haven't found anything so here goes. I have been tasked with getting the result from an activity tracking table for the first 30 days of activity. Problem is each user has a different activity start date. The results are...

I have been searching but can't seem to locate an answer for this. I have a file I need to create that has a header row with the count of the number of rows that will be following for checking. When the initial test sp was built there were only the TOP 10 records selected and when the SQL was...

I am having some issues trying to get a query to exclude some individuals from a mailing list. I have 3 tables, one for clients and 1 for program participation and 1 for individuals. Individuals can participate on multiple programs, but I am trying to get only those who have not particpated in...

I have been searching for an answer of this. I have an Avery 5160 label report that in SSRS where I have a field for address line 2 that for the most part returns nothing. I have to create a field for it if there is something in the field, but unlike Crystal, you can't simply supress the field...

I have a spreadsheet that I need to do some analysis on. I am trying to count a range of cells if they have a value higher than a standard, but need to only count them if the value in another cell is met. Here is what I have (short version) Waist Gender 11.0 F 12.0 M 06.0 M...

I am working on a project that involves a membership drive and a contest to place people into a "drawing". This is based on renewing their membership and if they renew for 2 years, then they get 2 "entries". I was able to give them a value of 2 on the row, but now I need to create a temp table...

We have users creating duplicate customer accounts. To help cut down on this, I have a stored procedure that uses soundex to warn the users before saving the record. However it is not evaluating like I want. I was able to add customers 3 times without the address line being taken into account...

I have a report that counts and sums source codes from membership applications, by chapter. The query is a stored procedure from an SQL server. The result set is fine, but in the report I am getting these results: Jan Feb Mar May SourceA 1 3 1 0 SourceB 0...

I am sure that I am missing something since I have been on this same problem for a few days,but... I have a column in a table that I need to "de-concatenate" I thought this was working in the past, but now when I view the results and compare them to the field, I am missing the last phrase. The...

I have field in a table that contains data that looks like this: Topic ID heart health,joint care,bone health 12354 joint care, healthy living 21325 heart health, healthy living 25154 healthy living...

I was working on this earlier in the week, and while trying to create a view from an SP, it was suggested that I create a UDF and call that function from inside of a view. I am stuck, since I am not sure what I am doing. Do I need to create 2 functions to get this to run? Here is the code that...

I have a stored procedure that "de-concatenates" a text column that was poorly designed. The column has results from a survey where the responses are: Healthy lifestyles Healthy lifestyles,Mens health Healthy lifestyles,familiy health,cancer prevention Family health, bone and joint care...

I have a stored proceedure that runs a report that automatically fills in the date variable. I planned to have a change when the end of the year came around, and now the report won't work. I can't see the problem. Perhaps someone can give this code a quick look over and see what the problem is...

Being new to SQL and being up against a deadline, I have a problem that I know is simple, but I need to get this done. I have a procedure that outputs to a text file. The results look fine in the query analyzer, but there are no spaces between the results. What I need is to add spaces to these...

Being new to Crystal, I have a field that is formatted as a string, but is a date field. I need to create a formula that calculates an age from this date. Here is what I have. If not(isnull({tablename;1.Birthday}))then DateDiff ('yyyy',Today() ,CDate({tablename;1.Birthday})) ELSE 00000000 What...

I have a field in our data base that contains the response to a question of why applicants joined the organization. The vendor designed this field as a varchar data type and separated the choices with a comma. A list box determines the choices that data entry can input, however the results are...

I am very new to SQL. I have a situation that calls for me to calculate renewing memberships. The criteria is that the membership join date must be greater than 2 months from the pay date. This is considered a renewal. Once I am able to get the correct results, I will need to make this available...