Lun

hello team,  there issue/conflicts/limitation n install ms sql server 2008 r2 enterprise edition on windows server 2008 r2 standard edition.  or nothing worry guess memory limitation between both of them. please suggest  regards naveed amir hi, here can find officially hardware , software requirements sql server 2008 r2: http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx there should no problem as know if basic limitation fit (as shanky mentioned). i had (an clients still have) several servers with  windows server 2008 r2 standard &  sql server 2008 r2 enterprise , standard no problem (today have 1 old developing server exact installations work great several years). [ personal site ] [ blog ] [ facebook ] SQL Server  >  Getting started with SQL Serv

hi there, i've seen odd while tyring handson table compression. on data compression wizard, see (after hit 'calculate' button): partitionno compressiontype boundary rowcount currentspace requestedcompressedspace 1               row                                   897          0.070 mb       0.109mb partitionno compressiontype boundary rowcount currentspace requestedcompressedspace 1               page                                  897          0.070 mb       0.109mb i dont see other large table of ~500gb in size tiny table looks strange. can explain please? thank you, jay there amount of space overhead sql server compression.  it uses few extents store metadata compression algorithm. SQL Server  >  SQL Server Database Engine

hi all, recently configured mirroring (high performance mode) in environment. issue : principal server database log file growing , we find the issue, it's  related mirroring .            mirror server failed that principal server database log file has grow , trying shrink log file but                  i have filed in situation . if mirror server failed effect on principal database transaction log file in sql server 2008 ? please me on above issue asap. thanks in advance.   ram hello  ram, please schedule transaction log backup @ frequent intervals database(even if in mirroring) so logs can truncated , might not grow such becomes huge transfer mirror server.you should schedule or take trn log backup database in full recovery manage transaction logs properly. also if there long running transaction logs might grow , have wait complete logs can truncated >> if mirror server failed effect on principal database transaction log file in sql server 2008

we encountering below error message when running child dts package within bigger master package.   system.reflection.targetinvocationexception: exception has been thrown target of invocation. ---> system.data.sqlclient.sqlexception: there insufficient system memory in resource pool 'default' run query.  data table-valued parameter "@sourceobject" doesn't conform table type of parameter.  statement has been terminated .     @ reldbextractorbucket1.scriptmainbucket1.main()     --- end of inner exception stack trace ---     @ system.runtimemethodhandle._invokemethodfast(object target, object[] arguments, signaturestruct& sig, methodattributes methodattributes, runtimetypehandle typeowner)     @ system.reflection.runtimemethodinfo.invoke(object obj, bindingflags invokeattr, binder binder, object[] parameters, cultureinfo culture, boolean skipvisibilitychecks)     @ system.reflection.runtimemethodinfo.invoke(object obj, bindingflags invokeattr, binder

hello all, i'm learing how use stored procedures... know how create them "create procedure..." syntax....  run query , creates successfully.  can run them "exec sp_name" , run find.... when cannot find them anywhere in object explorer.  raise question because delete , modify some.  i'm using sql server management studio express 2005 much appreciated!!!  thanks in advance, corey relax.....i'm new @ this. hello, you have created stored procedure database mydatabase, in query window have typed definition of stored procedure, have forgotten begin by use mydatabase go if case, find stored procedure among stored procedures of default database of user using connect sql server instance ( if have not defined default database, master database default database : right-click on master ==> stored procedures , should find stored procedure in "user" not system stored procedures of master database ) i have done error several times , each time had delete

hi, i have 2 columns in datagrid. 1 checkbox in each of them. have put same checked event both checkboxes. i wonder how possible know checkbox checked? possible in code below in somehow? <data:datagridtemplatecolumn header="one"> <data:datagridtemplatecolumn.celltemplate> <datatemplate> <stackpanel orientation="horizontal" horizontalalignment="center"> <checkbox checked="checked_event" /> </stackpanel> </datatemplate> </data:datagridtemplatecolumn.celltemplate> </data:datagridtemplatecolumn> <data:datagridtemplatecolumn header="two"> <data:

