Click here to Skip to main content
11,428,324 members (63,140 online)
   

Database

 
QuestionSQL Query To select result for monthly Pin
VishwaKL9-Dec-12 23:43
memberVishwaKL9-Dec-12 23:43 
AnswerRe: SQL Query To select result for monthly Pin
Eddy Vluggen10-Dec-12 0:12
memberEddy Vluggen10-Dec-12 0:12 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL10-Dec-12 0:15
memberVishwaKL10-Dec-12 0:15 
GeneralRe: SQL Query To select result for monthly Pin
Eddy Vluggen10-Dec-12 0:18
memberEddy Vluggen10-Dec-12 0:18 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL10-Dec-12 0:20
memberVishwaKL10-Dec-12 0:20 
GeneralRe: SQL Query To select result for monthly Pin
Eddy Vluggen10-Dec-12 0:24
memberEddy Vluggen10-Dec-12 0:24 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL10-Dec-12 0:27
memberVishwaKL10-Dec-12 0:27 
AnswerRe: SQL Query To select result for monthly Pin
David Mujica10-Dec-12 4:16
memberDavid Mujica10-Dec-12 4:16 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL10-Dec-12 15:48
memberVishwaKL10-Dec-12 15:48 
GeneralRe: SQL Query To select result for monthly Pin
Shameel10-Dec-12 22:34
memberShameel10-Dec-12 22:34 
GeneralRe: SQL Query To select result for monthly Pin
J4amieC11-Dec-12 1:11
memberJ4amieC11-Dec-12 1:11 
GeneralRe: SQL Query To select result for monthly Pin
VishwaKL11-Dec-12 15:54
memberVishwaKL11-Dec-12 15:54 
AnswerRe: SQL Query To select result for monthly Pin
MS SQL DEVELOPER11-Dec-12 0:35
memberMS SQL DEVELOPER11-Dec-12 0:35 
QuestionHow to get the closing balance to be the opening balance of the following month Pin
vusamozi9-Dec-12 20:23
membervusamozi9-Dec-12 20:23 
select StockNumber,InventoryName,Year1,Month1,RECEIVE_FROM_PO,RECEIVE_XFER,RECEIVE_ADJ,
_RETURN,ADJUSTMENT,ISSUE,PT_ISSUE,TRANSFER, SUM(ABS(RECEIVE_FROM_PO + RECEIVE_XFER + RECEIVE_ADJ + _RETURN))
- SUM(ABS(ADJUSTMENT + ISSUE + PT_ISSUE + TRANSFER))
 as BALANCE, BALANCE as OPENING_BAL
