Viewing 15 posts - 2,761 through 2,775 (of 5,109 total)
Duplicate of https://www.sqlservercentral.com/Forums/1903690/Set-up-job-to-convert-word-document-to-pdf, where discussion already taken place.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 24, 2017 at 3:00 am
You should know better than to post a question without DDL and DLM. 🙂
Without that, I'd suggest using CTEs to get your initial dataset, then resolve your results...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 5:40 pm
The other thing to note is John used GROUP BY in his query, to cater for partitions. You've used a DISTINCT and dropped the GROUP BY. If you have partitions,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 8:42 am
Instead of using a JOIN, try using a LEFT JOIN to your tblproductAttributes.
If you want a more in depth answer (with an example), have a look at the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 8:10 am
ramrajan - Monday, October 23, 2017 7:22 AMI have tried but no luck.
Go back to your original topic, and post what you've...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 7:49 am
You say you've tried in your latest post (in your duplicate topic). Moving the topic back to your original thread, what is it you've tried since further input...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 7:48 am
Edvard Korsbæk - Monday, October 23, 2017 5:30 AMI do not think it's possible, but i could really use it.Best regards
Edvard Korsbæk
Depends...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 5:47 am
Correct Andreas. As of SQL Server 2016, only 64bit is available.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 5:33 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 5:10 am
ramrajan - Monday, October 23, 2017 3:37 AMI am not getting. Please help
Have a look at the tables that John has said...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 23, 2017 at 3:50 am
Vegeta7 - Sunday, October 22, 2017 9:33 AMYou Sir are incredible! That's perfect! Many thanks 😀
Do you understand everything it's doing?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 22, 2017 at 9:39 am
Assuming that 01-02-2017 is 2nd January 2017, then full script with correct data types and date values:USE Sandbox;
GO
CREATE TABLE Discounts (
ProductCode VARCHAR...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 22, 2017 at 8:53 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 22, 2017 at 8:39 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 22, 2017 at 8:07 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 22, 2017 at 6:31 am
Viewing 15 posts - 2,761 through 2,775 (of 5,109 total)