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 |
SW9876
Starting Member
2 Posts |
Posted - 2014-07-31 : 13:49:41
|
Here is a link to my code and a sample image[url]http://prntscr.com/487sut[/url]I want to change the format so it showsAssestName|IP|Version (Endpoint Security)|Version (Network Agent)How would I do that? |
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-01 : 11:37:12
|
The query in your screenshot doesn't match the report below it. More columns projected by the query(6) than in the report(4). Also, you've not told us how you produce the report (e.g. SSRS?)It looks like you just want to change the column headings and that depends on the report writer, not the query. |
|
|
SW9876
Starting Member
2 Posts |
Posted - 2014-08-01 : 17:51:47
|
I actually have no idea what i'm doing. But I don't want to change the headings. Every asset is listed twice because there is a version # for endpoint security and a version # for network agent. I want to make it so there is a column for network agent versions and a column for endpoint security versions so each asset doesn't take 2 rows. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-02 : 14:09:38
|
OK, so please provide...1. Create table commands to create test tables for your query2. Insert commands to populate the table with test data3. The result of running your query against the test tables4. Then desired results. |
|
|
|
|
|