I need to create a stored procedure with a parameterised input. An input parameter is declared as a variable, this will hold the units that a user...
I have the following fields in TableA running on SQL Server 2000: Dates as datetime Item_ID as int (Primary key) Item_No as int Qty as...
I have the following fields in Table A running in MS SQL Server 2000: MAJOR| MINOR| PRODMGR|CST_USD |REV_USD|LCTRYNUM |AMT_TYPE...
I have the following fields in table A: Date | Descrip | Amt Dr ---------------------------------- 01/02/2006 | 740240 |(2,400.00)...
Hi Coderzone Thanks for the help, but, there seems to be some problem here while running the script, here is the error message from prompted...
The liability that are extracted should be from Period 08 in Year 2005, can we query with date criteria?
The Total Sales is actually a summation of all sales made for a particular period, vice-versa for Total Cost
I have the following fields in table A: GL_ID| Date |GL_Name_VC | Amount |Period_TI|Year_SI...
I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI...
I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI|...
I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI...
Separate names with a comma.