add a field to a SQL Query during run time

I have this query:

SELECT RIGHT('0000000000' + CAST(CHEKNMBR AS VARCHAR(7)), 10) AS
Check_Serial_Number, RIGHT('0000000000' + CAST(CAST(NTWPYRN * 100 AS INT)
AS VARCHAR(10)), 10) AS Amount,
REPLACE(CONVERT(VARCHAR(10), CHEKDATE, 101), '/', '') AS Issue_Date, VOIDED
AS Void_Indicator
FROM dbo.UPR30100
WHERE (CHEKDATE = '08/21/2008')

I want to be able to add a field called "Record Type Code" and then populate
it with "5" when i execute this query. This query is actually creating a
view.

Thanks for your help.

SELECT [Record Type Code] = 5,
FROM table
WHERE ...

I'd also be very careful about using unsafe date formats like M/D/Y. Much
safer to use YYYYMMDD.


On 8/27/08 6:47 PM, in article eeRL9bJCJHA.4780-at-TK2MSFTNGP06.phx.gbl,
"fiaola" wrote:

> I have this query:
>
> SELECT RIGHT('0000000000' + CAST(CHEKNMBR AS VARCHAR(7)), 10) AS
> Check_Serial_Number, RIGHT('0000000000' + CAST(CAST(NTWPYRN * 100 AS INT)
> AS VARCHAR(10)), 10) AS Amount,
> REPLACE(CONVERT(VARCHAR(10), CHEKDATE, 101), '/', '') AS Issue_Date, VOIDED
> AS Void_Indicator
> FROM dbo.UPR30100
> WHERE (CHEKDATE = '08/21/2008')
>
> I want to be able to add a field called "Record Type Code" and then populate
> it with "5" when i execute this query. This query is actually creating a
> view.
>
> Thanks for your help.
>
>

Try:

SELECT RIGHT('0000000000' + CAST(CHEKNMBR AS VARCHAR(7)), 10) AS
Check_Serial_Number, RIGHT('0000000000' + CAST(CAST(NTWPYRN * 100 AS INT)
AS VARCHAR(10)), 10) AS Amount,
REPLACE(CONVERT(VARCHAR(10), CHEKDATE, 101), '/', '') AS Issue_Date, VOIDED
, 5 as [Record Type Code]
AS Void_Indicator
FROM dbo.UPR30100
WHERE (CHEKDATE = '08/21/2008')



--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"fiaola" wrote in message
news:eeRL9bJCJHA.4780-at-TK2MSFTNGP06.phx.gbl...
I have this query:

SELECT RIGHT('0000000000' + CAST(CHEKNMBR AS VARCHAR(7)), 10) AS
Check_Serial_Number, RIGHT('0000000000' + CAST(CAST(NTWPYRN * 100 AS INT)
AS VARCHAR(10)), 10) AS Amount,
REPLACE(CONVERT(VARCHAR(10), CHEKDATE, 101), '/', '') AS Issue_Date, VOIDED
AS Void_Indicator
FROM dbo.UPR30100
WHERE (CHEKDATE = '08/21/2008')

I want to be able to add a field called "Record Type Code" and then populate
it with "5" when i execute this query. This query is actually creating a
view.

Thanks for your help.

Thanks for the suggestion and help.

"Tom Moreau" wrote in message
news:eP$e%23jJCJHA.1180-at-TK2MSFTNGP04.phx.gbl...
> Try:
>
> SELECT RIGHT('0000000000' + CAST(CHEKNMBR AS VARCHAR(7)), 10) AS
> Check_Serial_Number, RIGHT('0000000000' + CAST(CAST(NTWPYRN * 100 AS INT)
> AS VARCHAR(10)), 10) AS Amount,
> REPLACE(CONVERT(VARCHAR(10), CHEKDATE, 101), '/', '') AS Issue_Date,
> VOIDED
> , 5 as [Record Type Code]
> AS Void_Indicator
> FROM dbo.UPR30100
> WHERE (CHEKDATE = '08/21/2008')
>
>
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "fiaola" wrote in message
> news:eeRL9bJCJHA.4780-at-TK2MSFTNGP06.phx.gbl...
> I have this query:
>
> SELECT RIGHT('0000000000' + CAST(CHEKNMBR AS VARCHAR(7)), 10) AS
> Check_Serial_Number, RIGHT('0000000000' + CAST(CAST(NTWPYRN * 100 AS INT)
> AS VARCHAR(10)), 10) AS Amount,
> REPLACE(CONVERT(VARCHAR(10), CHEKDATE, 101), '/', '') AS Issue_Date,
> VOIDED
> AS Void_Indicator
> FROM dbo.UPR30100
> WHERE (CHEKDATE = '08/21/2008')
>
> I want to be able to add a field called "Record Type Code" and then
> populate
> it with "5" when i execute this query. This query is actually creating a
> view.
>
> Thanks for your help.
>
>