Access Query >> sql server

Would it be possible for me to simply paste this access query into a SQL
Server stored procedure:

SELECT asplGroupTbl.groupname, asplMemberTbl.userid
FROM asplGroupTbl INNER JOIN asplMemberTbl ON asplGroupTbl.groupid =
asplMemberTbl.groupid
WHERE (((asplMemberTbl.userid)=5));

Is this okay?

Thank you
Jason

[Bob Lehmann]

What happened when you tried it?

Bob Lehmann

<jason@catamaranco.com> wrote in message
news:O4E87QadEHA.1648@TK2MSFTNGP11.phx.gbl...

> Would it be possible for me to simply paste this access query into a SQL
> Server stored procedure:
>
> SELECT asplGroupTbl.groupname, asplMemberTbl.userid
> FROM asplGroupTbl INNER JOIN asplMemberTbl ON asplGroupTbl.groupid =
> asplMemberTbl.groupid
> WHERE (((asplMemberTbl.userid)=5));
>
> Is this okay?
>
> Thank you
> Jason
>
>

Well, the syntac checks 'succesful' I still need to call it from my script,
but here is how I adapted it:


CREATE PROCEDURE [Query1] AS

SELECT asplGroupTbl.groupname, asplMemberTbl.userid
FROM asplGroupTbl INNER JOIN asplMemberTbl ON asplGroupTbl.groupid =
asplMemberTbl.groupid
WHERE (((asplMemberTbl.userid)=5));

....Then, I went to SQL QUERY ANALYZER and attempted to execute it to return
the records.....this is what happened:

DECLARE @RC int
EXEC @RC = [V032U10DUW].[dbo].[Query1]
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: V032U10DUW.dbo.Query1'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine

I am not sure what this actually means...it appears to be an error
message...am I on the right track?

Thanks
Jason




"Bob Lehmann" <none> wrote in message
news:ebSE9madEHA.3704@TK2MSFTNGP09.phx.gbl...

> What happened when you tried it?
>
> Bob Lehmann
>
> <jason@catamaranco.com> wrote in message
> news:O4E87QadEHA.1648@TK2MSFTNGP11.phx.gbl...

> > Would it be possible for me to simply paste this access query into a SQL
> > Server stored procedure:
> >
> > SELECT asplGroupTbl.groupname, asplMemberTbl.userid
> > FROM asplGroupTbl INNER JOIN asplMemberTbl ON asplGroupTbl.groupid =
> > asplMemberTbl.groupid
> > WHERE (((asplMemberTbl.userid)=5));
> >
> > Is this okay?
> >
> > Thank you
> > Jason
> >
> >

>
>

[Aaron [SQL Server MVP]]

> DECLARE @RC int

> EXEC @RC = [V032U10DUW].[dbo].[Query1]
> DECLARE @PrnLine nvarchar(4000)
> PRINT 'Stored Procedure: V032U10DUW.dbo.Query1'
> SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
> PRINT @PrnLine

Where did all this come from? Did you try typing...

EXEC V032U10DUW.dbo.Query1

....and hitting F5?

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)

Ok, yes, it appears to execute and return the rows...thank you!
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:upPGC4adEHA.712@TK2MSFTNGP09.phx.gbl...

> > DECLARE @RC int
> > EXEC @RC = [V032U10DUW].[dbo].[Query1]
> > DECLARE @PrnLine nvarchar(4000)
> > PRINT 'Stored Procedure: V032U10DUW.dbo.Query1'
> > SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
> > PRINT @PrnLine

>
> Where did all this come from? Did you try typing...
>
> EXEC V032U10DUW.dbo.Query1
>
> ...and hitting F5?
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>