hi  i have searched around web trying find how take screenshot in silerlight applications. can find 1 saying silverlight not support screen capture can not find solution of how solve it.  are there out there know how capture screen in silverlight?  i have found 1 in other forum using web services via rendertargetbitmap stuff: http://social.msdn.microsoft.com/forums/en-us/wpf/thread/08d6b83b-e32a-4f31-9cfe-86b57cb23d42/  . have error saying calling thread must sta..... maybe i'm missing something, image needs accessible server , may not case if use localhost. another problem may image takes litlle while load. try file on server http://www.yourhost.com , give little time load before converting jpeg starting thread , converting after sleep.   tom   Silverlight  >  P

hi    seem have strange problem when applying snapshot when tables in publication have been updated while snapshot being generated.     example there table called rmareplaceditem in publication. when snapshot starts being applied subscriber, stored procedure called sp_msins_rmareplaceditem_msrepl_css gets created handles insert if row exists (ie updates row rather inserting it). however, after data has been loaded tables, instead of calling procedure, tries call 1 called sp_msins_rmareplacedite_msrepl_cssm - takes last letter of table name , adds end of procedure name.      worst part causes application of snapshot fail, doesnt report error is, , instead tries applying snapshot again. way have managed find call failing run profiler against subscriber while snapshot being applied , see errors.      have run sp_broswereplcmds , data in there applied subscriber - ie wrong procedure name.      servers involved running sql 2005 service pack 2. publisher , subscriber both u

hi 2 all, i switched wpf programming , don't know webservices. the application developing  needs posted webservice can setup program in 1 computer server , test computer (client) the wpf application finish it's window's application communicates webservice in local machine work, , build jan ctp 2007  . i grateful if provides me hint done thanks in advance sachit dahal       this forum wpf /e – cross platform subset of wpf .   please wpf forums wpf related questions.   joe Archived Forums SA-SM  >  Silverlight (formerly WPF/E) Developer Issues

all greetings! i have made simple game mix 10k smart coding challenge. look here - http://mix10k.visitmix.com/entry/details/202 description kernel panic game mad nuclear particles. reactor damaged , kernels pulled out outside. fortunately, have few time. should stop it! use platforms , small planets door achievement. 13 levels dodges, physics, funny interface - , in 10k. enjoy! if game has seemed attractive (taking account size in 10k) vote me please. thanks.   hi, cool game! it more helpful if description on what's use of yellow cricle , purple stick provided, figured out how play using 20 mins:(. if ui getting better, perfect. black bold "loser!" not good, saw lot:(   Silverlight  >  Game Development with Silverlight

hi guys, quick thing there way indicate script want sqlcmd enabled or not automatically when open script? i think there maybe global setting affects (there ssms) having either smart turning on (by parsing file , detecting appropriate tokens) or indicating somehow in file properties given file should sqlcmd enabled great if there isn't way it. hi brett thanks writing in. there's not way automatically @ moment, did hear (and others) feedback loud , clear have room improvement around sqlcmd. i've got feature address in ssdt backlog consideration in future release. also, if file bug on microsoft connect , lots of votes, cause.   cheers, -sam SQL Server  >  SQL Server Data Tools

hi,   in working existing package adding derived column  date , datatype dt_dbtimestamp , destination data type datetime. when try union these records through "union all" component not allowing me map column , throws error "outputcolumnlineageid " , defines error metadata source , destination not matching. i checked metadata , dt_dbtimestamp, missing something? please advice.   thanks.   my destination table has "datetime" data type. derived column set dt_dbtimestamp.   i recreated "union all" component , issue fixed. dont know real issue.   SQL Server  >  SQL Server Integration Services

