Lun

hai eugene,        here attaching code have given me according requirement. have 1 more requirement. for table temptable_xref , appstable following xml query ok.   i have generated 2 xml files with other 2 tables say  temptable_xref1 , appstable. and  temptable_xref2 , appstable. i have written query same following. i got 3 xml files . according our requirement need these in 1 xml file only.   is there process generate such xml file single query?     with xmlnamespaces ( default 'http://www.siebel.com/uan/siebelbias/sharedcomponents/commonobjects/cocommon' ) select   'bus unit' as "idxref/@name" ,   'siebel_ucm' as "idxref/appinstance/@name" ,   ( select      'cust_' + temptable_xref . ucm_uid as "@commonid" ,      temptable_xref . ucm_uid as "text()"    from temptable_xref , appstable where appstable . name = 'siebel_ucm'    for xml path ( 'appid...

hi, i have placed custom control inside tab. possible find out name of tab in control placed?   for example: if custom control placed inside tab called "workitems", need custom control capture information placed inside tab called "workitems".   thank you. hi,   not trivial task, i'd say! i guess can reference containing tab via parent property of custom control , work there...   this blog post should started: http://blogs.msdn.com/narend/archive/2006/07/07/accessingwitfromaddin.aspx   as msdn docs on workitemformcontrol: http://msdn.microsoft.com/en-us/library/microsoft.teamfoundation.workitemtracking.controls.workitemformcontrol_members(vs.80).aspx     please refer thread addressing specifics of obtaining documentservice custom wit control. aforementioned post assumes one's writing add-in or vsip package -both receive more initialization data @ startup custom controls do: http://forums.microsoft.com/msdn/showpost.aspx?posti...

i know has been answered somewhere, have looked through responses , evidently missing something. i have many flat flat files pipe "|" delimited (columns crlf row delimiter) going sql server common t-sql datatypes (varchar, char, decimal, integer, datetime, etc.). what know can find guide or tips on configuring flat file input columns , output columns, etc., data go sql server, , if have cast or converts in vb.net, how syntax go? know in sense, data comes in flat file text. if date, example, 06/21/55 (which have), , goes sql server datetime, how configure data type of 1) input column, 2) output column, 3) vb.net conversion, , take care of if there question mark, space, or if empty. see methods like, todate, tostring, etc. see functions cdate(), etc. i have example, don't know if correct, or sure whether work right, run:             row.anncp = rowvalues.getvalue(0).tostring()      ...

when begin using excel command, randbetween(), example, excel auto suggests full command.  merely help, or can select command shortcut?  know enter doesn't select it. are asking selecting highlighted suggestion intellisense list typing? if so, can hit tab button select highlighted value. thanks, sam lester (msft) http://blogs.msdn.com/b/samlester posting provided "as is" no warranties, , confers no rights. please remember click "mark answer" , "vote helpful" on posts you. can beneficial other community members reading thread. SQL Server  >  SQL Server Tools

hey tech bros, not sure whether right forum.i error while executing job status report script. #create new excel object using com $excel = new-object -comobject excel.application $excel.visible = $true $excel = $excel.workbooks.add() $sheet = $excel.worksheets.item(1) #counter variable rows $introw = 1 #read thru contents of sql_servers.txt file foreach ($instance in get-content "c:\sqlcheck\serverlist.txt") { #create column headers $sheet.cells.item($introw,1) = "instance name:" $sheet.cells.item($introw,2) = $instance $sheet.cells.item($introw,1).font.bold = $true $sheet.cells.item($introw,2).font.bold = $true $introw++ $sheet.cells.item($introw,1) = "job name" $sheet.cells.item($introw,2) = "last run outcome" $sheet.cells.item($introw,3) = "last run date" #format column headers ($col = 1; $col –le 3; $col++) { ...

