Here is my current situation:
Table called tblSoftware_Master
I have fields within this table labeled Sft_Path and Sft_FileName. Many of the records in this table will have the same value for Sft_Path but different fileNames. I would like to create a view or sp that Groups Together the Sft_Path and concatenates the File_Names in the same field.
An example of this would be something like this:
Path FileName
WinZip WinZip.EXE ~ Help.exe
Normally this would be two records in the table.
The main reason for doing this is to narrow down the amount of records so they can be marked as supported or deleted.
Any suggesstions would be greatly appreciated
Table called tblSoftware_Master
I have fields within this table labeled Sft_Path and Sft_FileName. Many of the records in this table will have the same value for Sft_Path but different fileNames. I would like to create a view or sp that Groups Together the Sft_Path and concatenates the File_Names in the same field.
An example of this would be something like this:
Path FileName
WinZip WinZip.EXE ~ Help.exe
Normally this would be two records in the table.
The main reason for doing this is to narrow down the amount of records so they can be marked as supported or deleted.
Any suggesstions would be greatly appreciated