How can i radomly choose the slottime and day from this list using sql server DayTimeSlotIdSlotTitleStartTimeDayIDNameEndTimeisActive10800 AM0900 AM000001MONDAY00000020900 AM1000 AM000001MONDAY00000031000 AM1100 AM000001MONDAY00000041100 AM1200 PM000001MONDAY00000051200 PM0100 PM000001MONDAY00000060100 PM0200 PM000001MONDAY00000070200 PM0300 PM000001MONDAY00000080300 PM0400 PM000001MONDAY00000090800 AM0900 AM000002TUESDAY0000001009

Radomly select record from database in SQL Server

makumbis...

SOLVED CLOSED ACTIVE ANSWERED
User: makumbisulaiman58
Posted: on Sep 24, 2024 03:28 AM
Forum: SQL Server
Answer: 1
Views: 1359

How can i radomly choose the slottime and day from this list using sql server.

DayTimeSlotId	SlotTitle	StartTime	DayID	Name	EndTime	isActive
1	08:00 AM-09:00 AM	00:00.0	1	MONDAY	00:00.0	0
2	09:00 AM-10:00 AM	00:00.0	1	MONDAY	00:00.0	0
3	10:00 AM-11:00 AM	00:00.0	1	MONDAY	00:00.0	0
4	11:00 AM-12:00 PM	00:00.0	1	MONDAY	00:00.0	0
5	12:00 PM-01:00 PM	00:00.0	1	MONDAY	00:00.0	0
6	01:00 PM-02:00 PM	00:00.0	1	MONDAY	00:00.0	0
7	02:00 PM-03:00 PM	00:00.0	1	MONDAY	00:00.0	0
8	03:00 PM-04:00 PM	00:00.0	1	MONDAY	00:00.0	0
9	08:00 AM-09:00 AM	00:00.0	2	TUESDAY	00:00.0	0
10	09:00 AM-10:00 AM	00:00.0	2	TUESDAY	00:00.0	0
11	10:00 AM-11:00 AM	00:00.0	2	TUESDAY	00:00.0	0
12	11:00 AM-12:00 PM	00:00.0	2	TUESDAY	00:00.0	0
13	12:00 PM-01:00 PM	00:00.0	2	TUESDAY	00:00.0	0
14	01:00 PM-02:00 PM	00:00.0	2	TUESDAY	00:00.0	0
15	02:00 PM-03:00 PM	00:00.0	2	TUESDAY	00:00.0	0
16	03:00 PM-04:00 PM	00:00.0	2	TUESDAY	00:00.0	0
17	08:00 AM-09:00 AM	00:00.0	3	WEDNESDAY	00:00.0	0
18	09:00 AM-10:00 AM	00:00.0	3	WEDNESDAY	00:00.0	0
19	10:00 AM-11:00 AM	00:00.0	3	WEDNESDAY	00:00.0	0
20	11:00 AM-12:00 PM	00:00.0	3	WEDNESDAY	00:00.0	0
21	12:00 PM-01:00 PM	00:00.0	3	WEDNESDAY	00:00.0	0
22	01:00 PM-02:00 PM	00:00.0	3	WEDNESDAY	00:00.0	0
23	02:00 PM-03:00 PM	00:00.0	3	WEDNESDAY	00:00.0	0
24	03:00 PM-04:00 PM	00:00.0	3	WEDNESDAY	00:00.0	0
25	08:00 AM-09:00 AM	00:00.0	4	THURSDAY	00:00.0	0
26	09:00 AM-10:00 AM	00:00.0	4	THURSDAY	00:00.0	0
27	10:00 AM-11:00 AM	00:00.0	4	THURSDAY	00:00.0	0
28	11:00 AM-12:00 PM	00:00.0	4	THURSDAY	00:00.0	0
29	12:00 PM-01:00 PM	00:00.0	4	THURSDAY	00:00.0	0
30	01:00 PM-02:00 PM	00:00.0	4	THURSDAY	00:00.0	0
31	02:00 PM-03:00 PM	00:00.0	4	THURSDAY	00:00.0	0
32	03:00 PM-04:00 PM	00:00.0	4	THURSDAY	00:00.0	0
33	08:00 AM-09:00 AM	00:00.0	5	FRIDAY	00:00.0	0
34	09:00 AM-10:00 AM	00:00.0	5	FRIDAY	00:00.0	0
35	10:00 AM-11:00 AM	00:00.0	5	FRIDAY	00:00.0	0
36	11:00 AM-12:00 PM	00:00.0	5	FRIDAY	00:00.0	0
37	12:00 PM-01:00 PM	00:00.0	5	FRIDAY	00:00.0	0
38	01:00 PM-02:00 PM	00:00.0	5	FRIDAY	00:00.0	0
39	02:00 PM-03:00 PM	00:00.0	5	FRIDAY	00:00.0	0
40	03:00 PM-04:00 PM	00:00.0	5	FRIDAY	00:00.0	0
41	08:00 AM-08:48 AM	00:00.0	5	FRIDAY	48:00.0	0
42	08:48 AM-09:36 AM	48:00.0	5	FRIDAY	36:00.0	0
43	09:36 AM-10:24 AM	36:00.0	5	FRIDAY	24:00.0	0
44	10:24 AM-11:12 AM	24:00.0	5	FRIDAY	12:00.0	0
45	11:12 AM-12:00 PM	12:00.0	5	FRIDAY	00:00.0	0
46	12:00 PM-12:48 PM	00:00.0	5	FRIDAY	48:00.0	0
47	12:48 PM-01:36 PM	48:00.0	5	FRIDAY	36:00.0	0
48	01:36 PM-02:24 PM	36:00.0	5	FRIDAY	24:00.0	0
49	02:24 PM-03:12 PM	24:00.0	5	FRIDAY	12:00.0	0
50	03:12 PM-04:00 PM	12:00.0	5	FRIDAY	00:00.0	0
51	08:00 AM-09:00 AM	00:00.0	5	FRIDAY	00:00.0	0
52	09:00 AM-10:00 AM	00:00.0	5	FRIDAY	00:00.0	0
53	10:00 AM-11:00 AM	00:00.0	5	FRIDAY	00:00.0	0
54	11:00 AM-12:00 PM	00:00.0	5	FRIDAY	00:00.0	0
55	12:00 PM-01:00 PM	00:00.0	5	FRIDAY	00:00.0	0
56	01:00 PM-02:00 PM	00:00.0	5	FRIDAY	00:00.0	0
57	02:00 PM-03:00 PM	00:00.0	5	FRIDAY	00:00.0	0
58	03:00 PM-04:00 PM	00:00.0	5	FRIDAY	00:00.0	0
59	09:00 AM-10:36 AM	00:00.0	1	MONDAY	36:00.0	0
60	10:36 AM-12:12 PM	36:00.0	1	MONDAY	12:00.0	0
61	12:12 PM-01:48 PM	12:00.0	1	MONDAY	48:00.0	0
62	01:48 PM-03:24 PM	48:00.0	1	MONDAY	24:00.0	0
63	03:24 PM-05:00 PM	24:00.0	1	MONDAY	00:00.0	0
64	09:30 AM-11:00 AM	30:00.0	1	MONDAY	00:00.0	0
65	11:00 AM-12:30 PM	00:00.0	1	MONDAY	30:00.0	0
66	12:30 PM-02:00 PM	30:00.0	1	MONDAY	00:00.0	0
67	02:00 PM-03:30 PM	00:00.0	1	MONDAY	30:00.0	0
68	03:30 PM-05:00 PM	30:00.0	1	MONDAY	00:00.0	0
69	09:30 AM-11:00 AM	30:00.0	2	TUESDAY	00:00.0	1
70	11:00 AM-12:30 PM	00:00.0	2	TUESDAY	30:00.0	1
71	12:30 PM-02:00 PM	30:00.0	2	TUESDAY	00:00.0	1
72	02:00 PM-03:30 PM	00:00.0	2	TUESDAY	30:00.0	1
73	03:30 PM-05:00 PM	30:00.0	2	TUESDAY	00:00.0	1
74	09:30 AM-11:00 AM	30:00.0	3	WEDNESDAY	00:00.0	1
75	11:00 AM-12:30 PM	00:00.0	3	WEDNESDAY	30:00.0	1
76	12:30 PM-02:00 PM	30:00.0	3	WEDNESDAY	00:00.0	1
77	02:00 PM-03:30 PM	00:00.0	3	WEDNESDAY	30:00.0	1
78	03:30 PM-05:00 PM	30:00.0	3	WEDNESDAY	00:00.0	1
79	09:30 AM-11:00 AM	30:00.0	4	THURSDAY	00:00.0	1
80	11:00 AM-12:30 PM	00:00.0	4	THURSDAY	30:00.0	1
81	12:30 PM-02:00 PM	30:00.0	4	THURSDAY	00:00.0	1
82	02:00 PM-03:30 PM	00:00.0	4	THURSDAY	30:00.0	1
83	03:30 PM-05:00 PM	30:00.0	4	THURSDAY	00:00.0	1
84	09:30 AM-11:00 AM	30:00.0	5	FRIDAY	00:00.0	1
85	11:00 AM-12:30 PM	00:00.0	5	FRIDAY	30:00.0	1
86	12:30 PM-02:00 PM	30:00.0	5	FRIDAY	00:00.0	1
87	02:00 PM-03:30 PM	00:00.0	5	FRIDAY	30:00.0	1
88	03:30 PM-05:00 PM	30:00.0	5	FRIDAY	00:00.0	1
89	08:00 AM-10:15 AM	00:00.0	1	MONDAY	15:00.0	1
90	10:15 AM-12:30 PM	15:00.0	1	MONDAY	30:00.0	1
91	12:30 PM-02:45 PM	30:00.0	1	MONDAY	45:00.0	1
92	02:45 PM-05:00 PM	45:00.0	1	MONDAY	00:00.0	1

Please help

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Sep 24, 2024 05:26 AM
Report

Hi makumbisulaim...,

Use ORDER BY NEWID in the select query.

Refer below link.

How to select a single Random Record each time in Query in SQL Server

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Radomly select record from database in SQL Server

Company

Explore

Follow us

Contact Us