Output Parameters ONLY - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Output Parameters ONLY

Author

Topic

godistop1
Starting Member

14 Posts

Posted - 2011-01-24 : 11:56:32

I have a stored procedure that has output parameters only and a Merge statement. The merge works correctly and I have created a temporary table to catch the status, if INSERT, ADD, DELETE. When I try set the output parameter by using a SELECT statement I keep getting NULL value.

SET @OutputrecordCntProviderNPIInserted = (SELECT count(*) FROM #SummaryOfChangesNPI WHERE ChangeType = 'INSERT')

But if do not use the output parameters and just
SELECT count(*) FROM #SummaryOfChangesNPI WHERE ChangeType = 'INSERT'

I get correct results.

Will someone tell me what I am doing work or leaving out?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-24 : 12:02:37

your assignment statement looks fine. Is it inside any conditional statement? can you show whole procedure query?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

godistop1
Starting Member

14 Posts

Posted - 2011-01-24 : 12:27:09

Here is the stored procedure.

USE [NPI_DATA]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ====================================================================================
-- Author: -- Create date: 11/17/2010
-- Description: Insert/Update dbo.PROVIDER_NPI table from PROVIDER_NPI_IMPORT
-- =====================================================================================
ALTER PROCEDURE [dbo].[uspProvider_NPI_Insert_Update]
-- Add the parameters for the stored procedure here
@OutputrecordCntProviderNPIInserted numeric(6) OUTPUT,
@OutputrecordCntProviderNPIUpdated numeric(6) OUTPUT

AS

BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

BEGIN TRY
CREATE Table #SummaryOfChangesNPI(ChangeType VARCHAR(100))
begin
MERGE PROVIDER_NPI AS target
USING ( SELECT [NPI]
,[ENTITY_TYPE_CODE]
,[REPLACEMENT_NPI]
,[EMPLOYER_IDENTIFICATION_NUMBER]
,[PROVIDER_ORGANIZATION_NAME]
,[PROVIDER_LAST_NAME]
,[PROVIDER_FIRST_NAME]
,[PROVIDER_MIDDLE_NAME]
,[PROVIDER_NAME_PREFIX_TEXT]
,[PROVIDER_NAME_SUFFIX_TEXT]
,[PROVIDER_CREDENTIAL_TEXT]
,[PROVIDER_OTHER_ORGANIZATION_NAME]
,[PROVIDER_OTHER_ORGANIZATION_NAME_TYPE_CODE]
,[PROVIDER_OTHER_LAST_NAME]
,[PROVIDER_OTHER_FIRST_NAME]
,[PROVIDER_OTHER_MIDDLE_NAME]
,[PROVIDER_OTHER_NAME_PREFIX_TEXT]
,[PROVIDER_OTHER_NAME_SUFFIX_TEXT]
,[PROVIDER_OTHER_CREDENTIAL_TEXT]
,[PROVIDER_OTHER_LAST_NAME_TYPE_CODE]
,[PROVIDER_FIRST_LINE_BUSINESS_MAILING_ADDRESS]
,[PROVIDER_SECOND_LINE_BUSINESS_MAILING_ADDRESS]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_CITY_NAME]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_STATE_NAME]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_POSTAL_CODE]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_COUNTRY_CODE]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_TELEPHONE_NUMBER]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_FAX_NUMBER]
,[PROVIDER_FIRST_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,[PROVIDER_SECOND_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_CITY_NAME]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_STATE_NAME]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_POSTAL_CODE]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_COUNTRY_CODE]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_TELEPHONE_NUMBER]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_FAX_NUMBER]
,[PROVIDER_ENUMERATION_DATE]
,[LAST_UPDATE_DATE]
,[NPI_DEACTIVATION_REASON_CODE]
,[NPI_DEACTIVATION_DATE]
,[NPI_REACTIVATION_DATE]
,[PROVIDER_GENDER_CODE]
,[AUTHORIZED_OFFICIAL_LAST_NAME]
,[AUTHORIZED_OFFICIAL_FIRST_NAME]
,[AUTHORIZED_OFFICIAL_MIDDLE_NAME]
,[AUTHORIZED_OFFICIAL_TITLE_OR_POSITION]
,[AUTHORIZED_OFFICIAL_TELEPHONE_NUMBER]
,[IS_SOLE_PROPRIETOR]
,[IS_ORGANIZATION_SUBPART]
,[PARENT_ORGANIZATION_LBN]
,[PARENT_ORGANIZATION_TIN]
,[AUTHORIZED_OFFICIAL_NAME_PREFIX_TEXT]
,[AUTHORIZED_OFFICIAL_NAME_SUFFIX_TEXT]
,[AUTHORIZED_OFFICIAL_CREDENTIAL_TEXT]
FROM PROVIDER_NPI_IMPORT) AS source
ON target.NPI = source.NPI
WHEN MATCHED AND target.[LAST_UPDATE_DATE] <> source.[LAST_UPDATE_DATE]
THEN
UPDATE SET target.[ENTITY_TYPE_CODE] = source.[ENTITY_TYPE_CODE]
,target.[REPLACEMENT_NPI] = source.[REPLACEMENT_NPI]
,target.[EMPLOYER_IDENTIFICATION_NUMBER] = source.[EMPLOYER_IDENTIFICATION_NUMBER]
,target.[PROVIDER_ORGANIZATION_NAME] = source.[PROVIDER_ORGANIZATION_NAME]
,target.[PROVIDER_LAST_NAME] = source.[PROVIDER_LAST_NAME]
,target.[PROVIDER_FIRST_NAME] = source.[PROVIDER_FIRST_NAME]
,target.[PROVIDER_MIDDLE_NAME] = source.[PROVIDER_MIDDLE_NAME]
,target.[PROVIDER_NAME_PREFIX_TEXT] = source.[PROVIDER_NAME_PREFIX_TEXT]
,target.[PROVIDER_NAME_SUFFIX_TEXT] = source.[PROVIDER_NAME_SUFFIX_TEXT]
,target.[PROVIDER_CREDENTIAL_TEXT] = source.[PROVIDER_CREDENTIAL_TEXT]
,target.[PROVIDER_OTHER_ORGANIZATION_NAME] = source.[PROVIDER_OTHER_ORGANIZATION_NAME]
,target.[PROVIDER_OTHER_ORGANIZATION_NAME_TYPE_CODE] = source.[PROVIDER_OTHER_ORGANIZATION_NAME_TYPE_CODE]
,target.[PROVIDER_OTHER_LAST_NAME] = source.[PROVIDER_OTHER_LAST_NAME]
,target.[PROVIDER_OTHER_FIRST_NAME] = source.[PROVIDER_OTHER_FIRST_NAME]
,target.[PROVIDER_OTHER_MIDDLE_NAME] = source.[PROVIDER_OTHER_MIDDLE_NAME]
,target.[PROVIDER_OTHER_NAME_PREFIX_TEXT] = source.[PROVIDER_OTHER_NAME_PREFIX_TEXT]
,target.[PROVIDER_OTHER_NAME_SUFFIX_TEXT] = source.[PROVIDER_OTHER_NAME_SUFFIX_TEXT]
,target.[PROVIDER_OTHER_CREDENTIAL_TEXT] = source.[PROVIDER_OTHER_CREDENTIAL_TEXT]
,target.[PROVIDER_OTHER_LAST_NAME_TYPE_CODE] = source.[PROVIDER_OTHER_LAST_NAME_TYPE_CODE]
,target.[PROVIDER_FIRST_LINE_BUSINESS_MAILING_ADDRESS] = source.[PROVIDER_FIRST_LINE_BUSINESS_MAILING_ADDRESS]
,target.[PROVIDER_SECOND_LINE_BUSINESS_MAILING_ADDRESS] = source.[PROVIDER_SECOND_LINE_BUSINESS_MAILING_ADDRESS]
,target.[PROVIDER_BUSINESS_MAILING_ADDRESS_CITY_NAME] = source.[PROVIDER_BUSINESS_MAILING_ADDRESS_CITY_NAME]
,target.[PROVIDER_BUSINESS_MAILING_ADDRESS_STATE_NAME] = source.[PROVIDER_BUSINESS_MAILING_ADDRESS_STATE_NAME]
,target.[PROVIDER_BUSINESS_MAILING_ADDRESS_POSTAL_CODE] = source.[PROVIDER_BUSINESS_MAILING_ADDRESS_POSTAL_CODE]
,target.[PROVIDER_BUSINESS_MAILING_ADDRESS_COUNTRY_CODE] = source.[PROVIDER_BUSINESS_MAILING_ADDRESS_COUNTRY_CODE]
,target.[PROVIDER_BUSINESS_MAILING_ADDRESS_TELEPHONE_NUMBER] = source.[PROVIDER_BUSINESS_MAILING_ADDRESS_TELEPHONE_NUMBER]
,target.[PROVIDER_BUSINESS_MAILING_ADDRESS_FAX_NUMBER] = source.[PROVIDER_BUSINESS_MAILING_ADDRESS_FAX_NUMBER]
,target.[PROVIDER_FIRST_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS] = source.[PROVIDER_FIRST_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,target.[PROVIDER_SECOND_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS] = source.[PROVIDER_SECOND_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,target.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_CITY_NAME] = source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_CITY_NAME]
,target.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_STATE_NAME] = source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_STATE_NAME]
,target.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_POSTAL_CODE] = source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_POSTAL_CODE]
,target.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_COUNTRY_CODE] = source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_COUNTRY_CODE]
,target.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_TELEPHONE_NUMBER] = source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_TELEPHONE_NUMBER]
,target.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_FAX_NUMBER] = source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_FAX_NUMBER]
,target.[PROVIDER_ENUMERATION_DATE] = source.[PROVIDER_ENUMERATION_DATE]
,target.[LAST_UPDATE_DATE] = source.[LAST_UPDATE_DATE]
,target.[NPI_DEACTIVATION_REASON_CODE] = source.[NPI_DEACTIVATION_REASON_CODE]
,target.[NPI_DEACTIVATION_DATE] = source.[NPI_DEACTIVATION_DATE]
,target.[NPI_REACTIVATION_DATE] = source.[NPI_REACTIVATION_DATE]
,target.[PROVIDER_GENDER_CODE] = source.[PROVIDER_GENDER_CODE]
,target.[AUTHORIZED_OFFICIAL_LAST_NAME] = source.[AUTHORIZED_OFFICIAL_LAST_NAME]
,target.[AUTHORIZED_OFFICIAL_FIRST_NAME] = source.[AUTHORIZED_OFFICIAL_FIRST_NAME]
,target.[AUTHORIZED_OFFICIAL_MIDDLE_NAME] = source.[AUTHORIZED_OFFICIAL_MIDDLE_NAME]
,target.[AUTHORIZED_OFFICIAL_TITLE_OR_POSITION] = source.[AUTHORIZED_OFFICIAL_TITLE_OR_POSITION]
,target.[AUTHORIZED_OFFICIAL_TELEPHONE_NUMBER] = source.[AUTHORIZED_OFFICIAL_TELEPHONE_NUMBER]
,target.[IS_SOLE_PROPRIETOR] = source.[IS_SOLE_PROPRIETOR]
,target.[IS_ORGANIZATION_SUBPART] = source.[IS_ORGANIZATION_SUBPART]
,target.[PARENT_ORGANIZATION_LBN] = source.[PARENT_ORGANIZATION_LBN]
,target.[PARENT_ORGANIZATION_TIN] = source.[PARENT_ORGANIZATION_TIN]
,target.[AUTHORIZED_OFFICIAL_NAME_PREFIX_TEXT] = source.[AUTHORIZED_OFFICIAL_NAME_PREFIX_TEXT]
,target.[AUTHORIZED_OFFICIAL_NAME_SUFFIX_TEXT] = source.[AUTHORIZED_OFFICIAL_NAME_SUFFIX_TEXT]
,target.[AUTHORIZED_OFFICIAL_CREDENTIAL_TEXT] = source.[AUTHORIZED_OFFICIAL_CREDENTIAL_TEXT]
WHEN NOT MATCHED BY target
THEN
INSERT
([NPI]
,[ENTITY_TYPE_CODE]
,[REPLACEMENT_NPI]
,[EMPLOYER_IDENTIFICATION_NUMBER]
,[PROVIDER_ORGANIZATION_NAME]
,[PROVIDER_LAST_NAME]
,[PROVIDER_FIRST_NAME]
,[PROVIDER_MIDDLE_NAME]
,[PROVIDER_NAME_PREFIX_TEXT]
,[PROVIDER_NAME_SUFFIX_TEXT]
,[PROVIDER_CREDENTIAL_TEXT]
,[PROVIDER_OTHER_ORGANIZATION_NAME]
,[PROVIDER_OTHER_ORGANIZATION_NAME_TYPE_CODE]
,[PROVIDER_OTHER_LAST_NAME]
,[PROVIDER_OTHER_FIRST_NAME]
,[PROVIDER_OTHER_MIDDLE_NAME]
,[PROVIDER_OTHER_NAME_PREFIX_TEXT]
,[PROVIDER_OTHER_NAME_SUFFIX_TEXT]
,[PROVIDER_OTHER_CREDENTIAL_TEXT]
,[PROVIDER_OTHER_LAST_NAME_TYPE_CODE]
,[PROVIDER_FIRST_LINE_BUSINESS_MAILING_ADDRESS]
,[PROVIDER_SECOND_LINE_BUSINESS_MAILING_ADDRESS]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_CITY_NAME]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_STATE_NAME]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_POSTAL_CODE]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_COUNTRY_CODE]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_TELEPHONE_NUMBER]
,[PROVIDER_BUSINESS_MAILING_ADDRESS_FAX_NUMBER]
,[PROVIDER_FIRST_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,[PROVIDER_SECOND_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_CITY_NAME]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_STATE_NAME]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_POSTAL_CODE]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_COUNTRY_CODE]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_TELEPHONE_NUMBER]
,[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_FAX_NUMBER]
,[PROVIDER_ENUMERATION_DATE]
,[LAST_UPDATE_DATE]
,[NPI_DEACTIVATION_REASON_CODE]
,[NPI_DEACTIVATION_DATE]
,[NPI_REACTIVATION_DATE]
,[PROVIDER_GENDER_CODE]
,[AUTHORIZED_OFFICIAL_LAST_NAME]
,[AUTHORIZED_OFFICIAL_FIRST_NAME]
,[AUTHORIZED_OFFICIAL_MIDDLE_NAME]
,[AUTHORIZED_OFFICIAL_TITLE_OR_POSITION]
,[AUTHORIZED_OFFICIAL_TELEPHONE_NUMBER]
,[IS_SOLE_PROPRIETOR]
,[IS_ORGANIZATION_SUBPART]
,[PARENT_ORGANIZATION_LBN]
,[PARENT_ORGANIZATION_TIN]
,[AUTHORIZED_OFFICIAL_NAME_PREFIX_TEXT]
,[AUTHORIZED_OFFICIAL_NAME_SUFFIX_TEXT]
,[AUTHORIZED_OFFICIAL_CREDENTIAL_TEXT]
)
VALUES
(source.[NPI]
,source.[ENTITY_TYPE_CODE]
,source.[REPLACEMENT_NPI]
,source.[EMPLOYER_IDENTIFICATION_NUMBER]
,source.[PROVIDER_ORGANIZATION_NAME]
,source.[PROVIDER_LAST_NAME]
,source.[PROVIDER_FIRST_NAME]
,source.[PROVIDER_MIDDLE_NAME]
,source.[PROVIDER_NAME_PREFIX_TEXT]
,source.[PROVIDER_NAME_SUFFIX_TEXT]
,source.[PROVIDER_CREDENTIAL_TEXT]
,source.[PROVIDER_OTHER_ORGANIZATION_NAME]
,source.[PROVIDER_OTHER_ORGANIZATION_NAME_TYPE_CODE]
,source.[PROVIDER_OTHER_LAST_NAME]
,source.[PROVIDER_OTHER_FIRST_NAME]
,source.[PROVIDER_OTHER_MIDDLE_NAME]
,source.[PROVIDER_OTHER_NAME_PREFIX_TEXT]
,source.[PROVIDER_OTHER_NAME_SUFFIX_TEXT]
,source.[PROVIDER_OTHER_CREDENTIAL_TEXT]
,source.[PROVIDER_OTHER_LAST_NAME_TYPE_CODE]
,source.[PROVIDER_FIRST_LINE_BUSINESS_MAILING_ADDRESS]
,source.[PROVIDER_SECOND_LINE_BUSINESS_MAILING_ADDRESS]
,source.[PROVIDER_BUSINESS_MAILING_ADDRESS_CITY_NAME]
,source.[PROVIDER_BUSINESS_MAILING_ADDRESS_STATE_NAME]
,source.[PROVIDER_BUSINESS_MAILING_ADDRESS_POSTAL_CODE]
,source.[PROVIDER_BUSINESS_MAILING_ADDRESS_COUNTRY_CODE]
,source.[PROVIDER_BUSINESS_MAILING_ADDRESS_TELEPHONE_NUMBER]
,source.[PROVIDER_BUSINESS_MAILING_ADDRESS_FAX_NUMBER]
,source.[PROVIDER_FIRST_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,source.[PROVIDER_SECOND_LINE_BUSINESS_PRACTICE_LOCATION_ADDRESS]
,source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_CITY_NAME]
,source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_STATE_NAME]
,source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_POSTAL_CODE]
,source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_COUNTRY_CODE]
,source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_TELEPHONE_NUMBER]
,source.[PROVIDER_BUSINESS_PRACTICE_LOCATION_ADDRESS_FAX_NUMBER]
,source.[PROVIDER_ENUMERATION_DATE]
,source.[LAST_UPDATE_DATE]
,source.[NPI_DEACTIVATION_REASON_CODE]
,source.[NPI_DEACTIVATION_DATE]
,source.[NPI_REACTIVATION_DATE]
,source.[PROVIDER_GENDER_CODE]
,source.[AUTHORIZED_OFFICIAL_LAST_NAME]
,source.[AUTHORIZED_OFFICIAL_FIRST_NAME]
,source.[AUTHORIZED_OFFICIAL_MIDDLE_NAME]
,source.[AUTHORIZED_OFFICIAL_TITLE_OR_POSITION]
,source.[AUTHORIZED_OFFICIAL_TELEPHONE_NUMBER]
,source.[IS_SOLE_PROPRIETOR]
,source.[IS_ORGANIZATION_SUBPART]
,source.[PARENT_ORGANIZATION_LBN]
,source.[PARENT_ORGANIZATION_TIN]
,source.[AUTHORIZED_OFFICIAL_NAME_PREFIX_TEXT]
,source.[AUTHORIZED_OFFICIAL_NAME_SUFFIX_TEXT]
,source.[AUTHORIZED_OFFICIAL_CREDENTIAL_TEXT]
)
OUTPUT $action INTO #SummaryOfChangesNPI;
end

