need help inserting query result in stored procedu

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

SQL Server 2005 Forums

Transact-SQL (2005)

need help inserting query result in stored procedu

Author

Topic

cwfontan
Yak Posting Veteran

87 Posts

Posted - 2009-12-14 : 09:47:52

I want to insert the result of this query to an existing table (append row)...please any help thanks..



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BOA_Normalize]
@param1 nvarchar(max)
as 
DECLARE @param2 as nvarchar(max)
--SET @param1 = 'MERISOL  HADEN RD  HOUSTON, TX  (OUTSIDE SCALE)'
SET @param2 = @param1
SET @param1 =(SELECT [dbo].[BOA_CleanString](@param1))
SELECT  TOP(1) hits, @param2 as myRaw, rawloc, normloc
FROM
(
SELECT [dbo].[BOA_Compare](@param1, val1) as hits, rawLoc, normloc
FROM
(SELECT [dbo].[BOA_CleanString]([rawLoc]) AS val1, rawloc, normloc FROM dbo. BOA__normall3)t
)r
Order By hits desc


Return @@ROWCOUNT

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-12-14 : 09:50:54

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BOA_Normalize]
@param1 nvarchar(max)
as
DECLARE @param2 as nvarchar(max)
--SET @param1 = 'MERISOL HADEN RD HOUSTON, TX (OUTSIDE SCALE)'
SET @param2 = @param1
SET @param1 =(SELECT [dbo].[BOA_CleanString](@param1))
insert into your_table(column_list)
SELECT TOP(1) hits, @param2 as myRaw, rawloc, normloc
FROM
(
SELECT [dbo].[BOA_Compare](@param1, val1) as hits, rawLoc, normloc
FROM
(SELECT [dbo].[BOA_CleanString]([rawLoc]) AS val1, rawloc, normloc FROM dbo. BOA__normall3)t
)r
Order By hits desc

Return @@ROWCOUNT

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources