• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

parameter on append

I would like the query to ask for the year month. in my query at present it is wriiten in to the sql how do i add as a parameter?

INSERT INTO AbiBuilds ( abiCode, BuildYearMonth )
SELECT tClient.abiCode, "2012-09" AS Expr1
FROM tClient;

Open in new window

0
PeterBaileyUk
Asked:
PeterBaileyUk
1 Solution
 
Bhavesh ShahLead AnalysistCommented:
hi

if its mssql

Declare @BulidYearMonth Varchar(10)
SET @BulidYearMonth = '2012-09'

INSERT INTO AbiBuilds ( abiCode, BuildYearMonth )
SELECT tClient.abiCode,  @BulidYearMonth
FROM tClient;
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now