Lun

hi in mya pplication im trying getquery coming table ,i don't know how it.below tables create table [dbo].[r2inventorytable]( [productid] [int] identity(1,1) not null, [productname] [nvarchar](50) null, [productdesc] [nvarchar](max) null, [phcode] [nvarchar](max) null, [pmno] [nvarchar](max) null, [plineno] [varchar](50) null, [relayrack] [varchar](50) null, [sno] [varchar](50) null, [assettagno] [varchar](50) null, constraint [pk_r2inventorytable] primary key clustered ( [productid] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] go set ansi_padding off select r.pmno,r.productdesc,r.productname r2inventorytable r output modelno productdesc productname 4             testing1 desc        testing1 4       ...

my pc installed vs2010, silverlight 4. then update silverlight 5 silverlight_developer_x64 ver. 5.1.10411.0 please me how fix error. everybody! email: tin_pt@live.com follow below thread: http://stackoverflow.com/questions/6246475/could-not-load-file-or-assembly-system-windows-version-2-0-5-0 http://stackoverflow.com/questions/7548780/system-windows-interactivity-could-not-load-file-or-assembly-system-windows-v Silverlight  >  Silverlight 5

windows server 2012 r2 microsoft sql server 2012 - 11.0.5058.0 (x64) sql server  reporting services - sharepoint integrated mode  hi, we hare several reports running slower on windows server machine, opposed  a developer's workstation (e.g.  windows 7). we've narrowed down slowness  the  setexecutionparameters service method. according  to  the sharepoint trace log, takes  about 10-11 seconds on windows server machine, whereas 3-4 seconds on win 7 machine.  according  to msdn, method " sets , validates parameter values associated current report execution." https://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.setexecutionparameters(v=sql.110).aspx any idea on how can more information on service method? how can determine why slow on server 2012? reports in question have boatload of parameters (100+). we've tested  with  all  the components on ...

i have degenerated dimension field ( transaction id : aui18790) varchar field. i trying create drill thru action in  cube, if user click dimension atribute.. should list of transactionids... how can this?  since varchar field?? ls,   this have do: 1. create dimension transactionid, other dimension, time based on fact -table in stored. 2. add dimension cube, other dimension, , associate related measuregroup (= 1 based on facttable step 1.) 3. becasue it's degenerate dimension,  change relationship type regular fact. 4. create drillthorugh action on related measuregroup , add (degenerate) dimension transactionid drillthrough columns. that should it.   good luck. cees SQL Server  >  SQL Server Analysis Services ...

hi, we upgraded our tfs server 2013 2015. issue: in change request form few fields displaying error: cannot create work item control of type "multivaluecontrol". any suggestions? thanks, sai hi sai,    thanks post. it seems control custom work item control, please confirm in tfs server. this issue happened when open in vs 2015? or both web access , vs 2015? if open tfs 2015 change request using vs 2013, what’s result? for custom work item control, ensure still can works in tfs 2015 server, maybe need use 2015 version of custom control or redeploy in tfs 2015 server. if downloaded multivalue control here , deployed in tfs 2015/vs 2015, still cannot works in tfs 2015 environment, can create new issue in download site’s issues tab better response. we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here p...

  did 1 come across such kind of error in ssis   error in processing. server response was: 4.7.0 timeout waiting client input" if please let me know how deal problem some of posts says solved increasing timout property, not find such kind of property ... plz help thanks in advance  where happen? can set time out property on connection (connection string) or iirw on command (start reading data sql server) best regards, uri dimant sql server mvp http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ SQL Server  >  SQL Server Integration Services

i have package has both oracle , sql server connection manger... i can execute package , debug in business inteligent studio.. if run package job: i keep getting error:"ora-01017: invalid username/password; logon denied  ".   i 've checked "save password" in oracle connection manager...   how can save password , run sql server agent job? 1.) use oracle login inside ssis package in oracle connection manager or 2.) give necessary privilege sql startup account in oracle server, if job scheduled in sql server. SQL Server  >  SQL Server Integration Services

