MSBI (SSIS/SSRS/SSAS) Online Training

Friday, February 26, 2010

SSRS-***Basic Understanding about Reports***

Hi,
Rajoo Jha explained clearly about SSRS reports and types,Design techniques in his blogs.
Really awesome.
If you want to know full functionality about SSRS,You must Read it.
http://ssrstips.blogspot.com/search?updated-max=2009-07-10T01%3A04%3A00-07%3A00&max-results=7

Thursday, February 25, 2010

SSRS-Developing Report Navigation and Drilldown

Hi,
Here is the link to explain about Report navigation,drilldown,drill through options in SSRS report.
Really good stuff!!!!!
Cheers,
Rav's
http://msdn.microsoft.com/en-us/library/aa964132(SQL.90).aspx

Wednesday, February 17, 2010

BIDS and TFS


BIDS-TFS is a concept of configuration management.We have to maintain Source control to maintenance the code very clearly.
See the below link:
http://stevemchugh.blogspot.com/2007/10/bids-and-tfs.html

I Am Here




I would like to share my pic is here.
Thanks&Regards,


Rav's

Wednesday, February 10, 2010

SSRS-Examples

Hi All,
Here is the link for SSRS report details with examples.
Good Stuff.
Thanks Chris!!!!!!
Cheers,
Rav’s
LINK:-
http://blogs.msdn.com/ChrisHays/

Tuesday, February 9, 2010

***All BI Blogs Details***

Fellow SQLTeam.com Bloggers
· Tara Kizer (rss)
· Ajarn Mark (rss)
· Bill Graziano (rss)
· Brett Kaiser (rss)
· Chris Miller (rss)
· Damian Maclennan (rss)
· Dan Guzman (rss)
· David M (rss)
· Davide Mauri (rss)
· Denise M (rss)
· Derrick Leggett (rss)
· Dinakar Nethi (rss)
· Geoff N. Hiten (rss)
· James Nix (rss)
· Jeff Maass (rss)
· Jeff Smith (rss)
· Jen (rss)
· Joe Webb (rss)
· Jon Hermiz (rss)
· Mladen Prajdić (rss)
· Peter Larsson (rss)
· Phil Streiff (rss)
· Randy Aldrich Paulo (rss)
· Rob Volk (rss)
· Travis Laborde (rss)
Hardware Blogs
Microsoft Blog Roll
· Ben Tamblyn (rss)
· DataAllegro Blog (rss)
· Excel Team Blog (rss)
· Howard Morgenstern's Selling MSFTBI Blog (rss)
· MCP Communications (rss)
· Microsoft's Official BI Blog (rss)
· PerformancePoint Team (rss)
· Roger Wolter (rss)
· SQL BI Product Team Recruiting (rss)
· SQL CAT Team (rss)
· SQL Manageability Team (rss)
· SQL Server Policy Based Mgmt (rss)
· SQL Server Reporting Services Team (rss)
· Technet Plus Blog
· The Data Platform Insider (rss)
SQL Server BI Blog Roll
· Chris Webb (rss)
· Dan Meyers (rss)
· Jess Orosz SSAS (rss)
· Mosha Pasumansky (rss)
· Patrick Husting (rss)
· Teo Lachev (rss)
· Vidas Matelis SSAS (rss)
SQL Server Blog Roll
· Jamie Thomson SSIS
· Jason Massie (rss)
· The Scary DBA (rss)
· Vinod Kumar (rss)
Post Categories
· Business Intelligence Nuggets (rss)
· General (rss)
· SharePoint for BI (rss)
· SQL Server 2008 (rss)
· SQL Server 2008 R2 (including Gemini) (rss)

***SQL SERVER 2005-IMP QUERIES***

Update a table
=============
update cd
set cd.PrimaryContainerVolumeQty = pp.vol_per_physical_case,
cd.UnitsPerCaseQty = 1,
cd.UnitOfMeasure = 4
from #v_Source_ConversionData cd
inner join #OutletProducts pp on
cd.SalesProductID = pp.SalesProductID
and pp.VarietyPackIndicator = 'Y'
and pp.vol_per_physical_case != 0;
Duplicate Query
=============
SELECT DISTINCT l0_id ,COUNT(*) FROM
GROUP BY l0_id HAVING COUNT(l0_id) > 1

CASE Example
=============
select
case when manual_close = 'true' then 1 else
case when auto_close_without_est = 'false' then 2 else
case when auto_close_without_est = 'true' then 3 else 0 End
End
End
From
t_division

Usage Of Cursor
=============
--Script to automatically reindex all tables in a database
USE DatabaseName --Enter the name of the database you want to reindex
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
Nth Highest Salary
=============
SELECT TOP 1 division_id
FROM (
SELECT DISTINCT TOP 3 division_id
FROM t_division
ORDER BY division_id DESC) a
ORDER BY division_id


Date Functions
=============

