Viewing 15 posts - 1 through 15 (of 86 total)
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
sorry probably more important info.
this comes from a create cursor and reading thru the rows
the fetch next on that row is the one that throws error
December 31, 2020 at 11:17 pm
thank you all. i got it over to the requestor and he ran it and said it was perfect as it gave him everything he needed.
so thank you all again....
July 16, 2020 at 9:06 pm
Viewing 15 posts - 1 through 15 (of 86 total)