i have lot of folders under c:\....\temporary asp.net files\reportserver. of them created/modified/accessed 1-2-3 years ago. seem useless. can remove them clean space? hi rufus4, when asp .net loads report server application first time, it will cache compiled files found in \reporting services\reportserver\bin folder , copy cache the \temporary asp.net files\reportserver folder. that way, cached compiled resources makes respond efficiently to the subsequent requests same page. theoretically, folder doesn't need maintenance, under rare situation, may need clear contents of its subfolder. so, doesn't matter if remove old files \temporary asp.net files\reportserver folder. reference: understanding asp.net dynamic compilation regards, mike yin mike yin technet community support SQL Server  >...

hi all, i need quite urgent you. have uploaded files in document set. files present in below path http://server-name/sites/sitename/doc-lib-name/doc-set-name/ file1.docx  similarly file2.docx, file3.docx etc., some of file extension wrongly uploaded "file4.docx -01 ". here "-01" wrongly appended file extension. need remove using client object model. im able retrieve folder(doc-set-name) if try reupload file, gives error system.io access error . below code im using.. please me rename file. in advance.. code: foreach (microsoft.sharepoint.client.file f in defaultdocumentfiles) { litem = f.listitemallfields;  fci = new filecreationinformation(); using (system.io.filestream fs = new system.io.filestream("https://server.com/sites/sitename/style%20library/publishnewinfotemplate/template.txt", system.io.filemode.open)) {  byte[] imagedata = new byte[fs.length]; fs.read(imagedata, 0, system.convert.toint32(fs.l...

 hello , can let me know , how can use expression encoder 3 live iis smooth streaming . i not able find article or online regarding . . i have created publishing point iis7 web server   . livesmoothstream.isml how can expression encoder 3 after creating publishing point. or  do need encoder contents first *.ism  , different profile , use command  "pushencoder32 <url-of-publishingpoint> <ism-file> "  . if yes , expression encoder 3 helps in live encoding . hi, do need encoder contents first *.ism  , different profile , use command  "pushencoder32 <url-of-publishingpoint> <ism-file> "  . if yes , expression encoder 3 helps in live encoding . like said, live smooth streaming playing encoded files, not directly broadcasting live video stream. for expression product questions, may post @ expressions forums, http://social.expression.microsoft.com/fo...

we have started playing around ts, , have questions around best practices bug , requirement tracking in our environment. we add functionality our product on project project basis, there may defects or requirement requests not completed in praticular project.  best way track these.  can move them project project?  may example make easier understand. our product named widget.  have project add features, , create widget 2.0.  after widget 2.0 project have widget 3.0 project.  generate bugs , requirements while doing 2.0 project.  once project complete, filed bugs , issues on 2.0 well.  start 3.0 outstanding bugs , feature requests 2.0.  make more complicated, have widget 2.0 customer a, , widget 2.0 customer b.  core product widget 2.0, there customer specific features company a, , company b.  there widget 2.0, comapny project, , widget 2.0 company b project.  later there widget 3.0 company project, , widget 3.0 company b project.   what trying figure out best way set these in tea...

i attempting run following mdx query determine distinct amount of transaction numbers set including 2 dimension attributes. (pos , concierge)  when run query, seem getting distinct amounts each added together.  if the same transaction number exists in both, they both counted.  if attempt to get the same result using excel pivot table, desired transaction number count.  me getting result in mdx query? with set [week] as strtomember("[date].[hierarchy - fiscal].[fiscal week].&[2012]&[48]") set [store] as {[financial transaction channel].[transaction channel desc].&[pos], [financial transaction channel].[transaction channel desc].&[concierge]} member [store transactions returns] as sum([week] * [store], [measures].[operational transactions count]) select { [store transactions returns] } on columns, { [week] } on rows edw results: store transactions returns wk. 48 - 2012 ...

i converting sql 2005 server 2008.  have old active x script need convert script task ssis... i not familar vb/c# scripting not know how convert use in 2008. when run receive error " an error occurred while adding managed ssis type library script host. verify dts 2000 runtime installed".  believe want avoid invoking legacy functionality converting scripts @ point better. '********************************************************************** ' visual basic activex script '********************************************************************** function main() dim strto dim strcc dim strsubject dim strbody 'construct subject , body , set attachment path strsubject = "validation #" + cstr(dtsglobalvariables("val_id").value) + " (" + cstr(dtsglobalvariables("errorcount").value) + "): " + dtsglobalvariables("val_name") strbody = "description:<br />" ...