hello - i'm in progress of planning tfs 2008 tfs 2010 migration (not in-place, importing db's onto new server).  know if shelved code affected migration in way?  i'm 95% sure workspaces , associated shelves part of tfs_ db's i'll restoring , importing 2010... once users connect new tfs 2010 should able pick left off... wanted check experts make sure assumption isn't wrong.  thanks! that correct, migrations i've done have kept shelvesets intact.  that applies workspaces. esteban garcia - my blog Archived Forums V  >  Team Foundation Server - Setup and Administration

hi all i require calendar in format in ssrs parameter. selected dates showed highlighted. , calendar should come in format. please needful. thanks hi bi_group, date/time calendar control built-in component in sql server reporting services (ssrs), not support customize in ssrs. per understanding, can if willing use drop down list of available dates, opposed calendar control. alternatively, can write our own custom calendar control using visual studio, , create rdlc report in visual studio use customized date picker create ourselves. additionally, if have concern this, please submit feedback @ https://connect.microsoft.com/sqlserver/feedback . connect site connection point between , microsoft, , larger community. feedback enables microsoft make software , services best can be, , can learn , contribute exciting projects.   thank understanding. regards, katherine xiong katherine xiong technet community support ...

hi, can please me on this. following error when browse virtual as2000 cube: <infinite recursion detected during execution of calculated member sum({descendants....> i have implemented 'dummy' utility dimension 1 calculated member: (i have used parentchild dimension because that's way know how formula source view): -- view [dbo].[vdimutilitycalculation] as select  'calculationid' = 1,  'parentid' = 1,  'calculationname' = 'currency',  'formula' = 'sum({descendants([period].[quarter].currentmember, [month])},iif([currency].currentmember.properties("fixed") = "1", [amount fixr], [amount flor]) * validmeasure([rate]))',  'memberoption' = 'solve_order=''-1''' -- any idea? thanks, christer and don't work aggregate function (excel , filter multiselect) , main use utility dimension solev_order = -1... it should work. suggest start troubleshooting creatin...

hi all, when creating calculated member can use .currentmember take @ data specific member in axis, given before hand know hierarchy need retrieve currentmember from. lets need create cube calculated member, , don't know how calculated member used, have no idea hierarchy used, how can current tuple row , column? should looking @ .current function? hi, something might grasp concept. google axis() functions: with set [iterator] as [date].[day of year].[day of year] member [context] as 'axis0: ' + generate ( head ([iterator], axis(0).item(0).count) as ,axis(0).item(0).item(i.current.member_value-1).hierarchy.currentmember.name , ', ' ) + ' axis1: ' + generate ( head ([iterator], axis(1).item(0).count) as ,axis(1).item(0).item(i.current.member_value-1).hierarchy.currentmember.name , ', ' ) select [product].[product categories].[category] * [sales territory].[sales territory].[group] on 0, [customer].[customer geog...

i have sql 2008 system told have  two servers configured active/standby vip network configuration. failover clustering database mirroring log shipping replication i don’t think it’s clustering, , there command know kind of high availability have in place? dear friends, please check link more understanding this  https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-and-log-shipping-sql-server SQL Server  >  Database Mirroring

i want feels little complicated. we have measure calculates how many employees have started beginning of time until pivot table filter context: employees started:=calculate(counta(temployees[employed from]);filter(all(tdate[date]);tdate[date]<=max(tdate[date]))) we have measure calculates how many employees have quit. employees quit:=calculate(counta(temployees[employed until]);filter(all(tdate[date]);tdate[date]<=max(tdate[date]))) we have measure calculates have many employees forecasted start beginning of time until pivot table filter context: forecasted start:=calculate(counta(tforecast[employed from]);filter(all(tdate[date]);tdate[date]<=max(tdate[date]))) all of measures above work. now want create new pivot table report uses of measures , adds complexity. explain below. 1) user should select month (and year) current month 2) series in pivot table should show employees started, should not include employees start in or after current month ...

occasionally seeing tswa app pool max out cpu on our @ server. when makes tfs unusable our vs users. i understand there sort of memory leak causing this? http://code.msdn.microsoft.com/kb974402 does app pool control work items open in web client? so am i wrong in thinking work items dev open in vs2008 ide would come under app pool? i reading white paper looks need make changes work items sure. other looking @ other tweaks may need make. reasonable value recycle worker processes? , when recycles user lose connection? hi, if both tswa , tfs web services sites using same apppool, reseting re-initialize both sites. ideally, want separate app pools , recycle tswa 1 every couple of hours. also, there script available deletes tswa cache in addition restarting app pool - recomend using well. thanks, alin, praktik consulting tfs hosting , tfs consulting services. Archived Forums T-U ...

i have 1000 columns in table want select first 400 columns what is the syntax      reading maanish chandra kumar you have construct dynamic sql statement required column names this. know column names , follow particular pattern c1,c2... etc? if yes easy construct sql statement, otherwise have to call sp_columns <tablename> list of columns , construct dynamic sql statement needed this posting provided "as is" no warranties, , confers no rights SQL Server  >  SQL Server Data Access

hi, i have been struggling problem way long!   silverlight hangs @ 100% not open in browser application.  please help.  i have re-installed silverlight, reset browser, tried different browsers , still same.  i confirmed installation , tests fine.  i not convinced problem silverlight maybe permissions issue after windows update.  it working fine until last week.   thoughts? hi viperdp, >> confirmed installation , tests fine. so have tested other silverlight application , working fine, right? if not, please open following silverlight demo site check whether opened correctly or not. https://www.microsoft.com/silverlight/new-controls/demo/ if 1 specific site has issue, please try add site trusted sites in browser through tools -> internet options below screenshot shows. best regards, weiwei msdn community support please remember click "mark answer" responses resolved issue, , click "unmark answer...

hi all, i not have issue when create release path; however, when try create vnext release path, environment dropdown box empty. in addition, different between release path vs vnext release path , release template vs vnext release template? best regards, andy pham best regards, andy pham hi andy,    thanks post. you need create vnext standard or vnext azure environment before create vnext release path. vnext azure environment support deploy website azure, , vnext standard environment support deploy machine, without having install deployment agent. you need create vnext standard environment, click create button in new vnext standard environment create standard server. please refer detailed steps in article( on premise environments standard section): http://blogs.msdn.com/b/visualstudioalm/archive/2014/07/07/how-to-setup-environments-for-agent-less-deployments-in-release-management-release-management-2013-with-update-3-rc.aspx . and helpful inform...

hi all, i have cube in there calculated measure below mdx  aggregate( (    null:linkmember(closingperiod([date].[calendar hierarchy].[date]),[dimeffectivebegindate].[calendar hierarchy]),    linkmember(openingperiod([date].[calendar hierarchy].[date]),[dimeffectiveenddate].[calendar hierarchy]):null,    root([date])  )  ,[measures].[product key distinct count] ) we have fact table has 70 millions data ,and run our etl daily there <200k rows added our system. above query performing  very complex filters , took around 20 mins complex queries . make query faster thought of implementing cache warming  , surprised on process of implementation. the formula engine cache not being shared across users when run same query,every user able use cache data when had run query though excel .but not  able  use  one user's cache across users when run same query. can 1 suggest how on come ?. want implement ...

i running ssrs 2008 r2 report in have groups ex., group a(parent) when assigned interactive sort from text box of detail header (for group a) not worling   thanks, this should moved http://social.msdn.microsoft.com/forums/en-au/sqlreportingservices/threads jeff wharton msysdev (c.sturt), mdbdsgnmgt (c.sturt), mct, mcpd, mcitp, mcdba blog: mr. wharty's ramblings mc id: microsoft transcript please mark answered if i've answered question , vote helpful other user's find solution quicker SQL Server  >  SQL Server Tools

i have task provide plug-in 3rd party application allow users access tfs. the current task guidance utilized msscci provider , code in vs 2006 c++ tfs 2008. having never done tfs have been searching msdn , wider web sample/demos - closest have come code stub, not show actual calls msscci , required setup successful calls provider. coming conclusion msscci black box. anyway, asking possible solutions either accomplish task stated or can present justify changing specs in order have 3rd party interface (even if coded version of tfs or using version of c (a later version of c++ or using c#, etc)).   thank any, , all, suggestions or pointers! hi, first, you  might want @ using team explorer everywhere.  if third-party product listed supported tee not need write own. http://www.microsoft.com/visualstudio/en-us/products/2010-editions/team-explorer-everywhere second, can find more information on the  msscci provider here: http://msdn.m...

hello, i tried command line, error: tf200040: cannot delete team project version of team explorer..." thank you archiecoder archiecoder hi archiecoder, thank post. to delete team project in hosted team foundation service, need run tfsdeleteproject under vs 2012 environment, or team explorer 2012 installed. detail information, can refer http://social.msdn.microsoft.com/forums/en-us/tfservice/thread/81997146-a64f-43fb-9952-57d71542cd11 regards, lily wu [msft] msdn community support | feedback us Archived Forums V  >  Visual Studio Team Services

i watched little video on aggregations , seemed important add cube, went ahead , added them. this, however, took cube processing 45 minutes 5 hours.  i ran few queries through mdx , didnt see noticable improvement performance wise, question this: why need these? cube seems run fine without them. another observation noticed while processing number right of each partition jumps on place. go 1 of 218, 140 of 218, 32 of 218, 4 of 218, 204 of 218, 140 of 218. without aggregations number climbs linearly.   what gives? craig aggregations create precreated summary of measures along dimensional hierarchies. speeds queries.... long queries needed aggregations. the best way design aggregation using usage based optimzation wizard. the processing time goes because pre-summarizing data , requires time , resources. http://technet.microsoft.com/en-us/library/ms174758.aspx     SQL Server ...

hi ssas gurus,   i have requirement need implement security on measures such visible set of users , not accessible set of users. now, have ssrs reports defined on top of these measures accessible both set of users. want reports displayed such measures should visible users access invisible or n/a should displayed when other set of users access reports. best way go forward this? cheers, jason  just implemented solution , works!!! lot raymond , craig! the solution hybrid of raymond's , idea. steps took are 1) had dimension called product. added dummy attribute key of product dimension, , called rolesecurity. value of attribute 1 keys , attribute hidden in product dimension. 2) needed have security access on measure gross margin original. in calculated members of cube, made following calculation create member currentcube.[measures].[gross margin] as  iif(iserror([product].[rolesecurity].[1]),0,[measures].[gross margin original]); 3) have 2 roles called restricted...

first of all, i'm new forums, , i'm still getting started vbee , sql. i'm building simple windows application has sql database 3 tables, related each other. in of them need set one column simple index rows (1, 2, 3... etc), work pk , relate other tables' fks. i've set property identity specification of column yes, , added some rows of data for testing. if keep adding rows, pk columns work fine, if start deleting rows, numbering gets fragmented, , relations between tables lose integrity. i've tried msdn online topics, but they just tell this: if identity column exists table frequent deletions, gaps can occur between identity values. if want avoid such gaps, not use identity property. so, questions are: there another way around problem? how number rows automatically , re-number them when row deleted, , keep table relations working? has constraints? sorry if my question was already answered, couldn't find problem searching forums. thanks in advance....

experts, i have requirement i'll loading multiple files in sql server table , archive files when loaded. however, challenge , file path should dynamic based on value of variable (say, @productname). for example: if running package variable @productname="product", file path "\\....\src\product", in case foreachloop loop through files in folder, load them table , archive files "\\....\src\product\archive" folder. similarly, if @productname="product_ncp", foreachloop container should loop through files in "\\....\src\product_ncp" folder, load them table , archive them ""\\....\src\product_ncp\archive" folder. any suggestions? should able run package manually passing "@product" value, create archive folder if doesn't exist, load data , archive files. if can afford config table flexible approach. have table values each product in package have execute sql task retrive values passing product...

i developed time series model processes succesfully. problem have when try view mining model viewer displays times series on chart, error below: an error occurred while prediction query being executed: 'error (data mining): overflow encountered while converting predicted value '' column, @ line 1, column 33. higher precision data type column recommended.'. additional information: error (data mining): overflow encountered while converting predicted value '' column, @ line 1, column 33. higher precision data type column recommended. (microsoft ole db provider analysis services 2008 r2.) it looks probability value (which float data type, for example 0.4452938765) being stored in particular column, , data type of column cannot contain range of decimal places probability has. i don't know column change data type error messages says. have idea? can send input table , data types used ? mvp mct mcts daniel calbimonte http://elpaladintecnologico.bl...

hi, i trying query active server sql server 2005 , getting error i used following script create link server exec sp_addlinkedserver 'adsi3', 'active directory services 111', 'adsdsoobject', 'adsdatasource' and trying connect using following statement select   * from openquery ( adsi , 'select * ''ldap://dc=local.mycompany.ca'' objectcategory=''user'' ' ) and getting following error an error occurred while preparing query "select * 'ldap://dc=local.resound.ca' objectcategory='user' " execution against ole db provider "adsdsoobject" linked server "adsi". please let me know if know how query active directory using sql server 2005 thanks, raj     dreaming world without war in anywhere this question adsdsoobject oledb provider, not sql server. please try ad forum, such http://social.technet.microsoft.com/forums/en-us/winse...

  i wondering if can me.  reformatted hard drive , reinstalled windows ultimate fresh onto dell xps1710.  since having done laptop no longer sleep when close lid.  lock computer , require enter password desktop.  computer remains on whole time , not go power-saving mode.  reformat hard drive , reinstall windows every 6 months clean added junk has accumulated on drive , have never before experienced problem.  forums , ideas have come have tried following things.  reflashing bios & chipset.  running diagnostic start-up disabling except windows components.  none of these have solved problem.  frustrating use sleep feature quite whenever not @ laptop , hibernate still work takes long reload when come laptop.   well feel stupid, here worked me, maybe same stupid thing you. http://www.howtogeek.com/howto/windows-vista/re-enable-sleep-mode-in-windows-vista/ Windows Desktop Development ...

i having web service return spatial data other related data. want consume spatial data coming web service in report. report able consume normal data, not able consume spatial data coming web service. below syntax how querying web service. want know data type need use cast spatial data.   query :   <query> <method name="getmapdata" namespace=" http://sbisreportingservice.ireportingservice.reportingservice/2010/10 ">    <parameters> <parameter name="reportguid"><defaultvalue>d3045971-0e6d-472b-a148-3a733a799765</defaultvalue></parameter>    </parameters> </method> <soapaction> http://sbisreportingservice.ireportingservice.reportingservice/2010/10/ireportingservice/getmapdata</soapaction > <elementpath ignorenamespaces="true">getmapdataresponse{}/getmapdataresult{}/mapdata { id (integer), classificationname, metric, ...

need on databinding : 1)note :  pictures collection of picture, picnames collection of names of pictures.      medialibrary ml = new medialibrary();             var chkpics = ml.pictures;             var picnames = p in chkpics                            p.name.contains("s")                            select p;  2) static class public static class photonames     {         private static list<string> m_photoname = new list<string>();         public static list<s...

this felt problem mmc or windows 7, i've tried other mmcs , happens sql server management studio. under following conditions: run management studio 2008 administrator. connect sql server instance (we're using windows authentication , administrative account has sysadmin privileges in instance). script object new query window (i scripted create , drop user table) run save as... click on tree dropdown @ top of dialog appears.   the save dialog vanishes , of ui elements in mdi frame stop responding.  the dialog found. you can things in docked windows (e.g. object explorer), close them, can't edit scripts , can't exit management studio. if try close application through system menu, dialog says "microsoft sql server management studio cannot shut down because modal dialog active."   way close management studio kill using task manager. this not happen if run management studio non-administrator.  can use runas different non-administrativ...

hey all, i have small (maybe newbie) problem hope can me solve :) i have aspx page has small 200*50 silverlight app in (embedded object tag of course). that silverlight app suppose open childwindow. if open childwindow silverlight app open in 200*50 area? if so, can make open on "full" aspx, meaning want childwindow open in center of page , bigger 200*50... hope question clear if not more happy explain further.. thanks :) the childwindow must fit inside of silverlight application, constrained size. a few ways make happen: 1. instead of using childwindow, use javascript popup instead system.windows.browser.htmlpage.window.alert("alert message"); - or - bool blnresult = system.windows.browser.htmlpage.window.confirm("are sure?"); 2. otherwise, you'll need make silverlight large app , transparent. there many problems list, because transparency @ object level dramatically impacts rendering performance , app block clicks ge...

hi, i have ssis package , running fine since 1 year.  it fetches data oracle database , inserting same data sql table.  somehow transferring 6 rows out of around 2000 rows , giving error mentioned below.  [ole db source [1]] error: ssis error code dts_e_oledberror.  an ole db error has occurred. error code: 0x80004005. [ssis.pipeline] error: ssis error code dts_e_primeoutputfailed.  the primeoutput method on component "ole db source" (1) returned error code 0xc0202009.  the component returned failure code when pipeline engine called primeoutput(). meaning of failure code defined component, error fatal , pipeline stopped executing.  there may error messages posted before more information failure. there 1 warning in beginning of package execution.  [ssis.pipeline] warning: warning: not open global shared memory communicate performance dll; data flow performance counters not available.  to resolve, run packa...

hi, i looking multi server query. objective create report sql servers/instances services status, jobs status. if 1 have script, please help. thanks you have have linked server refer other servers. read these http://msdn.microsoft.com/en-us/library/ms188279.aspx http://msdn.microsoft.com/en-us/library/ff772782.aspx http://blog.sqlauthority.com/2007/10/06/sql-server-executing-remote-stored-procedure-calling-stored-procedure-on-linked-server/ many & best regards, hua min SQL Server  >  SQL Server Database Engine

hi, i'm writing program draws many small shapes (like 10,000 ellipses) on canvas. the problem takes long time rendering, , shapes become visible of sudden after waiting long time. (on pc takes around 5-6 seconds draw around 10,000 ellipses.) it great if increase performance, if it's not possible, @ least i'd display shapes 1 one (or 100 @ time), progressively, user can know drawing in progress. looking @ msdn document on wpf rendering, states wpf uses "retained mode" system, system controls rendering timing... , in case, chooses draw @ time after taking long time prepare shapes draw... can control rendering timing in application code display shapes progressively? my code looks like: ellipse[] shapes = createshapes(); // creates array of ellipses for ( int = 0; < shapes.length; i++) { ... canvas.children.add(shapes[ ]); // want update display once shape added here... how? .... } in advance help. the real problem ...

hi i having 2 sqlexpress 2008r2 installed on labtop, labtop connected domain , working fine until domain server goes down, so happend? my domain server goes down , change hard drive installed windows server 2008r2 std, domain been created fine , domain called different old one. so when connect labtop domain, windows created user profile however, had username same old one. now, 1 instance of sqlexpress working fine , can use sql server management studio , odbc other instance cannot logme sql via sql server management studio  if use odbc connect. if has idea pls. do. thanks i think have 2 different problems here. one, remote connection issue. use sql server configuration manager on laptop enable remote connections through tcp. your other problem related change of domain name. login user domainold\hasra isn't same domainnew\hasra. not name different, have different security identifier (sid) actual identity (the name property of identity , can changedz0. should dr...

hi,       new silverlight application.       have xaml page(silverlight usercontrol) in have one listbox.       consider :  genericlistbox.xaml page  is silverlight usercontrol.                        in xaml page have 1 listbox.                 want set template style , data through resources(ie.<usercontrol.resources></usercontrol.resources>).  can me out of problem plz.    with regards, kalyan    your description vague.  can show *didn't* work? Silverlight  >  ...