Running [dbo].[insertProjectDetails] ( @ProjectTitle = <DEFAULT>, @ProjectPeriod = <DEF

Running [dbo].[insertProjectDetails] ( @.ProjectTitle = <DEFAULT>, @.ProjectPeriod = <DEFAULT>, @.Client = <DEFAULT>, @.Position = <DEFAULT>, @.ProjectDescription = <DEFAULT>, @.Responsiblities = <DEFAULT>, @.OtherInformation = <DEFAULT> ).

Procedure or Function 'insertProjectDetails' expects parameter '@.ProjectTitle', which was not supplied.

No rows affected.

(0 row(s) returned)

@.RETURN_VALUE =

Finished running [dbo].[insertProjectDetails].

Can any body send solution for this error?

Running [dbo].[insertProjectDetails] ( @.ProjectTitle = <DEFAULT>, @.ProjectPeriod = <DEFAULT>, @.Client = <DEFAULT>, @.Position = <DEFAULT>, @.ProjectDescription = <DEFAULT>, @.Responsiblities = <DEFAULT>, @.OtherInformation = <DEFAULT> ).

Procedure or Function 'insertProjectDetails' expects parameter '@.ProjectTitle', which was not supplied.

No rows affected.

(0 row(s) returned)

@.RETURN_VALUE =

Finished running [dbo].[insertProjectDetails].

|||

Could you explain what is the problem?

If the SP is expecting parameters such as Date or a string then make sure to pass when it is called, as the error is self-explanatory.

|||PLease do not post multiple (duplicate) threads for the same problem.|||

Hi,

the projectTitle parameter does not have a default value, therefore SQL Server complains about the facts that no value is passed in. Either pass a value to the procedure or change the procedure to use a Default value if noone is passed in.

ALTER PROCEDURE SomeProc
(
@.SomeParamWithDefault INT = 1 --The = 1 is for the default.
)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Running [dbo].[insertProjectDetails] ( @ProjectTitle = <DEFAULT>, @ProjectPeriod = <

Running [dbo].[insertProjectDetails] ( @.ProjectTitle = <DEFAULT>, @.ProjectPeriod = <DEFAULT>, @.Client = <DEFAULT>, @.Position = <DEFAULT>, @.ProjectDescription = <DEFAULT>, @.Responsiblities = <DEFAULT>, @.OtherInformation = <DEFAULT> ).

Procedure or Function 'insertProjectDetails' expects parameter '@.ProjectTitle', which was not supplied.

No rows affected.

(0 row(s) returned)

@.RETURN_VALUE =

Finished running [dbo].[insertProjectDetails].

Can any body send solution for this error?

Running [dbo].[insertProjectDetails] ( @.ProjectTitle = <DEFAULT>, @.ProjectPeriod = <DEFAULT>, @.Client = <DEFAULT>, @.Position = <DEFAULT>, @.ProjectDescription = <DEFAULT>, @.Responsiblities = <DEFAULT>, @.OtherInformation = <DEFAULT> ).

Procedure or Function 'insertProjectDetails' expects parameter '@.ProjectTitle', which was not supplied.

No rows affected.

(0 row(s) returned)

@.RETURN_VALUE =

Finished running [dbo].[insertProjectDetails].

|||

Could you explain what is the problem?

If the SP is expecting parameters such as Date or a string then make sure to pass when it is called, as the error is self-explanatory.

|||PLease do not post multiple (duplicate) threads for the same problem.|||

Hi,

the projectTitle parameter does not have a default value, therefore SQL Server complains about the facts that no value is passed in. Either pass a value to the procedure or change the procedure to use a Default value if noone is passed in.

ALTER PROCEDURE SomeProc
(
@.SomeParamWithDefault INT = 1 --The = 1 is for the default.
)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

rtrim in sql server 2000

Hi,
What is wrong with the following query?
select a.name, rtrim(a.name) from (
select top 100 name from dbo.table1 )a
whre table1 has the following in name column
A.B.xyz<space>
AB.xyz<space>
and so on...
When i cut and paste the result set from query analyzer into Excel, i
still see the trailing space.
BTW, i am using sql server 2000
Thanks in advance,
TamasWhat data type is the name column? The char/nchar/binary datatypes are of
fixed length, while varchar/nvarchar/varbinary are variable.
"Trimming spaces from fixed length columns is futile. You will be overpadded
."
ML
http://milambda.blogspot.com/|||what is the a.name datatype ?
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
<tamashee@.yahoo.com> wrote in message
news:1145399053.665196.72630@.e56g2000cwe.googlegroups.com...
> Hi,
> What is wrong with the following query?
> select a.name, rtrim(a.name) from (
> select top 100 name from dbo.table1 )a
> whre table1 has the following in name column
> A.B.xyz<space>
> AB.xyz<space>
> and so on...
> When i cut and paste the result set from query analyzer into Excel, i
> still see the trailing space.
> BTW, i am using sql server 2000
> Thanks in advance,
> Tamas
>