Hi Jeff

Yes the datatype is represented that way within the DB.

I'm also worried about Policy and BatchMonth. I will talk to the Database Administrator as Policy should be Char while BatchMonth...

Works fine as well.. thanks..

Its SQL Server 2016. Thanks, i used your query as the results are consistent.

This has solved my issue.

Yes each month will have data. I will let know if that works

Hi guys
Thank you for the help.

Sometimes when the brain is under pressure, it failes to processes instructions well..But thank you for the solution.

Final query for...

Thank you so much this is correct. You saved me hours from excel.

Phil Parkin (8/18/2016)

shani19831 (8/18/2016)

Yes the result is not really the same but i can...

Thank you for the reply.

Yes the result is not really the same but i can work from excel to change it. something I would love to avoid..

I cant get the...

Sorry guys, dedication and eager to learn has forced me to write this query is retrieving the information that I want.

select ID,

stuff((SELECT ':' + cast(mobile_number as varchar(10))

...

CREATE TABLE [dbo].[MTCBEN](

[ID] [varchar](250) NULL,

[MOBILE_NUMBER] [varchar](50) NULL,

[AMOUNT] [varchar](50) NULL,

[CURRENCY] [varchar](50) NULL,

[PROCESSING_DATE] [varchar](50) NULL

) ON [PRIMARY]

INSERT INTO [dbo].[MTCBEN]

([ID]

...

So, based on this, the reports do "live" in the ReportServer databases? As long as I make sure to backup the encryption key(s,) take a backup of the DBs...

On the current application server where your reporting services is installed,

do the following

http://www.mssqltips.com/sqlservertip/1453/sql-server-reporting-services-configuration-tool/

http://prajwaldesai.com/deploying-sccm-2012-part-12-installing-and-configuring-reporting-services-point/

start Reporting Services Configuration

1.Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, and...

hi there,

Which SSRS are you moving? 2000, 2005, 2008 or 2012?

Hi Joie Andrew and Ed

I have extensive search but looks like reporting 2000 is not longer supported, i was also not successful in installing it as it kept complaining about...

Hi Guys,

I have LEFT OUTER JOIN some tables in order to display the rest of the information, but the query takes 14:16 minutes to retrieve 42017 rows, which in my...