Trying to insert data into SQL Server table. I used very similar code previously with no issue. For some reason this is all inserting in the first column rather that each column. My code:

$params = @{‘server’=’RCIBI,1433′;’Database’=’DWStage’}

Function ReportAccess
{
param($userlogin,$runas,$permissiontype, $reportname, $emailaddress, $previewuser, $emailtype)

Prepare query for Insert

#$rows = $userlogin , $runas , $permissiontype,$reportname,$emailaddress,$previewuser,$emailtype
#write-output($rows)
$InsertResults = @”
INSERT INTO [DWStage].[dbo].[ReportUserPermissions](userlogin,runaslogin,permissiontype, reportname, emailaddress, previewuser, emailtype)
VALUES (‘$userlogin’,’$runas’, ‘$permissiontype’,’$reportname’,’$emailaddress’, ‘$previewuser’, ‘$emailtype’)
“@
#Insert Data
Invoke-sqlcmd @params -Query $InsertResults
#$InsertResults
}

Run it:
ReportAccess ‘usktyson’,’admin’,’canada’, ‘SalesPipeline’, ‘[email protected]’, 0, ‘sales’

Thanks in advance.