Link to home
Start Free TrialLog in
Avatar of Classic1
Classic1Flag for Canada

asked on

Output Different in Excel Compared In SSMS

Hi there,
Was wondering if anyone can help me out here...
I 'inherited' a spreadsheet to fix...apparently in Excel, a row 'appears' to be missing some data.User generated image
If you look at the highlighted area, on row 5, it should say AT2057864, 5/24/2017 8:00,...the rest of the columns are correct, but it states BA080, 10/11/2016 8:00...those 2 entries should move down a row...

When I use the same SQL statement in SSMS, everything looks perfect...User generated imageRow 485 and 486 are correct...

For the life of me, I don't know why Excel is not showing the right values...I must be missing something...

Please let me know if you need additional info/details...

Much appreciated,
Classic
ASKER CERTIFIED SOLUTION
Avatar of Mike in IT
Mike in IT
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Norie
Norie
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Classic1
Classic1
Flag of Canada image

ASKER

Hi all,
Thanks for the quick response! Here's the info you requested...

The SQL syntax is this:
SELECT Volumetric_Audit.DeviceName, Volumetric_Audit.RecordTimestamp, Volumetric_Audit.Reg_000, Volumetric_Audit.Reg_001, Volumetric_Audit.Reg_002, Volumetric_Audit.Reg_003, Volumetric_Audit.Reg_004, Volumetric_Audit.Reg_005, Volumetric_Audit.Reg_006, Volumetric_Audit.Reg_007, Volumetric_Audit.Reg_008, Volumetric_Audit.Reg_009, Volumetric_Audit.SiteId, Volumetric_Audit.LogTrigger, Volumetric_Audit.MeterName 
FROM [VOL and PRESS HISTORY].dbo.Volumetric_Audit Volumetric_Audit
WHERE (Volumetric_Audit.MeterName='2057864-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2035547-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065195-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2060163-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065275-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065277-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2004926-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2063290-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2011142-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2047737-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065283-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065282-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2009734-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2007047-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2050812-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2056018-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2013125-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2017309-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065286-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2017549-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2018251-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2030314-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2039868-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2021275-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2070629-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2079142-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2075861-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2060910-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2029295-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2056408-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2004437-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2006390-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2010602-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2037344-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2046807-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2060161-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065281-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2065905-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2076160-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2077342-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='2042841-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='BA080-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='DR017-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='HL004-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%') OR (Volumetric_Audit.MeterName='HL009-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%')
ORDER BY Volumetric_Audit.DeviceName, Volumetric_Audit.RecordTimestamp

Open in new window


Took me a while to find where the connection was, but I've attached a screenshot:
User generated image
There is a filter via RecordTimestamp, but even if I do remove the filter, the issue still occurs (see highlighted row 486/487)

Regards,
Classic
Avatar of Classic1
Classic1
Flag of Canada image

ASKER

Hi all,
Sometimes, you just need to create a new worksheet and go from there...lol...there must've been something hidden, or formatting that I couldn't find.

Once I did that, everything looked good..User generated image
Thanks for everyone's quick response, I'll distribute the points evenly....

Much appreciated,
Classic
Avatar of Classic1
Classic1
Flag of Canada image

ASKER

Quick responses from both parties...found out the best way was to start from scratch...
Avatar of Mike in IT
Mike in IT
Flag of United States of America image
One thing I see right off is in the SQL you have a bunch of and and or clauses, but there is nothing to show when one or the other should be used. Right now it is not working as you expect. It is checking the MeterName and Date and (time or MeterName) and date . . .

I'm pretty sure that you that you want to have each MeterName with its date and time together. You should have it like this:
SELECT Volumetric_Audit.DeviceName, Volumetric_Audit.RecordTimestamp, Volumetric_Audit.Reg_000, Volumetric_Audit.Reg_001, Volumetric_Audit.Reg_002, Volumetric_Audit.Reg_003, Volumetric_Audit.Reg_004, Volumetric_Audit.Reg_005, Volumetric_Audit.Reg_006, Volumetric_Audit.Reg_007, Volumetric_Audit.Reg_008, Volumetric_Audit.Reg_009, Volumetric_Audit.SiteId, Volumetric_Audit.LogTrigger, Volumetric_Audit.MeterName 
FROM [VOL and PRESS HISTORY].dbo.Volumetric_Audit Volumetric_Audit
WHERE ((Volumetric_Audit.MeterName='2057864-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2035547-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065195-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2060163-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065275-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065277-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2004926-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2063290-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2011142-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2047737-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065283-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065282-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2009734-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2007047-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2050812-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2056018-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2013125-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2017309-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065286-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2017549-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2018251-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2030314-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2039868-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2021275-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2070629-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2079142-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2075861-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2060910-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2029295-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2056408-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2004437-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2006390-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2010602-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2037344-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2046807-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2060161-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065281-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2065905-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2076160-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2077342-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='2042841-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='BA080-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='DR017-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='HL004-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
	OR ((Volumetric_Audit.MeterName='HL009-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
ORDER BY Volumetric_Audit.DeviceName, Volumetric_Audit.RecordTimestamp

Open in new window

Avatar of Classic1
Classic1
Flag of Canada image

ASKER

Thanks Mike in IT...after doing some data mining, I found there were duplicate records in the table, so I added the DISTINCT keyword also...

Going a step further, I simplified it as: 
SELECT DISTINCT Volumetric_Audit.DeviceName, Volumetric_Audit.RecordTimestamp, Volumetric_Audit.Reg_000, Volumetric_Audit.Reg_001, Volumetric_Audit.Reg_002, Volumetric_Audit.Reg_003, Volumetric_Audit.Reg_004, Volumetric_Audit.Reg_005, Volumetric_Audit.Reg_006, Volumetric_Audit.Reg_007, Volumetric_Audit.Reg_008, Volumetric_Audit.Reg_009, Volumetric_Audit.SiteId, Volumetric_Audit.LogTrigger, Volumetric_Audit.MeterName 
FROM [VOL and PRESS HISTORY].dbo.Volumetric_Audit Volumetric_Audit
WHERE (Volumetric_Audit.MeterName IN ('2057864-PC1','2035547-PC1','2065195-PC1','2060163-PC1','2065275-PC1','2065277-PC1','2004926-PC1','2063290-PC1','2011142-PC1','2047737-PC1','2065283-PC1','2065282-PC1','2009734-PC1','2007047-PC1','2050812-PC1','2056018-PC1','2013125-PC1','2017309-PC1','2065286-PC1','2017549-PC1','2018251-PC1','2030314-PC1','2039868-PC1','2021275-PC1','2070629-PC1','2079142-PC1','2075861-PC1','2060910-PC1','2029295-PC1','2056408-PC1','2004437-PC1','2006390-PC1','2010602-PC1','2037344-PC1','2046807-PC1','2060161-PC1','2065281-PC1','2065905-PC1','2076160-PC1','2077342-PC1','2042841-PC1','BA080-PC1','DR017-PC1','HL004-PC1','HL009-PC1') AND (Volumetric_Audit.RecordTimestamp>='2016-09-01') AND (Convert(varchar(10),RecordTimestamp,8) Like '%08:00:00%'))
ORDER BY Volumetric_Audit.DeviceName, Volumetric_Audit.RecordTimestamp

Open in new window


At least it got the users going...ugh, inheriting stuff you didn't make is the absolute worst...lol...oh well...

Much appreciated,
Classic
Avatar of Mike in IT
Mike in IT
Flag of United States of America image
Inheritance isn't all it's cracked up to be!