1. select convert(varchar,datepart(yyyy,getdate())) + '-' + convert(varchar,datepart(mm,getdate())) + '-' + convert(varchar,datepart(dd,getdate()))
2. select datepart(yyyy,getdate()) as CYear,datepart(mm,getdate()) as CMonth,datepart(dd,getdate()) as CDate

3. select (MONTH(cast('Jan 01 2004' as datetime))) as YR
4. select (YEAR(cast('Jan 01 2004' as datetime))) as YR
5. select (DAY(cast('Jan 01 2004' as datetime))) as YR
Usage Of ROWNUMBER
=============

SELECT * FROM
(
select row_number() over( Partition By l0_id ORDER BY l0_id,row_ID) ROWNUMBER, l0_id,row_ID FROM local_hier.t_local_hier_edit
WHERE division_id=4 AND local_hier_id = 3 AND l0_id in ('-1','5415')
) A
where rownumber = 1







Data validation between Two tables with More JOINS
=============
/*Source */
select month,code, description,sum(sales) SourceSales
into #tempa
from sourcesales with (nolock) inner join
calendar_445 with (nolock)
sourcesales. daycode = calendar_445.day_key inner join
Sourcebot with (nolock)
on sourcesales.sourcebotcode= sourcebots.sourcebotcode
where month >=@monthid
and month <=@monthid
group by month,code, description
order by month,code, description

/*Olap*/

select month,code, description,
sum(sales) as PS ,sum(ucases) as US
into #tempb
from o_sales with (nolock) inner join
calendar_445 with (nolock)
on o_sales.dayid = calendar_445.day_id inner join
sourcebot with (nolock)
where month >=@monthid
and month <=@monthid
group by month,code, description
order by month,code, description
/*Temp Table Operation*/
select b.Month_id, b.sourcebotcd, b.description, b.PC, b.UC, a.SourceSales
,c.MonthlyPC, c.MonthlyUC
from #tempb b
join #tempc c
on b.Month_id= c.monthid
and b.sourcebotcd = c.sourcebotcd
left join #tempa a
on b.Month_id = a.Month_id
and b.sourcebotcd = a.sourcebotcd
order by 1,2

/*

Sql Server 2005-Basic SQL Stuff

Hi All,
Here you can find good example of sql statements for Cursor,Triggeres,Indexes,Joins,UNIONS,Highest salary ,Having,Group By Order By,COALESCE,NOT IN,Time ‘N’ Date Format Func,TEMP table Usage,CASE statements,Split Columns,Duplicate identification.
Really Very good Stuff.
Please go through thi.
Cheers,
Rav’s
http://sqlservercodebook.blogspot.com/2008_03_01_archive.html

Sql Server 2005-Types of Joins

First of all take a look on the names of different types of joins in SQL.
Here is the link to get more details.
http://programming.top54u.com/post/Joins-In-Sql-Server-2005.aspx


1. Inner Join
2. Outer Join
o Left Outer Join
o Right Outer Join
o Full Outer Join
3. Cross Join

Joins in SQL Server allows the retrieval of data records from one or more tables having some relation between them. Logical operators can also be used to drill down the number of records to get the desired output from sql join queries.

1. Inner Join: Inner Join is a default type join of SQL Server. It uses logical operators such as =, <, > to match the records in two tables. Inner Join includes equi join and natural joins. Examples:SQL Inner Join ExamplesSQL Inner Natural Join ExamplesSQL Inner Equi Join Examples
2. Outer Join: Outer Join has further 3 sub categories as left, right and full. Outer Join uses these category names as keywords that can be specified in the FROM clause.
o Left Outer Join: Left Outer Join returns all the rows from the table specified first in the Left Outer Join Clause. If in the left table any row has no matching record in the right side table then that row returns null column values for that particular tuple. Examples:SQL Left Outer Join Examples
o Right Outer Join: Right Outer Join is exactly the reverse method of Left Outer Join. It returns all the rows from right table and returns null values for the rows having no match in the left joined table. Examples:SQL Right Outer Join Examples
o Full Outer Join: Full outer join returns all the rows from both left and right joined tables. If there is any match missing from the left table then it returns null column values for left side table and if there is any match missing from right table then it returns null value columns for the right side table. Examples:SQL Full Outer Join Examples
3. Cross Join: Cross join works as a Cartesian product of rows for both left and right table. It combined each row of left table with all the rows of right table. Examples:SQL Cross Join Cartesian product Examples

Other SQL Join Examples:
Joins In Sql Server 2005
Joins using table aliases in SQL Server 2005
Self Join In Sql Server 2000 2005
· Related Articles
· • SQL Cross Join Cartesian product Examples
· • SQL Full Outer Join Examples
· • SQL Right Outer Join Examples
· • SQL Left Outer Join Examples
· • SQL Inner Join Examples
· Inside SQL Server 2005 SQL Tutorials
Here is the link to get more details.
http://programming.top54u.com/post/Joins-In-Sql-Server-2005.aspx