Click here to Skip to main content
14,638,202 members
Home » Discussions » Database
   

Database

 
AnswerRe: Question Regarding SQL Parameter Query Pin
Richard Deeming1-Apr-20 2:32
mveRichard Deeming1-Apr-20 2:32 
QuestionTrigger keeps inserting duplicates Pin
greatwhite131-Mar-20 7:48
Membergreatwhite131-Mar-20 7:48 
AnswerRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 9:51
mveZurdoDev31-Mar-20 9:51 
GeneralRe: Trigger keeps inserting duplicates Pin
greatwhite131-Mar-20 13:51
Membergreatwhite131-Mar-20 13:51 
GeneralRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 15:44
mveZurdoDev31-Mar-20 15:44 
AnswerRe: Trigger keeps inserting duplicates Pin
Richard Deeming1-Apr-20 0:44
mveRichard Deeming1-Apr-20 0:44 
RantRe: Trigger keeps inserting duplicates Pin
Mycroft Holmes1-Apr-20 12:45
professionalMycroft Holmes1-Apr-20 12:45 
QuestionHow to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Barath835730-Mar-20 1:57
MemberBarath835730-Mar-20 1:57 
Hi,
I need to insert all the records from an excel sheet to a sql database table and find out below through sql queries.Excel is attached for reference below


device_id device_name appanalyticssessioneventid app_name category local_time
1223593358dfa0030bfb23209fe2c93b8fe0f0ac2af363b9760e84d0ff2e926c Galaxy S9 Plus 1223593358dfa0030bfb23209fe2c93b8fe0f0ac2af363b9760e84d0ff2e926c:2018-04-20T15:15:37.139UTC:2018-04-20T10:11:14.000 -0500 Robinhood Finance 4-20-2018 10:12:53
1cab04b741fa186ddeb5145df7905eb918ad45a09638a3faac0a2c30d60c38bc Galaxy S9 1cab04b741fa186ddeb5145df7905eb918ad45a09638a3faac0a2c30d60c38bc:2018-04-20T23:53:21.784UTC:2018-04-20T18:17:56.000 -0500 KNOX Configure Productivity 4-20-2018 17:53:02
102151dd863d3ac3f70ec3ed9aa105a847ebf02574300446911d567aa9f713f4 Galaxy S9 Plus 102151dd863d3ac3f70ec3ed9aa105a847ebf02574300446911d567aa9f713f4:2018-05-15T06:29:19.679UTC:2018-05-14T21:33:41.000 -0700 YouTube Entertainment 5-14-2018 21:45:19

[edit]
Removed thousands of lines of the same text
[/edit]

a)Daily avg of app session count per device id
b)How many times on an average user login to facebook app weekly

Thanks,
Barath

modified 30-Mar-20 8:37am.

RantRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev30-Mar-20 2:12
mveZurdoDev30-Mar-20 2:12 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev31-Mar-20 9:52
mveZurdoDev31-Mar-20 9:52 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Mycroft Holmes31-Mar-20 12:50
professionalMycroft Holmes31-Mar-20 12:50 
QuestionCreate a new Primary Key on survey table Pin
learning_new25-Feb-20 12:01
Memberlearning_new25-Feb-20 12:01 
AnswerRe: Create a new Primary Key on survey table Pin
Nathan Minier28-Feb-20 6:38
professionalNathan Minier28-Feb-20 6:38 
AnswerRe: Create a new Primary Key on survey table Pin
Eddy Vluggen28-Feb-20 9:48
professionalEddy Vluggen28-Feb-20 9:48 
AnswerRe: Create a new Primary Key on survey table Pin
David Mujica2-Mar-20 3:56
MemberDavid Mujica2-Mar-20 3:56 
GeneralRe: Create a new Primary Key on survey table Pin
learning_new3-Mar-20 4:28
Memberlearning_new3-Mar-20 4:28 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 13:35
MemberSuper Lloyd5-Feb-20 13:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 15:09
professionalEddy Vluggen5-Feb-20 15:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 17:38
MemberSuper Lloyd5-Feb-20 17:38 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 2:50
professionalEddy Vluggen6-Feb-20 2:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 22:28
professionalJörgen Andersson5-Feb-20 22:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 0:17
mveRichard Deeming6-Feb-20 0:17 
Questionintegrity constraint Pin
Tara112-Feb-20 6:23
MemberTara112-Feb-20 6:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 8:47
mveWendelius2-Feb-20 8:47 
GeneralRe: integrity constraint Pin
Tara112-Feb-20 9:07
MemberTara112-Feb-20 9:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.