troubleshooting Question

View sql written .net query result during debug.

Avatar of TanyaDH
TanyaDH asked on
.NET ProgrammingMicrosoft SQL Server 2005
13 Comments1 Solution190 ViewsLast Modified:
I need to see if the query within .net is bringing in any records.  How can I view the query result in .net?

Thanks in advance!
SELECT * FROM (SELECT  lt.[Transaction_Date], lt.[Equipment_Number], lt.[Lube_Type], lt.[Quantity]  FROM dbo.EquipmentMaster em INNER JOIN dbo.LubeTransactions lt ON em.Equipment_Number = lt.Equipment_Number WHERE lt.[Transaction_Date] Between '12/1/09' AND '12/31/09' AND  lt.[Lube_Type] Like  '%85%'  Or lt.[Lube_Type] Like  '%Grease%' And Report_Classification = '99' ) tbl PIVOT (SUM([Quantity]) FOR [Lube_Type] IN ([Grease], [W85])) pvt ORDER BY [Equipment_Number]
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros