Viewing 15 posts - 4,261 through 4,275 (of 5,109 total)
This sounds like you're opening SSMS (SQL Server management studio), which depending on the version you've installed could well be a standalone application.
Do you have an application called...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2017 at 10:15 am
You should really post SQL that doesn't rely on User languages. i can't run the above as I'm British (there aren't 31 months in the year). Ideally supply dates in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2017 at 10:05 am
Phil Parkin - Thursday, February 9, 2017 9:11 AMHere you go (link).
I think this battle is lost, Phil. But I shall...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2017 at 9:25 am
Duplicate of topic https://www.sqlservercentral.com/Forums/1857023/Every-day-count-of-Inventory?Update=1#bm1857267. Please direct further answers there.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2017 at 4:36 am
Just noticed you duplicated this topic here: https://www.sqlservercentral.com/Forums/1857105/RE-Count-Difference-for-Every-15-Min#bm1857132 I've answered your questions there, I believe. Please direct your answer to this topic though, don't create two topics for one...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2017 at 4:35 am
SELECT ID
FROM #Sample S
WHERE S.StartDate = (SELECT MIN(sq.StartDate) FROM #Sample sq);
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2017 at 2:25 am
The DDL and DLM you've provided is for Oracle, not SQL, so we can't use it.
But why do wyou WANT to do do it in string? It would...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2017 at 2:00 am
Ken at work - Wednesday, February 8, 2017 12:30 PMFor me, I am not using the Split Function.
Why..? Have you completed the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 4:47 pm
Still no DDL, so I've had to guess your field names, and untested as no DLM, but maybe:WITH CTE AS(
SELECT l.Locaton AS CountryIndicator,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 10:05 am
Really need to see the error behind it (you have remote error disabled so I have no idea what the error is). Unfortunately without a true error I'm going to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 8:41 am
Sorry. I normally avoid using the Split function when embedding SQL directly into...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 8:10 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 7:35 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 7:19 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 7:08 am
You'd need to convert it again on the outside. Like below, but why not handle this in your presentation layer? For example, on Excel a format of 0.00 would only...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2017 at 3:23 am
Viewing 15 posts - 4,261 through 4,275 (of 5,109 total)