asked on
SQL Query assistance linking between columns
Hello, I am having trouble with a query. Attached is sample data file that I am referencing.
1. I would like to query the number of records based on a Plugin ID
2. I need the output from above to truncate field using following syntax - substring([Plugin Output], 64, 150) AS Output_Truncate
3. I would like to resolve the hostname (masked in sample file); with information in the Plugin Output column
The desired query output includes:
Resolved Hostname | Host | Output_Truncate
28589134SAMPLE-DATA3.csv
1. I would like to query the number of records based on a Plugin ID
2. I need the output from above to truncate field using following syntax - substring([Plugin Output], 64, 150) AS Output_Truncate
3. I would like to resolve the hostname (masked in sample file); with information in the Plugin Output column
The desired query output includes:
Resolved Hostname | Host | Output_Truncate
28589134SAMPLE-DATA3.csv
Microsoft SQL Server 2008
Last Comment
blackcatkempo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you this helps me!