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
 Dynamic Query

Author  Topic 

Swatig
Starting Member

7 Posts

Posted - 2008-06-20 : 17:31:25
Hi
I am new to sql. I have to run a query in a manner that I can see customer name and their photo dynamically? I already have table created where names and customers images are there.Please help.

Thanks
Swati

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-20 : 17:36:41
Where do you want to see the photo?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Swatig
Starting Member

7 Posts

Posted - 2008-06-20 : 17:46:34
In my query result. Report.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-20 : 18:07:31
quote:
Originally posted by Swatig

In my query result. Report.


If you want to show them in Reports, better post at Reporting Services Forum.

Which reporting tool are you using?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Swatig
Starting Member

7 Posts

Posted - 2008-06-25 : 16:29:27
Sorry peso/Mahadevan
By report I mean in my query browser only. First I am checking my query reult and then it will be applied for software where people are going to search their information with photo.

Thanks




quote:
Originally posted by Swatig

Hi
I am new to sql. I have to run a query in a manner that I can see customer name and their photo dynamically? I already have table created where names and customers images are there.Please help.

Thanks
Swati



Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-25 : 16:34:24
quote:
Originally posted by Swatig

Sorry peso/Mahadevan
By report I mean in my query browser only. First I am checking my query reult and then it will be applied for software where people are going to search their information with photo.

Thanks




quote:
Originally posted by Swatig



Hi
I am new to sql. I have to run a query in a manner that I can see customer name and their photo dynamically? I already have table created where names and customers images are there.Please help.

Thanks
Swati







1 Note that my name is Madhivanan and not Mahadevan
2 Query Analyser wont display photoes
3 How are you storing the photoes in a table?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-25 : 22:31:28
quote:
Originally posted by madhivanan

quote:
Originally posted by Swatig

Sorry peso/Mahadevan
By report I mean in my query browser only. First I am checking my query reult and then it will be applied for software where people are going to search their information with photo.

Thanks




quote:
Originally posted by Swatig



Hi
I am new to sql. I have to run a query in a manner that I can see customer name and their photo dynamically? I already have table created where names and customers images are there.Please help.

Thanks
Swati







1 Note that my name is Madhivanan and not Mahadevan
2 Query Analyser wont display photoes
3 How are you storing the photoes in a table?

Madhivanan

Failing to plan is Planning to fail




Go to Top of Page
   

- Advertisement -