i read versions of sql 2005 integrate microsoft update. true? (i don't recall ever seeing sql 2005 updates -- maybe was using windows update not microsoft update?) tia,   barkingdog p.s. know of 2 updates sql 2005: sp1 , bol no others.         yep, microsoft update supposed support sql server: http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=en-us note, site different windows update older site , supports windows.  believe being phased out in favor of microsoft update. sung SQL Server  >  SQL Server Security

1) using tfs integration tool 2010 tfs tfs 2 way synchronization. just wanted know whether have limitations of number of projects can configure on 1 server on 1 applicatopn? this respect perfomance issue 2) out of memory conflict - there specific reason why may occuring? thank you. hi rgn281980, as far know, there no limitation team project numbers when migration using tfs integration tools. out of memory exception, can enlarge memory , take other methods. please refer blog for more details. best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  >  Team Foundation Server – Migra...

i have following scenario. i need execute .exe file saved in folder other c:\ (let's f:\testfolder). in testfolder there .exe called run.exe i need execute run.exe cmd , pass in arguments (pulled local variable). i.e. open cmd > (change directory) > "run \(localvariablevalue)" is possible achieve? pkg scheduled need automatically somewhere within control flow. thanx yes, ssis. please follow post below: http://social.msdn.microsoft.com/forums/sqlserver/en-us/ba0dc794-bfff-4ffb-9245-9f18ea8ba6b3/how-to-setup-execute-process-task cheers, amar deep singh SQL Server  >  SQL Server Integration Services

we have few tables have binary(28) columns primary key.  these sid values active directory.  ria services seems unable handle these: error    1    property 'helpdesk.web.models.group_names.group_sid' marked key property , of type 'system.byte[]', not supported key member type. there way around this?  thought creating view converted them varchar values, they're used fk values number of tables, doesn't seem work.  in our custom written orm, we're trying migrate away from, convert them strings when come out of database , convert them when inserting/updating.  there comparable method of doing ria services? hi, i'm afraid need mapping described in case. this information: if use entity framework , column 16-byte binary column, can map guid property editing .edmx file explained here Silverlight ...

due lack of research on part, used project root root source particular project. makes branching difficult because want branch of files/folders in root release folder, , can't branch folder in root well. my current layout looks like: $/folder1 $/folder2 $/folder3 $/folder4 $/folder5 $/file1.ext $/file2.ext $/file3.ext i'm planning on changing to: $/main/folder1 ... $/main/folder5 ... $/main/file3.ext and can have release folders like: $/release 1.0.0.0/folder1    ... first, issues plan? seems pretty standard me. second, how can move these folders , files? can't seem select multiple files/folders , move them @ same time. have 1 @ time via gui. project has hundreds of folders , files in root, take hours. do have write program this? can use command line? there way in gui i'm missing? thanks, i ended writing quick c# app creates move script me. executes tf move on , on again. seems work fine. thanks. ...

hi, could please advise tools red-gate , apexsql...  ideally understand between these 2 tools great 1 auditing, monitoring, logging, compare database structures ....and many more features. alternatively please suggest if think there's tools other above if experienced with. thanks. hi sap, microsoft cannot make representations regarding quality, safety, or suitability of third party tools.  for apexsql , redgate issues, recommend post question in redgate forums or apexsql forums better support. , can review following blogs more information them. apexsql diff 2012 vs. redgate® sql compare 10 performance: results in (part 1) comparative review: database schema comparison tools in addition, audit , monitor sql server instance, recommend use sql server audit, microsoft's sql server profiler , microsoft's activity monitor ,   microsoft's sql server database engine tuning advisor , on. to   compare database structures, can use ...

  all,   once installed usb digitizer/touchscreen vista,, whenever touch on it, you find vista show circle on desktop,,  @ time lift off finger, you find vista show "right button like" menu you.   this experience once have 1 digitizer/touch screen installed vista.   while, found once circle show up, , if keep touch more 1 minutes,, the circle seems lock there...   do find similar problem? we found device keep send out "touch data" no problem,, so might issue vista... any possible fix avaible?   thanks   -chueh     hello chueh,   this is known issue. press-and-hold cursor freezes after 31 seconds. fix situation, in task manager, end wisptis.exe process associated username.   we investigating best way resolve this.   thank you, ramaguru. Windows Desktop Development  >  ...

hello, i'm using sql 2008 i have xy scatter plot x axis (category axis) percentages, scalar values 5%, 10%, 15%, 20 %. i succesfully added horizontal target value line on y-axis. i'm trying add vertical line target x-axis value, e.g. 14%. enabled minor grid lines on x-axis, , tried make 1 line visible based on visibility expression. it's not working. are there better ways create vertical target value line, or doing wrong?   regards, hennie   hi hennie,   generally, adding vertical line x-axis infrequent requirement, there 2 workarounds it, detailed steps please following these:   >>method one: adding major gridline interval e.g. 0.14 scatter chart   1.       right-click scatter chart area’s gridline , select major gridline properties… 2.       set value of grid interval 0.14 line width 1pt line color black note: method not common workaround suit s...

hello, we using webessentials extension in our solution building , packaging js xss , other files. triggered when building solution within visualstudio, ignored when building tfs build. know way trigger webessentials build thing when building tfs build? regards, leo hi leo, for situation, might check whether web essentials installed on build agent machine. please make sure install on build agent machine , try again. best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  >  Team Foundation Server - Build and release management ...

hi all:   i've team project(tp) 6 solutions(or projects)... lets call dev branch. each has build definition(bd) , common  bd builds projects.   now, i've branched new qa branch, , have common  bd build projects. in future planning on adding , new project the tp , have  bds build projects in it. my question is, whats best practice organize bds ? bds  for projects reside in builds directory in team explorer. i organize them throwing  bds of 1 project in respective folder creating folders under builds directory under the tp in team explorer(te). right now, i'm organizing them giving them <teamproject_projectname_branchname_project> format.   is there better way(folder approach) it?   thanks in advance.   tp - projectname1 - devbranch - project1, project2...project6                             - qabranch  - project1, project2...project6      - newproject2 - newdevbranch - newproject1,...newproject6 you looking @ using visual studio sdk...

we installed sql server 2005 x64 on server our client here @ our office.  can't connect using enterprise manager.  i'm assuming need install management console because of differences in 2000 , 2005.  install x64 , our workstations x32.  need media kit x32 because x64 install won't work.  can install x32 management console , work? on 64bit disks, find folder containing client tools. ssms 32bit -there not 64 bit ssms. (i think need like: sqlruntools.msi.) SQL Server  >  SQL Server Setup & Upgrade

hello experts,   i have big headache these 2 days. in ole db source, want insert results temp table , select * temp table in last line of sql text. clicking preview button, can see result. but when open columns tab, no columns displayed.   i tried use table variable, set fmtonly, set nocount... none of them works.   any guidance welcome! thanks in advance.   btw, reason of using temp table have select several times results. think have save them in temp table , return them select * temp table @ last line. hello alex,   the following article explain using of temp tables ssis:   http://blogs.conchango.com/jamiethomson/archive/2006/11/19/ssis_3a00_-using-temporary-tables.aspx     SQL Server  >  SQL Server Integration Services ...

hi all, might in process of entertaining new bi project , there's talk, customer's perspective, want entertain vertica.  has had experience or perhaps feedback re: vertica vs as2012  -- appears columnar store indexes , high compression 2 of common points love more insightful feedback differences, far performance, scalability, ease of design , use, etc etc.. thx thoughts, cos hi cos, thanks post, seems want compare 2 different product together. not every communities familar 2 different products, different produces have own advantage. here give viewpoint ssas aspect columnar store indexes, high compression, performance, scalability, ease of design , use, etc.. columnar store indexes availabe @ sql server 2012, bring column-store indexes database engine, resulting in queries running several hundred times faster using regular indexes. there new microsoft technology called vertipaq, has different way of storing columns traditional indexes, , compresses data in ind...

i load sql server table data coming csv file in ssis dtsx. input file has 5 column header followed 5column data rows. data rows 3 columns , 7 columns. when ssis pkg fails. want add 2 null columns when 3 columns (similar adding ",," csv file data row). , ignore 6 & 7 columns when more 5 columns. how do in data flow component script task? this blog items has nearly the same title question: http://beyondrelational.com/blogs/sudeep/archive/2011/03/09/ssis-script-component-add-missing-column-or-ignore-extra-columns.aspx?utm_source=feedburner&utm_medium=twitter&utm_campaign=feed%3a+rajsudeep+%28sudeep%27s+domain+-br%29   please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com SQL Server  >  SQL Server ...

i looking method validate number of records loaded production table staging table. loading records using stored procedure , cursor. stored procedure pulls records staging table , loads them production table. after stored proc runs want validate number of rows loaded production table matches number of rows in staging table. in advance help!! hello jc524400, here sample code , how can check compare databetween 2 tables. create table #staging( id int, name varchar(20)) go insert #staging values(1,'oldone') go insert #staging values(2,'oldtwo') go insert #staging values(2,'oldthree') --creating new table create table #prod(id int, name varchar(20)) go insert #prod values(1,'oldone') go insert #prod values(2,'oldtwo') ====================================== --one way --will give records exits in staging not in producton, can take not exits exists , show records exits in both tables. select id,name #staging j not exists(select...

hi.. i hope right forum question. new in databases. i have such problem: there database on  sql-server in country x. database has tables like table 1,table 2 ,.....table 10; i develope application visual c#.net 2.0.  use local sqlexpress database, has tables like table1,table 2..table 6,table a,table b. as see table 1-table 6 same in both databases (not whole database ). , these tables must have same information (server database changes->local database must read changes). because of there must synchronisation between them. how can solve problem? need write code or there simple solution? thank you. what u need replication of database , possible in sql server... there 3 types of replication , (a) transactional replication (b) snapshot (c) merge   read these in bol(books online)   madhu SQL Server  >  ...

i have following table relationships in database , need advice on dimensional usage - please advice. one fact table - fact monthly cost  related tables dim_chargecode , dim_date dim_chargecode related dim_project skprojectid ( 1 project can have one or many charge codes) dim_project related dim_projectportfolio skprojectportfolioid ( 1 project portfolio can have 1 or many projects) dim_projectportfolio related dim_taskorder sktaskorderid ( 1 taskorder can have 1 many project portfolio's) dim_contract related dim_taskorder skcontractid (one contract can have 1 or many task orders) dim_contractgroup related dim_contract skcontractgroupid ( 1 contract group can have 1 or many contracts) dim_programgroup related dim_contractgroup skcontractgroupid ( 1 program has 1 or many contract groups) other tables dim_employee , dim_employee detail dim_employeedetail related dim_programgroup table , dim_programgroup related dim_chargecode table. charge code table 1 dire...

i trying use sharepoint library host documents open using ssrs hyperlink (url method) has ever been successful @ this? kdw this may help. andy tauber data architect vancouver clinic website | linkedin posting provided "as is" no warranties, , confers no rights. please remember click "mark answer" and "vote helpful" on posts you. can beneficial other community members reading thread. SQL Server  >  SQL Server Reporting Services, Power View

long time lurker/reader, first time poster... :) i've been working on new environment prepare upgrade our 2000 environment 2008r2.  in qa, did simulation of normal day's traffic against databases, decided wanted capture data , try use data collection tool set so.  setup snap , , running, writing out 1 of our other databases. in monitoring server whole, sql server instances seemed behave , had no problems keeping work load.  qa people impressed responsiveness of reports applications.  1 thing myself , 1 of sa's noted there 2-3 wmiprvse.exe processes, cluster services , svchost.exe processes eating 25-30% of cpu.  little suprirsed, failed on our second node in cluster , started testing again.  time, data collection running, there no wmi/svc/clsvc processes hogging cpu. both sa , myself sat there scratching our heads.  we've got few more tests run , things dig into, wanted see if else has had similar issue?  here's our current setup: 2-...

dear sqlas users, have strange problem analysis services. when created new roles in database in analysis services instance, gave users inside roles full administrator permission. when checked after day or 2 full administrator permission unchecked. redone procedure , has unchecked again. why happening? sincerely, petar   hello petar, i agree david, deployment overwrite change permissions; have maintain permissions in ssas project well. olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Analysis Services

hi, friends having problem while accessing sql server 2005 remote location when loged in. configuration of environment a)- application server- ip: 192.168.0.77 , windows 2003 server standard edition d1)- database server1- ip: 192.168.0.78, windows 2003 server enterprise edition,virtual ip: 192.168.0.18 d2)- database server2- ip: ip: 192.168.0.79, windows 2003 server enterprise edition      - cisco firewall asa5500      - sun storege      - vpn connectivity mirroring , clustring have ms visual studio 2008 , sqlserver 2005 in a,ms sqlserver 2005 in d1 , d2. have asp.net application asp.net version set 2.0.50727 in iis in , database in d1 application configured virtual directory port 2020 in seprate directory in d: other c://inetpub/wwwroot using data source = 192.168.0.18,1433; initial catalog = mydatabase; user id = myusername; password = mypassword;persist security info=false; integrated security = false in web.config. problem application runing ...

