I am attempting to run a raw SQL query from a remote server. At this point I am unaware of what SQL Server version this is running on, but believe it to be 2008. I am attempting to connect using Laravel 5.5. I just want a positive connection at this point. Can anyone direct me as to what the issue may be?
I have also tried putting DB::raw after 'select' in the string. Here is my query string:
public function index()
{
$query = DB::connection('sqlsrv')->select('
SELECT "tProject"."ProjectName", "tProject"."CreatedDate", "tProject"."ProjectNumber", "tProjectEstByItem"."Qty", "tService"."ServiceCode", "tService"."Description", "tProjectItemRollup"."HoursApproved", "tProjectItemRollup"."Hours", "tProjectEstByItem"."Gross", "tProjectStatus"."ProjectStatus", "vw_flat_Project_Properties"."ClientPO", "tProjectEstByItem"."COGross", "tProjectEstByItem"."COQty", "tProject"."EstExpenses", "tProject"."EstLabor", "tProject"."ApprovedCOExpense"
FROM (((("Workamajig"."dbo"."tProject" "tProject"
INNER JOIN "Workamajig"."dbo"."tProjectItemRollup" "tProjectItemRollup"
ON "tProject"."ProjectKey"="tProjectItemRollup"."ProjectKey")
INNER JOIN "Workamajig"."dbo"."tProjectStatus" "tProjectStatus"
ON "tProject"."ProjectStatusKey"="tProjectStatus"."ProjectStatusKey")
INNER JOIN "Workamajig"."dbo"."vw_flat_Project_Properties" "vw_flat_Project_Properties"
ON "tProject"."ProjectNumber"="vw_flat_Project_Properties"."ProjectNumber")
LEFT OUTER JOIN "Workamajig"."dbo"."tProjectEstByItem" "tProjectEstByItem"
ON ("tProjectItemRollup"."ProjectKey"="tProjectEstByItem"."ProjectKey")
AND ("tProjectItemRollup"."EntityKey"="tProjectEstByItem"."EntityKey"))
INNER JOIN "Workamajig"."dbo"."tService" "tService"
ON "tProjectItemRollup"."EntityKey"="tService"."ServiceKey"
WHERE "tProject"."CreatedDate">={ts "2017-06-26 00:00:00"}
AND "tProject"."ProjectNumber"
LIKE "bigl%"
ORDER BY "tProject"."ProjectNumber", "tService"."Description" ');
dd($query);
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire