FIND OBJECTS BEING REFERRED BY SSRS REPORT
Hi Everyone
In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...
2016-04-07
1,143 reads
EVERYDAY MSBI/SQL CHALLENGES
SOME BUGS IN SQL-SSRS 2005
Hi Guys
I know sql 2005 is getting outdated and there would be no support from Microsoft from this month. But lets not...
2016-04-01
387 reads
Handling decimal and non numeric types using Case statement
Hi Guys
Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...
2015-10-14 (first published: 2015-10-06)
3,431 reads
syntax error in textheader of stored procedure - Cause and Solution
Hi Folks,
Comments play an important part in writing any code. Especially when somebody else reads your code. So the other...
2015-08-30
1,266 reads
2015-04-26
Data Rendering Eye Opener SSRS
Hi Folks
Greetings to everyone!!!
So last week one of the report was having a performance issue. It had 10 datasets ,5...
2015-04-22 (first published: 2015-04-12)
6,347 reads
Toggle Functionality Looses In excel--ssrs 2005
Hi Folks
Highlighting on the issue that I faced last week while working on reporting services 2005.
Requirement :- A data region (table)...
2015-04-03
626 reads
Date Range Challenge in sql
Hi Folks,
When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...
2015-03-15
494 reads
CTE - Limitations
Hi
Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if...
2014-07-27
1,428 reads
Bug In ado.net enumerator in foreach loop in SSIS 2012
Hi Greetings to everyone,
Today I am going to report a bug in SSIS 2012. In one of the packages I...
2014-07-27
971 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
identify consecutive records greater than 1
Hello I need help identifying all records that have consecutive hours (time in order)...
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers