Viewing 15 posts - 1 through 15 (of 89 total)
Thank you both, i am still learning/testing the cross apply but the sum over partition sample works for sure.
i am working on the final product being a stored procedure to...
August 26, 2025 at 1:46 pm
the account, date is the sort order and and FYI the type field values can be C, D, A, L and O so in my example i just used C...
August 22, 2025 at 1:27 pm
ok got table1
t1_Date (Date), t1_Value (bigint), t1_Event (varchar(100))
now my user wanted a way to show count of table1 records where t1_Value (bigint) is between 2 values. Simple enough query no...
July 17, 2024 at 8:05 pm
thank you for that.
not sure what got it working but i uninstalled express then installed a dev version verified a connection and that it was working with my app. so...
August 7, 2023 at 5:16 pm
I can not enable tcpip because it is not there. i tried to add an alias and went to new alias but again everything was disabled. so i do not...
August 7, 2023 at 2:37 pm
... and using that same datetime column i am going to do same with the time of day part grouping into 0 - 24 hour 1 hour increments by DOW,...
July 26, 2021 at 11:00 pm
as for the format of this data i am going to be using it for a bar/line chart.
basically 3 different ways.
bar chart with just sunday thru saturday and totals for...
July 26, 2021 at 10:53 pm
INSERT INTO [dbo].[myTable]
([customer]
,[myDateTime]
VALUES
(1 ,'2020-11-20 17:29:56')
(1 ,'2021-01-04 17:27:34')
(1 ,'2021-01-08 17:33:16')
(1 ,'2021-02-04 17:34:35')
(1 ,'2021-02-11 17:19:47')
(1 ,'2021-02-12 07:13:43')
(1 ,'2021-02-12 07:16:53')
(1 ,'2021-03-09 17:27:57')
(1 ,'2021-03-30 17:26:59')
(1 ,'2021-04-09 17:13:36')
(1 ,'2021-04-30 17:37:40')
(1 ,'2021-06-29 17:51:59')
(1 ,'2021-07-12 17:24:59')
(1 ,'2021-07-22...
July 26, 2021 at 6:40 pm
sorry had a meeting to attend
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[myTable](
[customer] [int] NOT NULL,
[myDateTime] [datetime] NOT NULL,
CONSTRAINT [PK_myTable] PRIMARY KEY CLUSTERED
(
[customer] ASC,
[myDateTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...
July 26, 2021 at 6:19 pm
customer, myDateTime
1854
2020-06-17 11:09:04.000
262
2020-08-14 06:20:39.000
157
2020-08-21 11:05:44.000
319
2020-08-27 08:39:22.000
262
2020-08-28 04:52:56.000
1217
2020-09-03 17:11:48.000
262
2020-09-04 05:50:05.000
157
2020-09-04 16:59:15.000
157
2020-09-08 08:13:37.000
262
2020-09-11 06:35:46.000
262
2020-09-18 07:02:56.000
1640
2020-09-22 06:36:18.000
2376
2020-09-23 07:33:50.000
2376
2020-09-23 07:40:58.000
2376
2020-09-23 07:56:15.000
334
2020-09-23 17:03:36.000
1701
2020-09-24 07:50:25.000
1701
2020-09-24 07:51:56.000
122
2020-09-24 16:55:29.000
72
2020-09-27 09:27:27.000
510
2020-09-27 23:59:38.000
80
2020-09-28 12:27:36.000
2014
2020-09-28 13:42:17.000
1854
2020-09-28 14:51:29.000
733
2020-09-28 15:07:27.000
733
2020-09-28 15:08:52.000
334
2020-09-28 17:03:46.000
1898
2020-09-29 07:52:32.000
1898
2020-09-29...
July 26, 2021 at 4:03 pm
Works like a charm. thank you
I have follow up question though. (we always do) i made a minor change to get the month name but basically same results.
why am i...
July 26, 2021 at 2:36 pm
yeah i went thru several days of searching for any info related to acuxdbc and relative files. i have made a feature enhancement from vendor to get this value since...
May 3, 2021 at 10:04 pm
the collation is CP1_CI_AS. I plan on running a script to change the collation to CP437_BIN after hours. I think this should resolve this issue and any future issues related...
January 4, 2021 at 7:19 pm
Char(18)
January 2, 2021 at 5:51 pm
Will see what i can do but client in question only allows access 8-5 M-F business hours. And as for all the details, this comes from acucobol (COBOL) running against...
January 1, 2021 at 4:02 pm
Viewing 15 posts - 1 through 15 (of 89 total)