hi all, i experienced sql server 2014 standard has high cpu usage(around 35%) when idle status. i using sql server 2014 on aws ec2 c3.8xlarge(32 cores vcpu) instance with microsoft windows server 2012 r2 sql server standard. after launched instance, didn't touch on instance. means instance initial-state , idle status. i tested on other instance types. for i2.8xlarge, cr1.8xlarge has 32 cores vcpu, cpu usage same(around 35%). but c3.4xlarge, i2.4xlarge has 16 cores vcpu, cpu usage around 5%. anyone knows reason why virtual server 32 vcpu cores has high cpu usage? hello, that instance has sql server 2014 no updates installed. please apply cu2 sql server 2014 or request update instance, since cu2 has fix related high cpu usage. the update can obtained following link: http://support.microsoft.com/kb/2967546/en-us hope helps. regards, alberto morillo sqlcoffee.com

im using silverlight2 call wcf while exception below thrown , i've no idea now. kind me please? system.servicemodel.communicationexception unhandled user code   message="the remote server returned error: notfound"   stacktrace:        @ system.servicemodel.asyncresult.end[tasyncresult](iasyncresult result)        @ system.servicemodel.channels.servicechannel.sendasyncresult.end(sendasyncresult result)        @ system.servicemodel.channels.servicechannel.endcall(string action, object[] outs, iasyncresult result)        @ system.servicemodel.clientbase`1.channelbase`1.endinvoke(string methodname, object[] args, iasyncresult result)        @ wakan.info.browser.wakanservice.wakaninfoserviceclient.wakaninfoserviceclientchannel.endgetuseridbyusername(iasyncresult result)        @ wakan.info.browser.wakanservice.wakaninfoserviceclient.wakan.info.browser.wakanservice.iwakaninfoservice.endgetuseridbyusername(iasyncresult result)        @ wakan.info.brows

i know dbcc shrinkfile logged operation..when did shrink operation on production server same thing not getting replicated dr space not getting released on dr server log shipped database norecovery option . whereas if restore 1 of log backup using standby option instead of norecovery option manually the space got released in dr server too. please let me know internal reason this?  appreciate help. prbhakaran, kindly refer following msdn post in detailed information prvoided following issue . http://social.msdn.microsoft.com/forums/en-us/sqldatabasemirroring/thread/61f95ed6-26fc-4d4a-9e67-a90dd65ca545 refer following link : http://support.microsoft.com/default.aspx?kbid=937531 : "the shrink operation not duplicated on mirror database when use database mirroring in sql server 2005" . -------------------------------------- thanks,suhas v SQL Server

i have copied sftptask100.dll c:\program files (x86)\microsoft sql server\100\dts\tasks in order install sftp in control flow in ssis. but dont know how register in gac. please advice. thanks clearifying step #3  when draging & dropping, must have 2 seperate explorer windows. drag 1 explorer window , drop 2nd explorer window's c:\windows\assembly.  mcts, mcitp - please mark posts answered appropriate. SQL Server  >  SQL Server Integration Services

i know investigation pretty light appears dmo works fine against sql 2005 (we use same code generate script against sql 2005 server sql 2000 server). why prevent query analyzer being able use same dmo works on sql 2005. i miss simple ways of using query analyzer have become accustomed , love able keep in toolbox foruse both databases. also why (when using query analyzer search, 1 of best features miss) prompt install stored procedure , not work anyway ?sp_msobjectsearch?. hi jb, you've covered number of areas post if don't mind, i'd decompose form give answers: the answer first question dmo work 'fine' against sql server 2005 if want or need expected 5 + years ago. there quite few features have been developed , released sql server 2005 , clear dmo had limitations. 'disabled' things create problems when dmo encountered them. light investigation did indeed prove correct. work. once need use newer features of sql  server 2005 -- instance schemas not

i have upgraded tfs 2012 update 1 tfs 2012 update 3.  had similar issue had previous upgrade psbridge isapi filter not loaded.  around deleted psbridge filter list.  wondering if causing other issues , correct solution going forward seems come back. tfs 2012 update 3 installed on windows server 2008 r2 service pack 1 running iis 7. this issue event viewer: log name:      application source:        microsoft-windows-iis-w3svc-wp date:          8/16/2013 10:31:29 am event id:      2274 task category: none level:         error keywords:      classic user:          n/a computer:      vbmprweb289.cbn.local description: isapi filter 'c:\inetpub\wwwroot\lms\psiisbridge.dll' not loaded due configuration problem. current configuration supports loading images built amd64 processor architecture. data field contains error number. learn more issue, including how troubleshooting kind of processor architecture mismatch error, see http://go.microsoft.com/fwlink/?

hi is there way use dateadd() equivalent function calculate data previous weeks? thanks! think got issue (though still not sure on calculation should havent explained end result should be). the issue why tam 4 semanas comes blank because measure, , min(new date column) first date, , might not have value it. either need make calculated column (and guess can remove min() , put date) or use iterative function sumx in measure. =sumx(fechas, calculate([qty facturada];datesbetween(fechas[pk_fecha];today();min(fechas[semanaactualmenos4calc])))) please note dont know how calculation should be, , unless tell me of sample data, show how calculation works, , show end results also, cant give better answer. cheers, jason | www.sqljason.com p.s. : please click 'mark answer' button if post solves problem! :) SQL Server  > 

sql server 2008 r2 sp1 fails install in 2 of boxes error: title: sql server setup failure. ------------------------------ sql server setup has encountered following error: failure detected previous installation, patch, or repair during configuration features [sql_dts_full,sql_ssms_full,sql_ssms_adv,sql_powershell_tools_ans,]. in order apply patch package (kb968369), must resolve issues previous operation failed. view summary.txt log determine why previous operation failed. error code 0x84b20001. ------------------------------ buttons: ok ------------------------------ same happened last update ( http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/322b844b-8d4a-468c-9edb-7b00f6e6dfd2 ) and not able solve because repair fails. is impossible around this? if so, how can uninstall , re-install without loosing every setting of logins, jobs, databases, etc.?       paulo morgado seems bug per connect: http://connect.microsoft.

hi all i have 2 cluster enviroments sql server 2005 windows 2003 sp2 (one rtm other sp3) and publishing data same data both environments. sp3 enviroment  taking  almost 5 hours publish rtm taking 5 min. select top 10* sys.dm_os_wait_stats  order wait_time_ms desc  lazywriter_sleep 98561 90027656 12093 343 sqltrace_buffer_flush 20521 82089640 11734 31 writelog 4326952 64938546 100296 390359 cxpacket 653404 6995875 72000 309718 sqltrace_lock 9833 6580546 1015 171 sos_scheduler_yield 64365507 2995453 31562 2973515 backupio 498436 2418750 2453 828 async_io_completion 25 1761562 857187 0 backupbuffer 33242 1732718 2046 15375 oledb 15024836 1498859 3484 0 please me how find how causng bad performance,   thanks in advance     snivas have tried running profiler while pushling data?  may give suggestions performance modific

i'm trying figure out last piece of long puzzle , have run wall.  have ftp task copy files a source location local server.  files processed , entered db.  need script or method of preventing same files being copied , causing duplicate entries in db.  have ability move the local files into directory cannot move files on the source machine.  there can configure move local files directory once entered db, then, every time project run, compare files in source directory against local files , not copy files exist? for first part u should send processed files archive folder. nest need use script task call ftp service. before ftping files have check in source location & archive location verify file not duplicate. option have in script task check time modified files. if greater last execution time can pick files, no need of comparison. script ftp check link: http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/2b7cf6b5-d16d-44cd-954d-68e9ba98ee91/ ssis

