Filter account - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Filter account

Author

Topic

rango316
Starting Member

20 Posts

Posted - 2008-03-03 : 06:12:24

Hi,

I have a simple report which i only want to output one account specific name, the report is:

SELECT fullname, new_directextensions, new_mobileextension, jobtitle, accountidname
FROM FilteredContact
ORDER BY fullname

how do i filter this report to show only one account?

Thanks in advance

Ian

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-03 : 06:17:55

quote:
Originally posted by rango316

Hi,

I have a simple report which i only want to output one account specific name, the report is:

SELECT fullname, new_directextensions, new_mobileextension, jobtitle, accountidname
FROM FilteredContact
Where accountidname = 'some name'
ORDER BY fullname

how do i filter this report to show only one account?

Thanks in advance

Ian

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

rango316
Starting Member

20 Posts

Posted - 2008-03-03 : 06:20:30

HAha

It worked i was using "speech" marks not 'apostrophies'

Thanks Mate

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources