Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

T-SQL translation of select... into

2 posts in Third Party Products Last posting was on 2008-08-14 20:51:12.0Z
<ns_dkerber Posted on 2008-08-14 20:39:47.0Z
From: <ns_dkerber@ns_WarrenRogersAssociates.com>
Newsgroups: news.3rd_party_products
Subject: T-SQL translation of select... into
Message-ID: <MPG.230e620dd10c37f6989704@forums.sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
User-Agent: MicroPlanet-Gravity/2.70.2067
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 14 Aug 2008 13:39:47 -0700
X-Trace: forums-1-dub 1218746387 10.22.241.152 (14 Aug 2008 13:39:47 -0700)
X-Original-Trace: 14 Aug 2008 13:39:47 -0700, vip152.sybase.com
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub news.3rd_party_products:1244
Article PK: 20352

One of our customers is requiring us to port our application to M$ SQL
server from our current SQLA 9, and I'm having trouble with a line in a
stored procedure. I used the Sybase Central function "translate to
transact-SQL", and most of it looks ok, but this particular line is
giving trouble:

select lockey,CompKey into @nLocKey, @nCompKey
from SiteView
where SiteID = @sLocID and CompID = @sCompID

Is giving me a "Syntax error near @nLocKey". I'm trying to select a
couple of fields from the db into memory variables for use later in the
SP.

Can somebody help me with this, please?


--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).


<ns_dkerber Posted on 2008-08-14 20:51:12.0Z
From: <ns_dkerber@ns_WarrenRogersAssociates.com>
Newsgroups: news.3rd_party_products
Subject: Re: T-SQL translation of select... into
Message-ID: <MPG.230e64cd3a0c60d7989705@forums.sybase.com>
References: <MPG.230e620dd10c37f6989704@forums.sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
User-Agent: MicroPlanet-Gravity/2.70.2067
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 14 Aug 2008 13:51:12 -0700
X-Trace: forums-1-dub 1218747072 10.22.241.152 (14 Aug 2008 13:51:12 -0700)
X-Original-Trace: 14 Aug 2008 13:51:12 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub news.3rd_party_products:1245
Article PK: 20353

Sorry, wrong group; I'll repost in General.



In article <MPG.230e620dd10c37f6989704@forums.sybase.com>,
ns_dkerber@ns_WarrenRogersAssociates.com says...

> One of our customers is requiring us to port our application to M$ SQL
> server from our current SQLA 9, and I'm having trouble with a line in a
> stored procedure. I used the Sybase Central function "translate to
> transact-SQL", and most of it looks ok, but this particular line is
> giving trouble:
>
> select lockey,CompKey into @nLocKey, @nCompKey
> from SiteView
> where SiteID = @sLocID and CompID = @sCompID
>
> Is giving me a "Syntax error near @nLocKey". I'm trying to select a
> couple of fields from the db into memory variables for use later in the
> SP.
>
> Can somebody help me with this, please?
>
>
>
>

--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).