hi,   i have biztalk solution receives xml messages emails translated them different format , adds sql 2005 table using sql server adapter in bts2006. bts2006 , sql works on different servers connected 1mb vpn. sql server adapter uses ms dtc add translated data sql2005. during normal situation when adds 20-30 messages per minute ok. but when e.g. bts stopped night , has add many messages, adds 10-15 per second. last 1-2h. in same time impossible query database messages. takes long time, although sql server busy (procesor utilisation 5-10%). query uses many records because makes grouping, min, max, etc, operations. simple queries selecting few record id between 2 values works normally. what's going on? ma there many locks? how check , improve it?   thanks, przemo SQL Server  > 

hi, i haven't work on situation this.suppose front end browsing excel file containing data.now, want send excel document attachment recipients backend.right now,i sending mail this exec msdb.dbo.sp_send_dbmail     @profile_name = 'emailsbounced',     @recipients    = @emaillist,     @subject    = 'topup request',     @body        =  @body,     @importance='high',     @body_format='html'   what various ways can use. thanks , regards, rishabh hi, i got solution can use @file_attachments option send document attachment thanks , regards, rishabh SQL Server  >  SQL Server Database Engine

for query several join , sort, in last set (right before sort), sql server makes bad estimation rows sorted, should 10m, sql server estimates there 100k sorted. memory grant low cause data spill temp db. solution let sql server allocate larger memory sort? hi daniel, what can not possible allocate larger memory sorting. 1 thing should need check why estimating wrong number of row? (looking on number of rows 10m) can't gurantee sorted out in memory, tempdb used sorting purposes.   regards gursethi blog: http://ms-gursethi.blogspot.com/ ++++ please mark "propose answer" if answer helped ++++ SQL Server  >  SQL Server Database Engine

i receive following error trying install beta 3 refresh as a single-server deployment: "windows sharepoint services sp2 or later prerequisite product. must first install latest windows sharepoint services 2.0 service pack before install product." i'm pretty sure i'm following setup instructions , sharepoint services 2.0 sp2 installed. can bring sharepoint administration site , looks has when i've installed tfs beta 3. see there multiple sharepoint iis application pools (currently stsadminapppool_2) presumably resulting several install/uninstall cycles sharepoint recognized. this clean server when started. server windows server 2003 standard edition sp1 in vmware virtual machine. it running in windows nt domain, not ad domain. installed september ctp sql server 2005 standard edition, realized rtm version available. uninstalled ctp sql server , installed rtm standard edition before proceeding sharepoint setup. i've tried sharepoint setup instructions found in th

when using expression y value in graph in ssrs, can choose "fields (dataset1)" category, can ex: avg(fields!amount.value).  but how choose fields data set (dataset2)?  formula avg(fields!amount.value, "dataset2") no good, returns single value average entire dataset. thanks. the data must have  some relationship, example time.  if creating series department, join 2 on time.  common scenario , require full outer join, like select * ( select department, month, amount sometable department = 'sales') salestb full outer join (select department, month, amount sometable department = 'accounting') accountingtb on salestb.month = accountingtb.month patrick's point of joining data in source query best practice , efficient way go addressing problem. hope makes more sense, mark   SQL Server  > 

 hi, i use 2 web services in silverlight application, webmethod return  same entity type, but must refer method result using ws1.someclass or ws2.someclass how use 1 class type  refer them? hi,    maybe looking for.    http://stackoverflow.com/questions/889621/adding-service-references-to-multiple-wcf-services-that-shared-classes    one.    http://forums.silverlight.net/forums/t/58943.aspx best regards Silverlight  >  Accessing Web Services with Silverlight

i have mining structure 50 million clicks , 23 inputs , 1 predictable output. trying build naive bayes model that.    after processing gives me error on 3 of attributes, asking me increase maximum_output_attributes.   i once made mas 65535(which though not case), still gives same error. can me find out why.   thanks load error maximum_attributes or maximum_input_states? default maximum number of distinct states taken account naive bayes 100. try setting maximum_input_states 0 bogdan crivat [sql server data mining] / http://www.bogdancrivat.net/dm SQL Server  >  Data Mining

