Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Bright
Starting Member
4 Posts |
Posted - 2014-04-09 : 09:22:09
|
I tried google, but cant't get information on how to solve my specific problem....ERROR......Msg 137, Level 15, State 2, Line 15Must declare the scalar variable "@PathID".Below is my SQL querySELECT C.CourseID AS Course,COUNT(D.EventTypeID)AS Eventstotal FROM dbo.ADFPath PLEFT OUTER JOIN dbo.ADFCourse CON P.PathID = C.PathIDLEFT OUTER JOIN dbo.ADFSection SON C.CourseID = S.CourseIDLEFT OUTER JOIN dbo.ADF_Event EON S.SectionID = E.SectionIDLEFT OUTER JOIN dbo.ADF_Document DON E.DocumentID = D.DocumentIDLEFT OUTER JOIN dbo.ADF_EventType TON D.EventTypeID = T.EventTypeIDWHERE (P.PathID =@PathID)AND(C.CourseID = @CourseID)AND(S.SectionID=@SectionID) AND(D.EventTypeID=@EventTypeIDGROUP BY C.CourseIDORDER BY COUNT(D.EventTypeID) DESC |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-04-09 : 09:30:00
|
http://technet.microsoft.com/en-us/library/ms188927.aspx Too old to Rock'n'Roll too young to die. |
|
|
|
|
|