Viewing 15 posts - 46 through 60 (of 90 total)
Hi Sue,
If you have a jobs table that has a million records in it, a view that aggregates that table will have to load the million rows into...
June 28, 2018 at 2:36 am
@ J Livingston SQL
Thanks for your reply. It's ok, I have talked it over with the customer and I have been able to modify a report he already...
January 18, 2018 at 5:57 am
Thank you all very much for your time and replies.
I have asked the customer to mock up a report to show me exactly what they want and...
January 17, 2018 at 6:37 am
I have tried it with and without the quotes. Without the quotes it says invalid column name
January 11, 2018 at 7:42 am
Yes, orderdateandtime is a datetime field.
January 11, 2018 at 6:57 am
Yes,
This is how it looks now and I still get the same error.
SELECT
dbo.Sales.SALESDESCRIPTION,
dbo.Groups.GROUPDESCRIPTION,
...
January 11, 2018 at 5:54 am
Thank you Thomas.
In the actual query, it's in SSRS, I use variables for the dates so the < part of the query is the variable + 1...
January 11, 2018 at 5:39 am
Yes, I just noticed the OR, I have changed that to AND now but it still gives the same error
January 11, 2018 at 5:19 am
I think I may have answered this myself
Each text box that the address details are in, number them in order of the addresslines (textbox1, textbox2 etc...)
Put...
June 1, 2017 at 11:11 am
Thank you Thom for this explanation.
You have been a great help.
Paul.
April 18, 2017 at 8:26 am
Thank you all for your replies.
I know what is happening now
If I filter on datetime like so....
select orderdate,orderdatestring from QuartzReportnew where...
April 18, 2017 at 7:01 am
April 13, 2017 at 9:50 am
Yes, sorry...ORDERDATE not ORDERDATETIME.
Not sure how to post sample data....
These are the 2 queries I run in SQL on the views
April 13, 2017 at 9:47 am
Hi Thom,
the error I get is
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
----------------------------
Cannot read the...
April 13, 2017 at 9:30 am
Viewing 15 posts - 46 through 60 (of 90 total)