into final2
from dbo.drug_summary$
GROUP BY StockNumber,InventoryName,Year1,Month1,RECEIVE_FROM_PO,RECEIVE_XFER,RECEIVE_ADJ,
_RETURN,ADJUSTMENT,ISSUE,PT_ISSUE,TRANSFER,BALANCE
Confused | :confused:
AnswerRe: How to get the closing balance to be the opening balance of the following month Pin
Eddy Vluggen10-Dec-12 0:13
memberEddy Vluggen10-Dec-12 0:13 
AnswerRe: How to get the closing balance to be the opening balance of the following month Pin
@AmitGajjar11-Dec-12 8:17
member@AmitGajjar11-Dec-12 8:17 
QuestionSelect All Months and related data Pin
VishwaKL6-Dec-12 23:21
memberVishwaKL6-Dec-12 23:21 
AnswerRe: Select All Months and related data Pin
Blue_Boy7-Dec-12 2:18
memberBlue_Boy7-Dec-12 2:18 
GeneralRe: Select All Months and related data Pin
Mycroft Holmes8-Dec-12 21:57
memberMycroft Holmes8-Dec-12 21:57 
GeneralRe: Select All Months and related data Pin
VishwaKL9-Dec-12 20:06
memberVishwaKL9-Dec-12 20:06 
GeneralRe: Select All Months and related data Pin
Mycroft Holmes9-Dec-12 20:15
memberMycroft Holmes9-Dec-12 20:15 
GeneralRe: Select All Months and related data Pin
VishwaKL9-Dec-12 20:19
memberVishwaKL9-Dec-12 20:19 
GeneralRe: Select All Months and related data Pin
VishwaKL9-Dec-12 19:37
memberVishwaKL9-Dec-12 19:37 
GeneralRe: Select All Months and related data Pin
Deepak Kr110-Dec-12 20:27
memberDeepak Kr110-Dec-12 20:27 
GeneralRe: Select All Months and related data Pin
VishwaKL10-Dec-12 20:31
memberVishwaKL10-Dec-12 20:31 
GeneralRe: Select All Months and related data Pin
Deepak Kr110-Dec-12 22:02
memberDeepak Kr110-Dec-12 22:02 
GeneralRe: Select All Months and related data Pin
VishwaKL10-Dec-12 22:46
memberVishwaKL10-Dec-12 22:46 
GeneralRe: Select All Months and related data Pin
Deepak Kr110-Dec-12 23:25
memberDeepak Kr110-Dec-12 23:25 
QuestionSSRS 2005 Pin
berba6-Dec-12 7:32
memberberba6-Dec-12 7:32 
AnswerRe: SSRS 2005 Pin
David Mujica6-Dec-12 8:59
memberDavid Mujica6-Dec-12 8:59 
AnswerRe: SSRS 2005 Pin
djj556-Dec-12 10:30
memberdjj556-Dec-12 10:30 
AnswerRe: SSRS 2005 Pin
Mycroft Holmes6-Dec-12 17:57
memberMycroft Holmes6-Dec-12 17:57 
GeneralRe: SSRS 2005 Pin
berba6-Dec-12 19:06
memberberba6-Dec-12 19:06 
GeneralRe: SSRS 2005 Pin
Mycroft Holmes6-Dec-12 22:43
memberMycroft Holmes6-Dec-12 22:43 
QuestionSQL Group By Question [modified] Pin
loyal ginger6-Dec-12 6:27
memberloyal ginger6-Dec-12 6:27 
AnswerRe: SQL Group By Question Pin
Blue_Boy6-Dec-12 11:11
memberBlue_Boy6-Dec-12 11:11 
GeneralRe: SQL Group By Question Pin
loyal ginger31-Dec-12 6:48
memberloyal ginger31-Dec-12 6:48 
QuestionIssues installing ODP.NETx64 Pin
cpp_prgmer6-Dec-12 5:18
membercpp_prgmer6-Dec-12 5:18 
AnswerRe: Issues installing ODP.NETx64 Pin
Eddy Vluggen6-Dec-12 15:37
memberEddy Vluggen6-Dec-12 15:37 
GeneralRe: Issues installing ODP.NETx64 Pin
Peter_in_27806-Dec-12 16:12
memberPeter_in_27806-Dec-12 16:12 
GeneralRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 17:52
memberMycroft Holmes6-Dec-12 17:52 
AnswerRe: Issues installing ODP.NETx64 Pin
Mycroft Holmes6-Dec-12 17:53
memberMycroft Holmes6-Dec-12 17:53 
QuestionSQL Query - append results Pin
AndreFratelli5-Dec-12 7:43
memberAndreFratelli5-Dec-12 7:43 
AnswerRe: SQL Query - append results Pin
Chris Meech5-Dec-12 7:55
memberChris Meech5-Dec-12 7:55 
GeneralRe: SQL Query - append results Pin
AndreFratelli5-Dec-12 8:08
memberAndreFratelli5-Dec-12 8:08 
QuestionSQL 2008 Data Base Table Design suggestion Pin
VishwaKL5-Dec-12 0:36
memberVishwaKL5-Dec-12 0:36 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale5-Dec-12 0:43
memberSimon_Whale5-Dec-12 0:43 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
VishwaKL5-Dec-12 0:47
memberVishwaKL5-Dec-12 0:47 
GeneralRe: SQL 2008 Data Base Table Design suggestion Pin
Simon_Whale5-Dec-12 0:51
memberSimon_Whale5-Dec-12 0:51 
AnswerRe: SQL 2008 Data Base Table Design suggestion Pin
PIEBALDconsult5-Dec-12 4:56
memberPIEBALDconsult5-Dec-12 4:56 

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

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


Advertise | Privacy | Mobile
Web02 | 2.8.150428.2 | Last Updated 1 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid