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.
| Author |
Topic |
|
shemayb
Posting Yak Master
159 Posts |
 Posted - 2008-10-27 : 04:14:57
|
| Hi..I have two tables in my stored procedure. I have Employee1 and Employee2 tables. I wanted to compare the data of the two tables for example:Case When Employee1.Name <> Employee2.Name Then Employee2.Name Else Employee2.Name End as Name.In my Then i wanted to put an emphasis to it. Like making it BOLD or putting color on it or anything that could emphasize it when i display it on my report.How can i possibly do it?Thank you so much.Funnyfrog |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 04:17:38
|
| Whatever you're asking for is a formatting issue. It should be handled at your front end application. SQL Server is not meant for formatting stffs like this. |
 |
|
|
shemayb
Posting Yak Master
159 Posts |
Posted - 2008-10-27 : 04:21:35
|
| ok..Thank you..Funnyfrog |
|
|
|
shemayb
Posting Yak Master
159 Posts |
Posted - 2008-10-27 : 04:22:39
|
| Can you suggest any other way?Funnyfrog |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 04:27:26
|
quote:
Originally posted by shemayb
Can you suggest any other way?Funnyfrog
whats the front end application you use? |
|
|
|
shemayb
Posting Yak Master
159 Posts |
Posted - 2008-10-27 : 04:30:28
|
| it's vb.net..I tried coding it in my front end but the tables are complicated so i tried to work it on my back end.Funnyfrog |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 04:36:48
|
quote:
Originally posted by shemayb
it's vb.net..I tried coding it in my front end but the tables are complicated so i tried to work it on my back end.Funnyfrog
nope. just do it in your webpage part. use html tag <b></b> to get text in bold. |
|
|
|
shemayb
Posting Yak Master
159 Posts |
Posted - 2008-10-27 : 04:41:58
|
| ok.i will try to find a way in my front end.Thank you so much!:)Funnyfrog |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 05:11:44
|
quote:
Originally posted by shemayb
ok.i will try to find a way in my front end.Thank you so much!:)Funnyfrog
Cheers  |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-27 : 05:18:15
|
quote:
Originally posted by shemayb
Case When Employee1.Name <> Employee2.Name Then Employee2.Name Else Employee2.Name End as Name.
What is the use of CASE here?EmployeeName2 is always returned no matter what.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Labels on stored procedure