Profile cover photo
Profile photo
Avanish Tomar
18 followers -
Business Intelligence Developer at Accretive Health
Business Intelligence Developer at Accretive Health

18 followers
About
Avanish's posts

Post has attachment
Different Types of SSRS reports
  Different Types of SSRS reports: SQL Server Reporting
Services provides different types of reports that can be created using SSRS are
as below: Parameterized reports Linked reports Snapshot reports Cached reports Ad hoc reports Drilldown reports Drillthro...

Post has attachment
Differences between Temp Table and Table Variable
Differences between Temp Table and Table Variable : Temp Table: In SQL Server, temporary tables are
created at run-time and you can do all the operations which you can do on a
normal table. These tables are created inside Tempdb database. Based on the
scope...

Post has attachment
Differences between CTE and View
Differences between CTE and View CTE: CTE stands for Common Table expressions
can be thought of as a temporary result set that is defined within the
execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW
statement. A CTE is like a derive...

Post has attachment
SSRS date time expressions
Below are SSRS expressions which are used for date operations: -        If we want to show date parameters on SSRS
report for start date and end date and we want to show default value for start
date as current month’s start date and for End date parameter i...

Post has attachment
**
Below are SSRS expressions which are used for date operations: -        If we want to show date parameters on SSRS
report for start date and end date and we want to show default value for start
date as current month’s start date and for End date parameter i...

Post has attachment
Mostly used SSRS expressions in day-to-day report design - vol.2
Funny Videos: FB Fun4you Below are listed most useful SSRS epressions which are
used at the time of designing complex reports and dashboards in SSRS: Ø   To add comments with Field Value in SSRS
expressions = "Report
Executed By: " + User!UserID Ø     To ge...

Post has attachment
Important SQL logic
-->> Logic
to get date in AM/PM format and to get only HH:MM with AM/PM part from your
date     SELECT convert ( varchar ( 40 ), GetDate (), 9 ) SELECT substring ( convert ( varchar ( 20 ),   GetDate (), 9 ), 13 , 5 ) + ' ' + substring ( convert ( varchar (...

Post has shared content
What is page break in SSRS and how to use it?
https://youtu.be/4UJR5dTmscs

Post has attachment

Post has attachment
Wait while more posts are being loaded