when going through data source configuration wizard having problem. when wizard asks "which database object u want in database error an error occurred while retrieving information databse: failed retrieve data request. could not continue scan nolock due data movement can me error im doing throught tutorials came express edition download , stuck @ point. have done vb6 , want refresh self diffrences in express? oj did not use nolock query. not know is. vb express trying add data source project , getting stuck. downloaded sql sp1 , after installed program went through steps. did install patch. anyway working SQL Server  >  SQL Server Database Engine

why microsofts documentation poor? first - accept criticism. try. still difficult write content easy enough beginners understand, , technical enough experts fine tune database systems. if ask question, perhaps of understanding of documentation can point towards useful. that's 1 of purposes of msdn forums. contributors forum glad help. rick byham. writer sql server books online. ( rick.byham@microsoft.com ) rick byham, microsoft, sql server books online, implies no warranty SQL Server  >  Getting started with SQL Server

  hii all,can 1 me information.   i using sql server 2000 , want know:   1- names of servers   2- all database names (catalogs) @ specific server and only user created .    3- user name , password each server.     thanks. can define requirements bit better this?  can enumerate available instances number of ways.   http://www.sqlteam.com/article/finding-sql-servers-running-on-a-network   to database names on servers however, have have user account , password server.   number 3 provide, unless form of brute force attacking of own servers knowledge.   SQL Server  >  SQL Server Data Access

i downloaded , installed sql server 2005 express onto file server.  trying figure out how start express in order create new database , tables.   in sql server 2000 used enterprise manager work there no equivalent can find.   how start sql server 2005 express?  name of program allow me start express , create databases, tables, stored procedures, etc?   thank you. it's reasonably important distinction know sql express started , running on computer. installed windows service starts everytime turn on computer. 2005 equivalent enterprise manager management studio, , there express version available can use create databases. can download http://www.microsoft.com/express ; follow links sql server download pages.   regards, mike   SQL Server  >  SQL Server Express

  hi, outputname :rsresult  under outputcolums: customerid territoryid accountnumber customertype and have mention errors in red color     idtsvariable100 vars; variabledispenser.lockoneforread("rsresult", vars);  // rsresult output name here iam getting error object rs = vars(0).values;   //here getting error system.data.oledb.oledbdataadapter olead = new system.data.oledb.oledbdataadapter(); system.data.datatable dt = new system.data.datatable(); //system.data.datarow row; olead.fill(dt, rs); foreach (datarow row in dt.rows) { {   rsresultbuffer.addrow(); rsresultbuffer.customerid = (int)row["customerid"]; rsresultbuffer.territoryid = (int)row["territoryid"]; rsresultbuffer.accountnumber = row["accountnumber"].tostring(); rsresultbuffer.customertype = row["customertype"].tostring(); } rsresultbuffer.setendofrowset(); }   the errors   error 1 best overloaded method match '

 hi in starting there 1 test.aspx page , example if our application need 10 forms create them user control i.e 10 xaml silverlight user control , on loading user controls loaded means if there 10 grids in 10 controls data fill in 10 grids show first silverlight page. it takes time in loading , another problem if save data in 1 xaml page , show in other xaml page dropdown without page refresh can't see data in other page's dropdown because controls preloaded , make them visibility none or  collapsed. try solution take 1 aspx page 1 xaml page having tab control, on click of 1 tab item , navigate aspx page contains other xaml page , on. so in starting 1 page loading , other problem of data fetching solve. so problem how can create new aspx page contains other xaml page because xap contains data 1 aspx page there on app.xaml file contains starting root 1 page.  please tell me solution or if there solution, pls. tell me.   hello, ajax, silverlight'

