For selecting converting var char to date. and replace with last date of the month of the date DECLARE @vdt nvarchar(MAX)=’2/2014′ –select CONVERT(date,’1/’+@vdt,103)…
Category: Sql Server
In below example case when used for multiple condition in sql server USE [PCCAS] GO /****** Object: StoredProcedure [dbo].[sp_rpt_Outreach_Adhoc_Report] Script Date: 05/21/2014 12:09:12…
=IIF((Fields!Audience.IsMissing) Or (Parameters!GroupBy.Value = “Audience”),true,false)
Dynamic grouping some time requires where grouping field can be send through parameter field , in below example there is groupby is parameter…
For hiding column in ssrs there is a feature of hidecolumn , in rdlc file. for dynamic fields are coming from stored procedure…
Below is the stored procedure of data maintenance sql server USE [PCCAS] GO /****** Object: StoredProcedure [dbo].[sp_DataMaintenance_Insert_Update] Script Date: 05/06/2014 11:14:44 ******/…
It is great feature where can when can be used in order by clause in sql server , below is the query where…
Lots of New feature has been introduced with sql server 20012, it is the latest version from Microsoft after sql server 2008 r2.…