Viewing 15 posts - 1 through 15 (of 85 total)
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
December 16, 2013 at 3:21 am
Have you tried creating a parameter which takes in A,B,C as value and another parameter which depends on the first dataset for operations to perform .
Read cascading parameter :-...
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
December 16, 2013 at 3:18 am
Pros :- Automated process don't have to bother about scheduling report every now and then. Data driven subscription allows you to pass multiple parameters without bothering about reports. Reports generated...
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
December 16, 2013 at 3:13 am
Very good initiative.
http://qa.sqlservercentral.com/articles/SQLServerCentral/105392/
-- Delete Duplicate Data
; WITH CTE AS (
Select A,B, RowNum = Row_Number() OVER (ORDER BY A)
From t_TAble1
)
DELETE FROM CTE
WHERE RowNum > 1
Thanks,
Ankit
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
December 5, 2013 at 2:34 am
Either use RenderFormat = ExcelOpenXML
or Excel in ReportServices.config file add Visible = "false"
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 8:59 am
Thanks K,
I hope the solution is :-
Use the Excel renderer (xls) by changing the value of Visible to true, in the following line in the RSReportServer.config file.
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="true"/>
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 4:18 am
No I guess
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 3:44 am
Excel
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 2:59 am
Again the ReportURL can change. Need the report server name or machine name
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
October 1, 2013 at 11:06 pm
not report name but server name
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
October 1, 2013 at 11:58 am
Unfortunately, it has become a show stopper for me as the query fetches some ad-hoc report and the same is failing.
Can you let me know why exactly it hapenes...
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
April 1, 2013 at 8:03 am
If you are importing using DTS/Import Export wizard. you might want to Edit the data type and length of the source. Cause thats what might be causing the truncate.
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
January 17, 2013 at 12:53 am
Hi,
You can switch partitions if your idea allows this or TRANSFER the partition to other. PLease follow the following url for more details.
http://msdn.microsoft.com/en-us/library/ms142159.aspx
http://msdn.microsoft.com/en-us/library/ms191160(v=sql.105).aspx
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
January 17, 2013 at 12:44 am
Money can take upto 5 decimal. Whereas, if you need > 5 decimal places for a value go for decimal(n,m)
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
January 16, 2013 at 11:40 pm
Even excel wont allow that many columns .. are you sure you are talking abt coln and not rows ?
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
September 18, 2012 at 12:44 pm
Viewing 15 posts - 1 through 15 (of 85 total)