Click here to Skip to main content
15,867,308 members
Home / Discussions / Database
   

Database

 
SuggestionRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 1:50
mveRichard Deeming22-Jul-15 1:50 
GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 6:02
professionaljkirkerx22-Jul-15 6:02 
GeneralRe: SQL Linq, select from select and join Pin
Richard Deeming22-Jul-15 8:00
mveRichard Deeming22-Jul-15 8:00 
GeneralRe: SQL Linq, select from select and join Pin
jkirkerx22-Jul-15 9:04
professionaljkirkerx22-Jul-15 9:04 
QuestionTrouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 13:08
professionaljkirkerx20-Jul-15 13:08 
AnswerRe: Trouble working with dates again and union and sum Pin
jkirkerx20-Jul-15 13:34
professionaljkirkerx20-Jul-15 13:34 
Generalmake nullable type Pin
jkirkerx20-Jul-15 13:59
professionaljkirkerx20-Jul-15 13:59 
General[Got It] Pin
jkirkerx21-Jul-15 9:58
professionaljkirkerx21-Jul-15 9:58 
Finally
Using context As New OrdersContext

            pValue = _
                (
                    From oh In context.Order_History
                    Where oh.OrderDate >= DateStart _
                    And oh.OrderDate <= DateStop _
                    And oh.OrderStatus = "COMPLETED" _
                    Select oh.GrandTotal
                ).Union _
                (
                    From oc In context.Order_Completed
                    Where oc.OrderDate >= DateStart _
                    And oc.OrderDate <= DateStop _
                    And 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"
                    Select oc.GrandTotal
                ).DefaultIfEmpty().Sum()

        End Using

GeneralThe above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx22-Jul-15 8:54
professionaljkirkerx22-Jul-15 8:54 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Mycroft Holmes22-Jul-15 14:15
professionalMycroft Holmes22-Jul-15 14:15 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 6:38
professionaljkirkerx23-Jul-15 6:38 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
Brisingr Aerowing23-Jul-15 7:37
professionalBrisingr Aerowing23-Jul-15 7:37 
GeneralRe: The above post is incorrect - SQL Linq, Date Range, Union in VB Pin
jkirkerx23-Jul-15 8:21
professionaljkirkerx23-Jul-15 8:21 
QuestionDatabase management Pin
Otekpo Emmanuel19-Jul-15 9:22
Otekpo Emmanuel19-Jul-15 9:22 
GeneralRe: Database management Pin
PIEBALDconsult19-Jul-15 9:40
mvePIEBALDconsult19-Jul-15 9:40 
AnswerRe: Database management Pin
Richard MacCutchan19-Jul-15 22:00
mveRichard MacCutchan19-Jul-15 22:00 
AnswerRe: Database management Pin
Mycroft Holmes19-Jul-15 22:32
professionalMycroft Holmes19-Jul-15 22:32 
AnswerRe: Database management Pin
Wendelius20-Jul-15 6:50
mentorWendelius20-Jul-15 6:50 
QuestionDatabase management Pin
Otekpo Emmanuel19-Jul-15 9:38
Otekpo Emmanuel19-Jul-15 9:38 
QuestionRe: Database management Pin
ZurdoDev22-Jul-15 9:48
professionalZurdoDev22-Jul-15 9:48 
Questionlarge database Pin
V.16-Jul-15 21:46
professionalV.16-Jul-15 21:46 
AnswerRe: large database Pin
Wendelius16-Jul-15 22:03
mentorWendelius16-Jul-15 22:03 
GeneralRe: large database Pin
V.16-Jul-15 22:10
professionalV.16-Jul-15 22:10 
GeneralRe: large database Pin
Wendelius16-Jul-15 22:20
mentorWendelius16-Jul-15 22:20 
GeneralRe: large database Pin
Mycroft Holmes17-Jul-15 14:02
professionalMycroft Holmes17-Jul-15 14:02 

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.