Click here to Skip to main content
15,567,466 members
Home / Discussions / Database
   

Database

 
AnswerRe: Question Regarding SQL Parameter Query Pin
Richard Deeming1-Apr-20 3:32
mveRichard Deeming1-Apr-20 3:32 
QuestionTrigger keeps inserting duplicates Pin
greatwhite131-Mar-20 8:48
greatwhite131-Mar-20 8:48 
AnswerRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 10:51
professionalZurdoDev31-Mar-20 10:51 
GeneralRe: Trigger keeps inserting duplicates Pin
greatwhite131-Mar-20 14:51
greatwhite131-Mar-20 14:51 
GeneralRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 16:44
professionalZurdoDev31-Mar-20 16:44 
AnswerRe: Trigger keeps inserting duplicates Pin
Richard Deeming1-Apr-20 1:44
mveRichard Deeming1-Apr-20 1:44 
RantRe: Trigger keeps inserting duplicates Pin
Mycroft Holmes1-Apr-20 13:45
professionalMycroft Holmes1-Apr-20 13:45 
QuestionHow to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Barath835730-Mar-20 2:57
Barath835730-Mar-20 2: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 3:12
professionalZurdoDev30-Mar-20 3:12 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev31-Mar-20 10:52
professionalZurdoDev31-Mar-20 10:52 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Mycroft Holmes31-Mar-20 13:50
professionalMycroft Holmes31-Mar-20 13:50 
QuestionCreate a new Primary Key on survey table Pin
learning_new25-Feb-20 13:01
learning_new25-Feb-20 13:01 
AnswerRe: Create a new Primary Key on survey table Pin
Nathan Minier28-Feb-20 7:38
professionalNathan Minier28-Feb-20 7:38 
AnswerRe: Create a new Primary Key on survey table Pin
Eddy Vluggen28-Feb-20 10:48
professionalEddy Vluggen28-Feb-20 10:48 
AnswerRe: Create a new Primary Key on survey table Pin
David Mujica2-Mar-20 4:56
David Mujica2-Mar-20 4:56 
GeneralRe: Create a new Primary Key on survey table Pin
learning_new3-Mar-20 5:28
learning_new3-Mar-20 5:28 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 14:35
Super Lloyd5-Feb-20 14:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 16:09
professionalEddy Vluggen5-Feb-20 16:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 18:38
Super Lloyd5-Feb-20 18:38 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 3:50
professionalEddy Vluggen6-Feb-20 3:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 23:28
professionalJörgen Andersson5-Feb-20 23:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 1:17
mveRichard Deeming6-Feb-20 1:17 
Questionintegrity constraint Pin
Tara112-Feb-20 7:23
Tara112-Feb-20 7:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 9:47
mveWendelius2-Feb-20 9:47 
GeneralRe: integrity constraint Pin
Tara112-Feb-20 10:07
Tara112-Feb-20 10: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.