Beginner Compile Error

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hello all pro
excuse me for this question but i m a beginner i have this error when execute my stored procedure:
Incorrect syntax near the keyword 'Table'
this is my sp:

SQL

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE Sp_GetPersonVsFinanc
@source Table output
AS
BEGIN
	SET NOCOUNT ON;
	SELECT p.Id,p.Name,p.Family,f.DebtValue,f.BestankarValue
	into source
	from tbl_PersonInfo p join Financial f 
	on p.Id = f.FinancialPersonID
END
GO

Posted 29-Aug-12 21:33pm

daghune

Updated 29-Aug-12 21:35pm

Rajesh Anuhya

v2

Add a Solution

Comments

Rajesh Anuhya 30-Aug-12 3:35am

Pre tags added.
--RA

daghune 30-Aug-12 3:39am

CREATE PROCEDURE Sp_GetPersonVsFinanc
@source Table output
AS
BEGIN
SET NOCOUNT ON;
SELECT p.Id,p.Name,p.Family,f.DebtValue,f.BestankarValue
into source
from tbl_PersonInfo p join Financial f
on p.Id = f.FinancialPersonID
END

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Accepted Answer · 2012-08-29T21:37:00

Solution 1

Try this:

SQL

CREATE PROCEDURE Sp_GetPersonVsFinanc
AS
BEGIN
	SELECT p.Id,p.Name,p.Family,f.DebtValue,f.BestankarValue
	from tbl_PersonInfo p join Financial f 
	on p.Id = f.FinancialPersonID
END
GO

You don't suppose to add @source Table output, Select command will take care of returning records.

--Amit

Posted 29-Aug-12 21:37pm

_Amy

Updated 29-Aug-12 22:45pm

v3

Comments

daghune 30-Aug-12 3:42am

thank you _Amy

__TR__ 30-Aug-12 3:45am

Hi,
I think the above 'select into' statement will create a 'source' table and give an error when it is executed again. So it would be better if we use #source.
SELECT p.Id,p.Name,p.Family,f.DebtValue,f.BestankarValue
into #source
from tbl_PersonInfo p join Financial f
on p.Id = f.FinancialPersonID

Also i think there is no point inserting it into another table, we can just query the tables and get the result. I hope i am making sense.

_Amy 30-Aug-12 4:46am

Yes you are right. Now he can use the procedure easily. Thank you. :)

__TR__ 30-Aug-12 5:02am

5ed!

daghune 30-Aug-12 5:50am

thanks pro

daghune 30-Aug-12 4:38am

could you write for me c# code that use this sp and fill datagridview with it??

bbirajdar 30-Aug-12 4:50am

Yes. Someone will surely write this code for you if you give him your one day's salary....

daghune 30-Aug-12 5:33am

lashgushhhhhhhhhhhh

daghune 30-Aug-12 5:37am

The scientist has to publish his knowledge and Ignorant people are scared of publishing their knowledge................

bbirajdar 30-Aug-12 7:03am

You are right.. Some hundred thousand 'scientists' have already published their knowledge here . Check here

_Amy 30-Aug-12 7:21am

Thumbs up. :)

bbirajdar 30-Aug-12 7:28am

:) .. I am wondering why Apple sued Samsung for Pinch Zoom patent while I have been pinching my classmates in school ever since my nursery, pre-school classes...Apple is so ignorant about pinching...

member60 30-Aug-12 4:48am

My 5!