Stored Procedure Query Report and Display Horizontally

janmic · November 18, 2016, 9:52am

Hi everyone,

I need help with my sql report generation.

please refer to the screenshot below.

Table 1 - This is my actual db table.

I want to create a report that will display the items horizontally (please refer to Table2 - Report / Screen Output).

Thanks,

gbritton · November 18, 2016, 2:18pm

What if there are two HDs or three monitors? What would it look like then? What if there are two computers?

janmic · November 19, 2016, 1:50am

Hi gbritton,

HARD DISK, MEMORY, MONITOR, CPU CASE and OTHER are my categories.

Whenever the user adds an item, they will need to select under what category the items belongs to.

so if there are multiple items, the report that i want will be like this

janmic · November 24, 2016, 11:28am

hello everyone,

any idea how to present the report horizontally?

thanks

gbritton · November 24, 2016, 7:50pm

If you just want one text line per PC, FOR XML PATH('') will do it
If you want multiple columns instead, you'll need dynamic SQL.

How would you like it?

janmic · November 25, 2016, 2:17am

hi,

I want it in multiple columns. how can I do it?

gbritton · November 25, 2016, 2:18am

to start please post

CREATE TABLE statement
INSERT INTO statement to populate sample data