Skip to content

Instantly share code, notes, and snippets.

@Gutek

Gutek/SQL_EF_query_Page_1

Last active March 8, 2016 13:44
Show Gist options
  • Save Gutek/3093a2fcda29999ee0c0 to your computer and use it in GitHub Desktop.
Save Gutek/3093a2fcda29999ee0c0 to your computer and use it in GitHub Desktop.
Download ZIP
These two queries (generated by EF) returns same set of data (exactly). However if you change sorting from `AssessmentTypeName` to `ParameterName` paging works as expected. any ideas why?
Raw
sample_data.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 3 columns, instead of 1 in line 1.
FE0440E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
FF0440E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
000540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
010540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
020540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
030540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
040540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
050540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
060540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
070540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
080540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
090540E9-5EB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
B795D48A-5FB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
B895D48A-5FB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
B995D48A-5FB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
BA95D48A-5FB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
BB95D48A-5FB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
BC95D48A-5FB5-E511-987F-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
BFE8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
C1E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
C3E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
C5E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
C7E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
C9E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
CBE8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
CEE8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
D0E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
D3E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
D5E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
D8E8C935-9945-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
D30057A9-9A45-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
D50057A9-9A45-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
D70057A9-9A45-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
D90057A9-9A45-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
DB0057A9-9A45-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
DD0057A9-9A45-E411-A411-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
22D91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
25D91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
27D91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
2AD91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
2CD91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
2FD91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
32D91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
35D91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
37D91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
3AD91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
3DD91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
40D91521-B02B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
E54F4649-B32B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
E74F4649-B32B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
E94F4649-B32B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
EB4F4649-B32B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
ED4F4649-B32B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
F04F4649-B32B-E511-A5DB-0050568A69E2;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
379C3C76-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
389C3C76-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
399C3C76-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
3A9C3C76-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
3B9C3C76-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
3C9C3C76-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
7741377C-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
7841377C-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
7941377C-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
7A41377C-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
7B41377C-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;BOD, 5 days with Inhibition (Carbonaceous BOD) - milligrams per litre - Waste Water;332;BOD, 5 days with Inhibition (Carbonaceous BOD)
7C41377C-D8C9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;Suspended Solids - milligrams per litre - Waste Water;209;Suspended Solids
A889CF3F-DDC9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
A989CF3F-DDC9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
AA89CF3F-DDC9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
AB89CF3F-DDC9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
AC89CF3F-DDC9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
AD89CF3F-DDC9-E511-9B41-0050569F456D;101;ELV Exceedance - Directive;A7A8B9B3-629B-E111-9C56-0050568A69E2;TPEFF0500D0517SW001;COD-Cr - milligrams per litre - Waste Water;91;COD-Cr
Raw
SQL_EF_query_Page_1
SELECT
[Project1].[AutomatedComplianceAssessmentId] AS [AutomatedComplianceAssessmentId],
[Project1].[AssessmentTypeCode] AS [AssessmentTypeCode],
[Project1].[AssessmentTypeName] AS [AssessmentTypeName],
[Project1].[EmissionPointId] AS [EmissionPointId],
[Project1].[EmissionPointCode] AS [EmissionPointCode],
[Project1].[ParameterMatrixName] AS [ParameterMatrixName],
[Project1].[ParameterId] AS [ParameterId],
[Project1].[ParameterName] AS [ParameterName]
FROM ( SELECT
[Extent1].[AutomatedComplianceAssessmentId] AS [AutomatedComplianceAssessmentId],
[Extent1].[AssessmentTypeCode] AS [AssessmentTypeCode],
[Extent1].[AssessmentTypeName] AS [AssessmentTypeName],
[Extent1].[EmissionPointId] AS [EmissionPointId],
[Extent1].[EmissionPointCode] AS [EmissionPointCode],
[Extent1].[ParameterMatrixName] AS [ParameterMatrixName],
[Extent1].[ParameterId] AS [ParameterId],
[Extent1].[ParameterName] AS [ParameterName]
FROM [dbo].[AutomatedComplianceAssessment] AS [Extent1]
WHERE [Extent1].[EmissionPointCode] = 'TPEFF0500D0517SW001'
) AS [Project1]
ORDER BY [Project1].[AssessmentTypeName] ASC
OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
Raw
SQL_EF_query_Page_2
SELECT
[Project1].[AutomatedComplianceAssessmentId] AS [AutomatedComplianceAssessmentId],
[Project1].[AssessmentTypeCode] AS [AssessmentTypeCode],
[Project1].[AssessmentTypeName] AS [AssessmentTypeName],
[Project1].[EmissionPointId] AS [EmissionPointId],
[Project1].[EmissionPointCode] AS [EmissionPointCode],
[Project1].[ParameterMatrixName] AS [ParameterMatrixName],
[Project1].[ParameterId] AS [ParameterId],
[Project1].[ParameterName] AS [ParameterName]
FROM ( SELECT
[Extent1].[AutomatedComplianceAssessmentId] AS [AutomatedComplianceAssessmentId],
[Extent1].[AssessmentTypeCode] AS [AssessmentTypeCode],
[Extent1].[AssessmentTypeName] AS [AssessmentTypeName],
[Extent1].[EmissionPointId] AS [EmissionPointId],
[Extent1].[EmissionPointCode] AS [EmissionPointCode],
[Extent1].[ParameterMatrixName] AS [ParameterMatrixName],
[Extent1].[ParameterId] AS [ParameterId],
[Extent1].[ParameterName] AS [ParameterName]
FROM [dbo].[AutomatedComplianceAssessment] AS [Extent1]
WHERE [Extent1].[EmissionPointCode] = 'TPEFF0500D0517SW001'
) AS [Project1]
ORDER BY [Project1].[AssessmentTypeName] ASC
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment