Search criteria on hardcoded column in query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Search criteria on hardcoded column in query

Author

Topic

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2010-08-21 : 07:33:26

I have a column TestColumn which in real case i am getting via inner query.
Let's say
Select 'ABC' as TestColumn, SAC_IsLinked
From MDB_CONTENT_INFO
Where TestColumn = 'ABC'
is my query

Now I have to do some filter on that column result.How can I do that?

Kamran Shahid
Sr. Software Engineer
(MCSD.Net,MCPD.net)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-08-21 : 08:51:06

"Now I have to do some filter on that column result.How can I do that?"
what do you mean by that ? The Testcolumn is a hardcoded value. How do you want to filter that column ?

KH
[spoiler]Time is always against us[/spoiler]

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2010-08-21 : 13:32:48

I just have said let say it as example.
In real it will be a Value got via inner query
Like
It is not as simple

My query looks like

SELECT SHL_SA_UPDATE_DATETIME
,SHL_PK_SHIPPER_APPT_ID
,SHL_CONSIGNEE_APPT_ID
,SHL_APPOINTMENT_TYPE
,SHL_APPT_STATUS
,(SELECT SUBSTRING
(
(
SELECT ', ' + CONVERT(varchar(5), MailClassID) from HIST_ShellMailClass where ShipperApptId = HIST_APPT_SHELL_INFO.SHL_PK_SHIPPER_APPT_ID ORDER BY MailClassID FOR XML PATH('')
),2,200000
)
)AS MailClass
FROM HIST_APPT_SHELL_INFO

Where HIST_APPT_SHELL_INFO.SHL_PK_SHIPPER_APPT_ID=@AppointmentID

--And here i want to fileter on MailClass field

hope it will clear it a bit

Kamran Shahid
Sr. Software Engineer
(MCSD.Net,MCPD.net)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-21 : 14:14:31

[code]SELECT *
FROM
(
SELECT SHL_SA_UPDATE_DATETIME
,SHL_PK_SHIPPER_APPT_ID
,SHL_CONSIGNEE_APPT_ID
,SHL_APPOINTMENT_TYPE
,SHL_APPT_STATUS
,(SELECT SUBSTRING
(
(
SELECT ', ' + CONVERT(varchar(5), MailClassID) from HIST_ShellMailClass where ShipperApptId = HIST_APPT_SHELL_INFO.SHL_PK_SHIPPER_APPT_ID ORDER BY MailClassID FOR XML PATH('')
),2,200000
)
)AS MailClass
FROM HIST_APPT_SHELL_INFO

Where HIST_APPT_SHELL_INFO.SHL_PK_SHIPPER_APPT_ID=@AppointmentID
)t
WHERE MailClass = @YourValue
[/code]

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2010-08-22 : 04:46:54

Thanks

Kamran Shahid
Sr. Software Engineer
(MCSD.Net,MCPD.net)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-22 : 12:11:31

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources