Thank You!!!

Thanks!!

ARGH   I saw what i did    i had duplicated the import into the [localgroupmembershiprostercsv__$] table   so then when i ran my query it would insert and then find the...

This is what is currently in my web.config

<add name="DefaultConnection" connectionString="data source=ServerName;Initial Catalog=DatabaseName;user id=myUser;password=myPassword;" providerName="System.Data.SqlClient" />

This is what I want to use

<add name="DefaultConnection" connectionString="data source=ServerName;Initial Catalog=DatabaseName;Trusted_Connection=True;" providerName="System.Data.SqlClient" />

I went to the...

Once again Thank You ratbak    I changed the procedure to use a return value and that eliminated all of the other selects being shown

There is a return value in the individual functions being called

Jeff, this is the stored procedure

ALTER PROCEDURE [dbo].[GetTheStanine]

@ApplicationID nvarchar(128),
@FamilyID int,
@Dimension int

AS

SET NOCOUNT ON

SELECT 
CASE @Dimension
WHEN 1 THEN dbo.GetMentalAcuityStanin(Acuity,DateViewed,GETDATE()) 
WHEN 2 THEN dbo.GetBusinessTermsStanine(BusMem,DateViewed,GETDATE())  
WHEN 3 THEN dbo.GetMemoryRecallStanine(BusMem,DateViewed,GETDATE())...

hmmm I thought that  it was working properly.  However, when it returns the results instead of a single list, I am getting all of the individual stanines and then the...

That procedure just calls some individual functions used to get each Stanine.

If you are looking for a formula for determining the bellcurve, we pay for studies to be done which...

Excellent !!!  Thank you very much!!

Thank you ratbak

Standard Nine (stanine) values are the 9 values in a bell curve as shown in this image

The procedure GetTheStanine returns an integer value or to...

Thank you.    I don't know why I did not try that before posting.  Evidently I was making it out to be a lot more complicated.

Thank you Luis!     I must not be wording my Google Queries properly because after I did a few searches I could not find anything on that that provided a lick...

Do I need to make any changes when it is saved via SPROC?

Here is the Current SPROC

ALTER PROCEDURE [dbo].[AddButtons]

@LanguageID int,
@ButtonText nvarchar(200),
@ButtonID int

AS

SET NOCOUNT ON

IF EXISTS (SELECT ButtonText...

Thank you.  I saw that it changed it to varchar and edited my original post to be an image of my query