Click here to Skip to main content
15,850,606 members
Home / Discussions / Database
   

Database

 
AnswerRe: Entity Framework Book. Pin
Mycroft Holmes23-Jul-15 15:10
professionalMycroft Holmes23-Jul-15 15:10 
QuestionSQL Linq, select from select and join Pin
jkirkerx21-Jul-15 14:27
professionaljkirkerx21-Jul-15 14:27 
SuggestionRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 2:50
mveRichard Deeming22-Jul-15 2:50 
GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 7:02
professionaljkirkerx22-Jul-15 7:02 
GeneralRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 9:00
mveRichard Deeming22-Jul-15 9:00 
GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 10:04
professionaljkirkerx22-Jul-15 10:04 
QuestionTrouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 14:08
professionaljkirkerx20-Jul-15 14:08 
AnswerRe: Trouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 14:34
professionaljkirkerx20-Jul-15 14:34 
Got the union working, and sum, just have trouble with the date range.
pValue = _
                ((From oh In context.Order_History
                Where oh.OrderStatus = "COMPLETED" _
                And oh.OrderDate = DbFunctions.AddDays(DateTime.Now(), 0)
                Select oh.GrandTotal).Union _
                (From oc In context.Order_Completed
                Where oc.OrderStatus = "QUEUED_FOR_FULFILLMENT" _
                Or oc.OrderStatus = "OUT_FOR_FULFILLMENT" _
                Or oc.OrderStatus = "QUEUED_FOR_SHIPPING" _
                Or oc.OrderStatus = "OUT_FOR_PACKAGING" _
                Or oc.OrderStatus = "READY_TO_SHIP" _
                And oc.OrderDate = DbFunctions.AddDays(DateTime.Now(), 0)
                Select oc.GrandTotal)).Sum()

Generalmake nullable type Pin
jkirkerx20-Jul-15 14:59
professionaljkirkerx20-Jul-15 14:59 
General[Got It] Pin
jkirkerx21-Jul-15 10:58
professionaljkirkerx21-Jul-15 10:58 
GeneralThe above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx22-Jul-15 9:54
professionaljkirkerx22-Jul-15 9:54 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Mycroft Holmes22-Jul-15 15:15
professionalMycroft Holmes22-Jul-15 15:15 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 7:38
professionaljkirkerx23-Jul-15 7:38 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Brisingr Aerowing23-Jul-15 8:37
professionalBrisingr Aerowing23-Jul-15 8:37 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 9:21
professionaljkirkerx23-Jul-15 9:21 
QuestionDatabase management Pin
Otekpo Emmanuel19-Jul-15 10:22
Otekpo Emmanuel19-Jul-15 10:22 
GeneralRe: Database management Pin
PIEBALDconsult19-Jul-15 10:40
mvePIEBALDconsult19-Jul-15 10:40 
AnswerRe: Database management Pin
Richard MacCutchan19-Jul-15 23:00
mveRichard MacCutchan19-Jul-15 23:00 
AnswerRe: Database management Pin
Mycroft Holmes19-Jul-15 23:32
professionalMycroft Holmes19-Jul-15 23:32 
AnswerRe: Database management Pin
Wendelius20-Jul-15 7:50
mentorWendelius20-Jul-15 7:50 
QuestionDatabase management Pin
Otekpo Emmanuel19-Jul-15 10:38
Otekpo Emmanuel19-Jul-15 10:38 
QuestionRe: Database management Pin
ZurdoDev22-Jul-15 10:48
professionalZurdoDev22-Jul-15 10:48 
Questionlarge database Pin
V.16-Jul-15 22:46
professionalV.16-Jul-15 22:46 
AnswerRe: large database Pin
Wendelius16-Jul-15 23:03
mentorWendelius16-Jul-15 23:03 
GeneralRe: large database Pin
V.16-Jul-15 23:10
professionalV.16-Jul-15 23:10 

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.