JUJUBI_JULABI Posted December 27, 2012 Report Posted December 27, 2012 [quote name='Kaarthikeya' timestamp='1356542595' post='1303015960'] SSAS lo MDX queries raasava eppudaina? or else just tool use chesava? [/quote] yeah rasina queries kuda ..
deals2buy Posted December 27, 2012 Report Posted December 27, 2012 [quote name='JUJUBI_JULABI' timestamp='1356618883' post='1303020237'] yeah rasina queries kuda .. [/quote] aa experiences koddiga share chesukovachu kadaa..naa lanti freshers ki upayogapadutundi
Darling999 Posted December 27, 2012 Report Posted December 27, 2012 hey monna 2012 sql server installatio procedure post esaaru kada adi ey page lo undi konchem link eyyara plz
deals2buy Posted December 27, 2012 Report Posted December 27, 2012 [quote name='DARLING...' timestamp='1356624408' post='1303020598'] hey monna 2012 sql server installatio procedure post esaaru kada adi ey page lo undi konchem link eyyara plz [/quote] search lo kanipisthaledu
Darling999 Posted December 27, 2012 Report Posted December 27, 2012 [quote name='Kaarthikeya' timestamp='1356624834' post='1303020638'] search lo kanipisthaledu [/quote] ey nuvvu deals to by aah
Darling999 Posted December 27, 2012 Report Posted December 27, 2012 [quote name='Kaarthikeya' timestamp='1356624834' post='1303020638'] search lo kanipisthaledu [/quote] me also searching rey no finding
Darling999 Posted December 27, 2012 Report Posted December 27, 2012 SQL Server 2012 Download Link [url="http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx"]http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx[/url]
deals2buy Posted December 27, 2012 Report Posted December 27, 2012 [quote name='DARLING...' timestamp='1356625267' post='1303020672'] ey nuvvu deals to by aah [/quote] [color=#282828][font=helvetica, arial, sans-serif][img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img][/font][/color]
deals2buy Posted December 27, 2012 Report Posted December 27, 2012 [b] Introduction to Rollup Clause[/b] ROLLUP clause is used to do aggregate operation on multiple levels in hierarchy. Let us understand how it works by using an example. Consider a table with the following structure and data: [CODE] CREATE TABLE tblPopulation ( Country VARCHAR(100), [State] VARCHAR(100), City VARCHAR(100), [Population (in Millions)] INT ) GO INSERT INTO tblPopulation VALUES('India', 'Delhi','East Delhi',9 ) INSERT INTO tblPopulation VALUES('India', 'Delhi','South Delhi',8 ) INSERT INTO tblPopulation VALUES('India', 'Delhi','North Delhi',5.5) INSERT INTO tblPopulation VALUES('India', 'Delhi','West Delhi',7.5) INSERT INTO tblPopulation VALUES('India', 'Karnataka','Bangalore',9.5) INSERT INTO tblPopulation VALUES('India', 'Karnataka','Belur',2.5) INSERT INTO tblPopulation VALUES('India', 'Karnataka','Manipal',1.5) INSERT INTO tblPopulation VALUES('India', 'Maharastra','Mumbai',30) INSERT INTO tblPopulation VALUES('India', 'Maharastra','Pune',20) INSERT INTO tblPopulation VALUES('India', 'Maharastra','Nagpur',11 ) INSERT INTO tblPopulation VALUES('India', 'Maharastra','Nashik',6.5) GO [/CODE] [img]http://www.pinaldave.com/bimg/rollup1.jpg[/img] Now, we need to create a report on population at 3 levels: City, State and Country. Can we do it by using SUM with GROUP BY clause? Yes, we can, but we will have to write a separate query to GROUP BY at each level and then union the result of all queries; even after this, the proper ordering or the result would still need more work. However, SQL Server provides a very easy solution. Just add the WITH ROLLUP clause in GROUP BY and you get the desired results. [CODE] -- For SQL Server 2005 SELECT Country,[State],City, SUM ([Population (in Millions)]) AS [Population (in Millions)] FROM tblPopulation GROUP BY Country,[State],City WITH ROLLUP -- For SQL Server 2008 SELECT Country,[State],City, SUM ([Population (in Millions)]) AS [Population (in Millions)] FROM tblPopulation GROUP BY ROLLUP (Country,[State],City) [/CODE] [img]http://www.pinaldave.com/bimg/rollup2.jpg[/img]
buffaloboy Posted December 27, 2012 Report Posted December 27, 2012 hello all... mee real time experiences share chesukondi pls...i mean real time lo as a dba what we need to check on daily basis and how the routine work will be...prathi roju meeru chese tasks endi as a dba..pls cheppandi...dba ga job chestunna nenu...gatha 6 months nundi..pls help...
buffaloboy Posted December 27, 2012 Report Posted December 27, 2012 [quote name='buffaloboy' timestamp='1356646979' post='1303023290'] hello all... mee real time experiences share chesukondi pls...i mean real time lo as a dba what we need to check on daily basis and how the routine work will be...prathi roju meeru chese tasks endi as a dba..pls cheppandi...[size=6]dba ga job chestunna nenu[/size]...gatha 6 months nundi..pls help... [/quote] printing mistake.. dba ga job try chestunna
mtkr Posted December 27, 2012 Report Posted December 27, 2012 mastaaruus... evaraina external sources(files like flat, excel, xml) files nundi oracle ki data load chesara through SSIS.. nen trying to load xml file into oracle db thr SSIS... matter entante oka execute sql task and daani kinda oka DFT ....n nxt vere konni unnai... execute sql task fail avutundhiiii.... n danni disable chesthe DFT lo anta baane nadustundhii.. aa execute sql task lo oka query undhii n andi oka condition satisfy chesukoni nxt step ki potundhiii.... Result set:: SINGLE ROW Sql Stmt::: select count(*) as found from tbl1 where column = ? Parameter Mapping::: variable1 result set::: found--- varfound ee execute sql task ki DFT ki madhyalo exprssion varfound > 0 so adi >0 avuthene nxt step ki pothadi..... but adi fail avutundhii... n error iz::: An error occurred while assigning a value to variable "The type of the value being assigned to variable differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
chelsea Posted December 27, 2012 Report Posted December 27, 2012 [quote name='mtkr' timestamp='1356649792' post='1303023557'] mastaaruus... evaraina external sources(files like flat, excel, xml) files nundi oracle ki data load chesara through SSIS.. nen trying to load xml file into oracle db thr SSIS... matter entante oka execute sql task and daani kinda oka DFT ....n nxt vere konni unnai... execute sql task fail avutundhiiii.... n danni disable chesthe DFT lo anta baane nadustundhii.. aa execute sql task lo oka query undhii n andi oka condition satisfy chesukoni nxt step ki potundhiii.... Result set:: SINGLE ROW Sql Stmt::: select count(*) as found from tbl1 where column = ? Parameter Mapping::: variable1 result set::: found--- varfound ee execute sql task ki DFT ki madhyalo exprssion varfound > 0 so adi >0 avuthene nxt step ki pothadi..... but adi fail avutundhii... n error iz::: An error occurred while assigning a value to variable "The type of the value being assigned to variable differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. [/quote] data type emi assign chesavu ba variable ki
mtkr Posted December 27, 2012 Report Posted December 27, 2012 [quote name='chelsea' timestamp='1356651814' post='1303023690'] data type emi assign chesavu ba variable ki [/quote] INT32
Recommended Posts