[microsoft follow-up]   i've been reading this thread guy asking capturing throughput of dataflow. suggested there no real notion of capturing throughput of dataflow believe there notion of capturing throughput of component or execution tree .   i believe information 1 need capture throughput of component (apart name of component is) available in onpipelinerowssent event. if there onpipelinerowssent eventhandler , onpipelinerowssent event contained name of component think able capture throughput of component. so, questions: why there no eventhandler onpipelinerowssent event? can name of component added information in onpipelinerowssent event?   following on this... once had conversation here kirk haselden capturing pipeline throughput. thought idea , suggested raised dcr did in old pre-connect days , seems though dcr (like many other things) didn't make across connect. so, more questions: can find connect dcrs relating capturing throughput? i've ...

hello, i did create new parameter,  "start_date_category" (which highlighted in blue color) , hardcoded 3 values ( date project logged, date advertised, on hold start date) (label , value same) "available values" in report parameter properties. above mentioned values column names in report. whenver select column name in parameter dropdown, should retrive data accordingly.these 3 values ( column names ) contains date. till did (as per online articles), did right click on main dataset , selected dataset properties , selected query tab, click on "fx"( expression) next query. and  inserted following expression: ="select [job title], [task grade], [group], department, [business unit], [line manager], [date project logged], [date advertised], [closing date], [team leader], practitioner,                       [project status], commen...

