CODEWITHSUNDEEP
sqlsplitflamerobin
Matt Wilde
Matt Wilde

Reputation: 293

Filter certain SQL data formatted in one column into a new column

Before I begin I found this to be most relevant with the research I have done.

How to split the data from one column into separate columns using the contents of another column in SQL

Attached are pictures of my progress so far. How can I display this information such as it is shown in the excel file without disrupting the 

GROUP BY
filter in my Query?

It's a Fishbowl Database, newest version. I am running the queries through Flamerobin which you see in the picture. Trying to organize the query to display correctly so I can format it into 'iReports' and export it into an excel spreadsheet like the one shown. Maybe there is some part of this that would better be done in excel?

Notice the numbers for Qty are different, that's ok right now.

My reputation is too low to post pictures I am sorry. Here are the two JPGs in my Dropbox. I really appreciate the help.

https://www.dropbox.com/sh/r2rw5r2awsyvzs9/AAAXXg27CMPOYtZFqPX3Dx6la?dl=0

Upvotes: 0

Views: 185

Answers (0)

Related Questions