Skip to content

Instantly share code, notes, and snippets.

@Dan1el42

Dan1el42/powershell-forum-filtering-and-formatting-reply-02.ps1

Last active August 10, 2016 08:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Dan1el42/62cf596638244f11c1497e8ce1d8db8d to your computer and use it in GitHub Desktop.
Save Dan1el42/62cf596638244f11c1497e8ce1d8db8d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
powershell-forum-filtering-and-formatting-reply-02.ps1
$Params = @{
Query = "SELECT [CERTIFIED & UNASSESSED SKILL] FROM master where [CERTIFIED & UNASSESSED SKILL] LIKE '%Citrix%'"
ServerInstance = 'dc2012\sqlexpress'
Database = 'final'
}
Invoke-Sqlcmd @Params | ForEach-Object { $_['CERTIFIED & UNASSESSED SKILL'] -split ',' } | Where-Object { $_ -like '*Citrix*' }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment