Viewing 15 posts - 151 through 165 (of 669 total)
Very easy. Glad you asked.
Step 1: Right Click the .BIM file and select View Code
Step 2: Ctrl+F to find __Count of Model
Step 3: Comment the entire Command block that defines...
December 8, 2011 at 5:56 am
As Koen has mentioned, let's not make this forum an interview board.
December 8, 2011 at 4:18 am
SELECT DR_DCATCD,
SUM(SUM(DR_DQTY)-SUM(POUT_QTY)) AS QTY,
SUM(DR_DQTY*DR_DUPRICE) AS AMT
FROM DRDTL
INNER JOIN
POUT_DTL
ON DRDTL.DR_DICODE=POUT_DTL.POUT_BC
WHERE DR_DDATE BETWEEN #6/1/2009# AND #6/30/2009#
AND DR_DSTORE IN('342','338','333','302','315','303','312','332','316','325','339','129','217','128')
GROUP BY DR_DCATCD;
SELECT DR_DCATCD,
SUM(DR_DQTY)-SUM(POUT_QTY) AS QTY,
SUM(DR_DQTY*DR_DUPRICE) AS AMT
FROM DRDTL
INNER JOIN
POUT_DTL
ON DRDTL.DR_DICODE=POUT_DTL.POUT_BC
WHERE DR_DDATE BETWEEN #6/1/2009#...
December 8, 2011 at 3:30 am
Why don't you convert the date in the SQL/MDX query and bring the formatted date to report?
November 8, 2011 at 10:53 pm
sambireddy chirra (10/10/2011)
I have struck up one place, i am creating one report using rectangle, one requirement i need to hide the Rectangle in one condition. But i...
October 11, 2011 at 1:08 am
Phil Parkin (10/6/2011)
Raunak Jhawar (10/6/2011)
If SQL 2008 and upwards...please follow the link herePlease describe how to use that within an SSIS package.
Execute SQL Task/Script Task
October 6, 2011 at 4:25 am
If SQL 2008 and upwards...please follow the link here
October 6, 2011 at 3:52 am
Steve, I really do not see any point in spoon feeding.
October 3, 2011 at 6:56 am
Prakash,
help us help you...don't provide information in parts...
give a detailed brief of your situation and the methods that you have tried for a faster resolution 🙂
October 3, 2011 at 1:48 am
Step 1: Understand the cause of failure
Step 2: Take precautionary measures, if the error occurs again
Step 3: Relax 🙂
October 3, 2011 at 1:13 am
Well..since I am not clear with the host which has the file...
Follow these steps:
1. Develop a ST to do the following:
a. Create a connection with host
b. Create a pointer to...
October 2, 2011 at 11:06 pm
You will find a parameters column in your executionLog2 view of your RSDB.
This will help you determine the parameter list. 🙂
September 27, 2011 at 7:07 am
Viewing 15 posts - 151 through 165 (of 669 total)