Insert Query Help
From: Jeff York (anonymous_at_discussions.microsoft.com)
Date: 06/10/04
- Next message: John Bell: "Re: Long Select Statement"
- Previous message: Brian Henry: "Re: Stored procedure to drop and create table for end user"
- In reply to: Jeff York: "Insert Query Help"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Jun 2004 07:29:53 -0700
That helped guys. Thank you so much!
>-----Original Message-----
>Hi-
>
>I am having trouble with a query, perhaps you comeone
can
>help. I am trying to insert into a table some values
that
>are a result of a select statement. I am finding that
>this won't work. What is the best way to do this. I am
>attaching the failed query. THanks!!
>
>Insert into Xref_comp_sr
>
>(CM_ID,
>SR_ID,
>Date_Assigned,
>Role)
>
> VALUES
>(
>
>(SELECT CM_ID FROM XREF_COMP_SR JOIN SALES_REP
> ON XREF_COMP_SR.SR_ID = SALES_REP.SR_ID
> Where SR_LOC_ID IN(30)),
>
>'DMFAUS',getdate(),'BMR'
>)
>
>.
>
- Next message: John Bell: "Re: Long Select Statement"
- Previous message: Brian Henry: "Re: Stored procedure to drop and create table for end user"
- In reply to: Jeff York: "Insert Query Help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
