Viewing 15 posts - 4,186 through 4,200 (of 5,109 total)
Can you please provide some sample data and your expected output? I don't understand your goals here. Please provide it in the format I gave you in your other post,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2017 at 4:06 am
You should really provide your sample data as shown in my signature. I've done this for you this time,.
Couple of solution, one using a subquery, the other using...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2017 at 3:33 am
Sorry, but I'm not sure i understand your goal here. Are you:
A. Looking for a customers that have only ordered on a specific day (no other odays), and only...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2017 at 3:04 am
Yes, ID-1411 is not a field from fact table, its a string, I trying to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2017 at 2:00 am
Without actual sample data, this is a little difficult, my answer is guess work.
My guess, however, is that you're starting in the wrong place. I assuming that your...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 26, 2017 at 3:44 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 3:42 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 3:07 pm
If it were only so simple for me, J, but those American style dates don't work so well on my British PC;)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 2:51 pm
Without actually getting some useable data from you (more than one example), this is guess work. I've therefore assumed that every date time has the format of 'MM-dd-yyyy, hh:mm AM/PM'....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 2:18 pm
I have to ask, but why are you storing your data like this? I don't think the problem is really the need to try and get data about datetimes from...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 11:25 am
We have the table DDL, which is great, but we don't have any sample data. Simply telling us that the result you get isn't accurate doesn't give us much information,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 5:13 am
This splits out the two parts, but not the letters and numbers:CREATE TABLE #Sample ([address] nvarchar(50), --Address has 2 Ds, not 1
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 5:04 am
You haven't unticked the the box that states your first line has column headings. In your first screen shot it's ticked.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 25, 2017 at 4:21 am
What defines the rest of your ordering? Do you need to retain the ordering in memberid of a100, then aCVB, then aCvbx, then a105, etc? Does the rest of the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2017 at 8:45 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 24, 2017 at 8:19 am
Viewing 15 posts - 4,186 through 4,200 (of 5,109 total)