Forum Replies Created
Viewing 15 posts - 16 through 30 (of 386 total)
-
Reply To: Using 'row_number() over (partition by' to get a count
It's still returning no records. If I eliminate the COUNT I get 3,000 + but about 700 have multiple '276' counts that need to not be returned.
-
Reply To: Selecting distinct values from dupes based on latest date
Sorry, I was wrong with what my needed output should be, I needed this, in other words keeping those with just one date:
123548, '2022-02-21'
985254, '2022-03-19'
774589, '2022-01-17'
754512, '2022-04-04'
-
Reply To: Selecting distinct values from dupes based on latest date
One question, what if I have some dates as NULL values and want them to return?
-
Reply To: Selecting distinct values from dupes based on latest date
That works perfectly, many thanks!
-
Reply To: Problem with Latitude and Longitude Distance calc
The [ProvidersDirectory].[dbo].[ProvidersTable] does not have a 'Distance' field. This is a calculated field to be only placed in the temp table. The [ProvidersDirectory].[dbo].[ProvidersTable] only has the longitude and latitude. In...
-
Reply To: Problem with Latitude and Longitude Distance calc
If I assign a value to @source in my declaration how do I 'reset' it in my insert to the temp table? The exercise is to assign a geographical location...
-
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format
What format would you prefer the data?
-
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format
The ConvoHrs table is coming from a vendor we have no control over.
-
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format
-- here are the basic DDLs for my two tables:
CREATE TABLE [portman].[dbo].[AgentHours](
[LoginEntryID] [int] IDENTITY(1,1) NOT NULL,
[DOMAIN] [varchar](4) NOT NULL,
[DATE] [date] NOT NULL,
[LOGIN TIMESTAMP] [datetime2](0) NULL,
[LOGOUT TIMESTAMP] [datetime2](0)... -
Reply To: adding hh:mm:ss time to yyyy-mm-dd hh:mm:ss format
I think we may be on the right track but my data isn't presenting correctly. I'm getting (although the seconds are not visible, they are incorrect):
-
Reply To: Problem understanding SUM function with GROUP BY
Sorry... I see now and tried MAX and that took care of it... thanks!!
-
Reply To: Problem understanding SUM function with GROUP BY
This does not seem to work, the data returns like before:
SELECT [user_name], [created_at],
SUM(dbo.fnGetDecimalTime([event_sec])) as 'Decimal_Time_SUM'
FROM [Charter].[dbo].[ConvoHrs]
group by [user_name],[created_at]
order by [user_name] -
Reply To: Problem understanding SUM function with GROUP BY
Thanks! One thing what if I need to add a field like [Date] (which I may want to do grouping on later)? It wants this added to the 'group by'...
-
Reply To: best way to extract name and number
I can get the full name with this:
,LTRIM(RTRIM(SUBSTRING([user_name], CHARINDEX(')', [user_name]) + 1,
PATINDEX('%[+-][0-9]%', [user_name]) - (CHARINDEX(')', [user_name]) + 1))))
Viewing 15 posts - 16 through 30 (of 386 total)