Click here to Skip to main content
14,742,447 members
Home » Discussions » Database
   

Database

 
QuestionTrigger value > ? write in different table Pin
brian121026-Dec-17 14:44
Memberbrian121026-Dec-17 14:44 
AnswerRe: Trigger value > ? write in different table Pin
Victor Nijegorodov26-Dec-17 23:13
MemberVictor Nijegorodov26-Dec-17 23:13 
AnswerRe: Trigger value > ? write in different table Pin
Richard MacCutchan26-Dec-17 23:41
mveRichard MacCutchan26-Dec-17 23:41 
Rant[REPOST] Trigger value > ? write in different table Pin
Richard Deeming8-Jan-18 8:24
mveRichard Deeming8-Jan-18 8:24 
Questiondata between 1st jan to December 31st of previous year query --no hard coded dates. Pin
sai.201226-Dec-17 11:51
Membersai.201226-Dec-17 11:51 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Victor Nijegorodov26-Dec-17 23:06
MemberVictor Nijegorodov26-Dec-17 23:06 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Chris Quinn27-Dec-17 1:01
MemberChris Quinn27-Dec-17 1:01 
AnswerRe: data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
jschell1-Jan-18 8:11
Memberjschell1-Jan-18 8:11 
Your requirements are bad. (I would presume and hope that they were made up by a teacher.)

The second two requirements can be expressed as
Req: Given today's date run a query that spans the 'prior' year based on that date.

The first requirement is incompatible with that and it is impossible to implement without other input data. One way to do that is in fact to hard code 2017 as a switch value. The second way is to presume that the target table has no data before 2017. However to implement that latter rule would mean that EVERY query would need to do a second query to determine that no data existed.

Not to mention that for users it would be confusing at least over time.
Rant[REPOST] data between 1st jan to December 31st of previous year query --no hard coded dates. Pin
Richard Deeming8-Jan-18 8:27
mveRichard Deeming8-Jan-18 8:27 
QuestionOLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 18:55
professionalUser9874325-Dec-17 18:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard MacCutchan25-Dec-17 21:55
mveRichard MacCutchan25-Dec-17 21:55 
AnswerRe: OLE DB Data Types to C# Data Type Mapping Pin
Mycroft Holmes25-Dec-17 22:33
professionalMycroft Holmes25-Dec-17 22:33 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874325-Dec-17 23:57
professionalUser9874325-Dec-17 23:57 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
jschell26-Dec-17 8:39
Memberjschell26-Dec-17 8:39 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 11:44
professionalUser9874314-Jan-18 11:44 
SuggestionRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard Deeming8-Jan-18 8:38
mveRichard Deeming8-Jan-18 8:38 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 11:50
professionalUser9874314-Jan-18 11:50 
QuestionT-SQL and denomalization of Parent and Child hierarchy Tables Pin
Member 1358789920-Dec-17 22:41
MemberMember 1358789920-Dec-17 22:41 
AnswerRe: T-SQL and denomalization of Parent and Child hierarchy Tables Pin
Victor Nijegorodov21-Dec-17 2:54
MemberVictor Nijegorodov21-Dec-17 2:54 
QuestionTo convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
sai.201218-Dec-17 9:23
Membersai.201218-Dec-17 9:23 
AnswerRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
jschell18-Dec-17 16:51
Memberjschell18-Dec-17 16:51 
QuestionRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
Richard MacCutchan18-Dec-17 22:35
mveRichard MacCutchan18-Dec-17 22:35 
QuestionMicrosoft SQL Server VS PostgresSQL Pin
Zeyad Jalil18-Dec-17 1:02
professionalZeyad Jalil18-Dec-17 1:02 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
Nathan Minier18-Dec-17 2:13
professionalNathan Minier18-Dec-17 2:13 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
jschell18-Dec-17 16:52
Memberjschell18-Dec-17 16:52 

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.