SET @OutputrecordCntProviderNPIInserted = (SELECT count(*) FROM #SummaryOfChangesNPI WHERE ChangeType = 'INSERT')
SET @OutputrecordCntProviderNPIUpdated = (SELECT count(*) FROM #SummaryOfChangesNPI WHERE ChangeType <> 'INSERT')
-- SELECT count(*) FROM #SummaryOfChangesNPI WHERE ChangeType = 'INSERT'
DROP TABLE #SummaryOfChangesNPI;

UPDATE STATISTICS dbo.PROVIDER_NPI

SET NOCOUNT OFF;

END TRY
BEGIN CATCH
-- EXECUTE uspGetErrorInfo
END CATCH
END

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-24 : 12:29:31

even this looks ok. how are calling this proc?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

godistop1
Starting Member

14 Posts

Posted - 2011-01-24 : 12:39:45

From SQL Server Management Studio, right click Execute Stored procedure.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-24 : 12:44:20

nope. thats not the way to do. take a new query window and do like


DECLARE @Var1 Numeric(6,0),@var2 Numeric(6,0)

EXEC [dbo].[uspProvider_NPI_Insert_Update] @Var1 OUT, @Var2 OUT

SELECT @Var1,@var2

and check the returned values

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

godistop1
Starting Member

14 Posts

Posted - 2011-01-24 : 13:02:09

Either that do not work or I am doing it wrong.

I copy the above code in a new query window and execute from the SQL Server Management.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-24 : 13:03:19

and still you get NULL?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-24 : 13:05:00

see this

http://www.sqlteam.com/article/stored-procedures-returning-data

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

godistop1
Starting Member

14 Posts

Posted - 2011-01-24 : 13:26:15

Yes, still NULL.
Checking out the link now.

godistop1
Starting Member

14 Posts

Posted - 2011-01-24 : 13:45:16

What is a return value of -6 means?