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 |
|
Girolamo
Starting Member
1 Post |
 Posted - 2014-07-04 : 03:31:05
|
| Hi, I'm new to the forum and this is my first topic.I'm having some diffult to get a query output with a table.Here is the table:Role Name Surname OperationAdministrative John Smith Order sentAdministrative Mark White Order redactedEmployee Jack Connor Order sentAdministrative John Smith Order sent.... ... .... ....I would need this kind of outputRole Name Surname OperationAdministrative John Smith Order Sent 2 Order redacted 1Employee Jack Connor Order SentSince the customer would have this data into an Excel file, I can't create a report but I have to use sql to get the result.How can I obtain thie result?Regards,G. |
|
|
adsingh82
Starting Member
20 Posts |
|
|
|
|
|
SQL query with needed blank records