hello! built small silverlight app , published on hosting. works fine. later made changes app (added new controls, changed text, etc) , published again. when i'm in office still see old version. tried cleaning browser's cache - didn't help. when open app home - ok, see new version. difference company uses isa server , guess cached xap file, user have no way cleaning cache. tried use outputcache directive on webform hosts silverlight control had no effect... can here? thanks, alex you use ihttphandler instead of direct link .xap file. means the url .xap file should be changed from "webapp/slapp.xap" "webapp/handler.axd?source=slapp.xap". you will able to add parameter last url, example build number: "webapp/handler.axd?source=slapp.xap&buildno=1234". after upgrading silverlight application have change url parameter "buildno". 1 public class xaphandler : ihttphandler 2 { 3 #region ihtt...

problems getting sql express june ctp install. when run setup get: -------------------------------------------------------------------------- sql server 2005 ctp setup has detected incompatible beta components visual studio or sql server. must run build cleanup wizard cde remove previous sql server components , .net framework components, , run sql server 2005 ctp setup again. detailed instructions on uninstalling sql server builds, see sql server 2005 ctp readme file. -------------------------------------------------------------------------- so run sqlbuw.exe clean things , get -------------------------------------------------------------------------- there no sql server 2005 or .net framework components uninstall. may run setup wizard install new instances of sql server 2005. -------------------------------------------------------------------------- i can't seem win! suggestions? running on xp pro, visstudio beta2 installed.... thanks help! appears though 1 of our guys has made ...

i'm having issue "show % of row total" option in pivot table.  when turn on option, value correct however, when go multiply %age by "2013 budget", the calculation wrong  ie instead of multipying 100,000 * 10%, the calculation is multiplying 100,000 *10,000   .  2013 budget coming seperate table (previous yr measure comes sales table) has relationship.  have topline budget figure entire want "spread" using values % of row total (based on sales month prior year). i have [previous yr] in pt which defined calculate( dimdate[current yr]( dateadd(dimdate[datekey], -1, year)) ).  left no calculation.  created [budget pct] measure defined =[previous yr] , "showed as" % of row total, , added pt.  i've tried using calculate in different context no luck i got measure work: [previous yr]   /  calculate( sum( sale...

  hi,   we have install cumulative update 8 on sql server 2005 instance, server in active active cluster. question following:   1) particular considerations while installing cu8. 2) helpful if can post real time problems have faced while installing cumulative updates. 3) procedure installing cu8 on active active cluster. cu8 needs installed on both the   nodes or active node.     regards rohit     hi,   1) before patch must have backup database. 2) fortunatly didnt yet. 3)yes, must installed on both.as mention active/active means must having 2 instance running no point of active node only.   br praveen barath   SQL Server  >  SQL Server Setup & Upgrade