if query  is running long time  to excute how  to  resolve?  hi venkat, there many reasons why query running long time, might normal. before answer questions, please tell query , how environment such cpu , ram utilization. the following articles may helpful you, see: troubleshooting performance problems in sql server 2005 . regards, chunsong please remember mark replies answers if , unmark them if provide no help. SQL Server  >  SQL Server Database Engine

hi,               null funtions in ssis expression(conditional split)?how can use that? it returns null value of requested data type: http://msdn.microsoft.com/en-us/library/ms141758.aspx i think wont use in conditional split, more in derived column. example return null value instead of empty string: [mycolumn] == "" ? null(dt_str, 10, 1252) : [mycolumn] in conditional split use isnull expression: http://msdn.microsoft.com/en-us/library/ms141184.aspx please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter SQL Server  >  SQL Server Integration Services

hi, a user trying create subscriptions gets error: permissions granted user insufficient rsaccessdenied. how can grant permissions user subscriptions?   thanks under site setting in reports manager >configure system-level role definitions > check executereport defination option create system usergroup, give access group @ connect reporting services data base in server properties , add group , permite access system user.     go site setting     click on "configure site-wide security"     click "new role assignment" button in top bar     give new role following name "everyone" of available roles, grant "system user"     click "apply" SQL Server  >  SQL Server Reporting Services, Power View

  hi,   my current client has application running on sql server 2000. have plans upgrade sql 2005, not yet. sometimes during normal operation (sales reps using app) tables locked long period of time. time we notice there problem, lock released and we miss chance identify source of problem.   is there way keep eye on database's activity , generate kind of alarm if lock on table takes long released?   i've been considering creating c# application monitor table locks. recommend me start?   thanks in advance. hello,   i found these 2  links http://msdn.microsoft.com/en-us/library/aa213025(sql.80).aspx http://msdn.microsoft.com/en-us/library/aa260422(sql.80).aspx   i never used sp_lock i'm unable more efficiently.   in case, if want more explanations how use sp_lock in vc#, try available ( problem have given msde , sql server 2000 instant when sql server 2005 available ) which version of vc# have you ( 2003,2005,2008 ) ? i prefer 2005 or

i've parent-child relation want cell value sum of children if cell value of parent given don't operate calculation. so i've defined customrollupcolumn on parent forumla: iif(isempty(([typehierarchy].[type].[3],[measures].[value])),([typehierarchy].[type].[1],[measures].[value])+([typehierarchy].[type].[2],[measures].[value]),([typehierarchy].[type].[3],[measures].[value])) where [typehierarchy].[type].[3] parent of [1] , [2]. it works when want aggregate on dimension i've big issues. just having following table: (id, type, date, value) 1 1 13/12/2006 0:00:00 101 2 2 12/12/2006 0:00:00 201 3 1 13/12/2006 0:00:00 102 4 1 13/12/2006 0:00:00 103 6 3 14/12/2006 0:00:00 87 7 1 14/12/2006 0:00:00 9 8 2 13/12/2006 0:00:00 1000 9 1 15/12/2006 0:00:00 401 10 2 15/12/2006 0:00:00 402 11 3 15/12/2006 0:00:00 403 when browse cube i've right results except total on dates wher type 3 i've 490 hoped have 1997 (201+1306+87+430). unfortunatelly sass doesn't sum 2 first colu

hi, im using twilight theme user control. have datagrid in contains 4 columns. 3 columns datagridtextcolumn , datagridtempplatecolumn. template column contains checkboxes. want keep check in header of templatecheckbox column selectall/uncheckall provision.  i created datagridcustom header style show checkbox. problem is, im loosing twlight datagrid header style. can 1 provideme twilight datagrid headerstyle . tried in source code. no luck. please provide twlight background , rounded on top of control.   hi , i able solve problem . here style datagrid header twilight theme. < style targettype ="prim:datagridcolumnheader" x : key ="customheader"> <!--<setter property="foreground" value="#ff000000" />--> < setter property ="istabstop" value ="false" />