Brandie Tarvin (1/8/2013)

Gail, believe it or not,...

Hi Brandie,

You pointed me to the right direction and sometimes that's the best thing to do.

Added this in the start of my query and everything was good:

/* SELECT FROM [dbo].[OINV]...

Thanks for your reply.

I have brain freeze right now. Without disputing what you just said, I have more queries successfully running with the same syntax; what's uniquly stupid I am...

I am calling the entire piece as written, with parameter @CardName declared exactly how I have above.

Regards.

I am running it directly in the application's (SAP in this case) query generator.

Tried to run it SQL server management studio but it runs without error but with no result,...

Sorry for missing that out. The error is:

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Must declare the scalar variable "@CardName". 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Service Contracts' (OCTR)...

Found out the problem. My fault.

Thank you very much for the solution. It is working as I wanted.

Regards,

Kanu

Hi Anthony,

Thanks for the solution. The query is giving some syntax error:

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near...

Hi Gila,

A very good reply. Yes I am new to the hardware side of things but I don't need to learn the whole stuff. Being a functional resource, I just...

Thanks Padhis. And what is the hardware required for the software; can that hardware be used to install other applications - like SAP?

Regards,

K

Hello,

Thanks a lot again. I have advised the server team about it. I do not have access to the server so I will get to know what was the result...

Hello Gianluca,

Thank you very much for your answer. Alhough I have to confess that I have not understood it completely due to my limited database administration vocabulary, but I think...