Lun

i have textbox, want display rownumber located in table based upon here lookup not work: it wants see aggregate. there 1 distinct value "rm 1005" in fields!roomno.value column dataset, , want display rowid. what wrong here? =lookup(fields!roomno.value, "rm 1055" , fields!rowid.value, "dscheckinsteps" ) hi jmcpsd, the syntax of lookup function is:lookup(source_expression, destination_expression, result_expression, dataset) source_expression: (variant) expression evaluated in current scope , specifies name or key up. example, =fields!prodid.value. destination_expression: (variant) expression evaluated each row in dataset , specifies name or key match on. example, =fields!productid.value. result_expression: (variant) expression evaluated row in dataset source_expression = destination_expression, , specifies value retrieve. example, =fields!productname.value. dataset: constant specifies name of dataset in report. example, "produc...

i've made great headway on import package , close end.  trying following: 1. automatically ftp down csv files. 2. loop through directory , latest csv file (filename has date in it) 3. data conversion , insert - flat file source ole db destination in development able work, when explicitly set flat file source.  when set expression connection string, "external metadata column collection out of synch" error.  there way preserve column mappings when using dynamic flat file connection? thanks. yes columns same.  figured out workaround - mapped data conversion template csv file.  when i'm import, rename current file template file.  seems work. SQL Server  >  SQL Server Integration Services

hello, i getting error on system last 14 days , unable run site on system , unable debug silver light application. link: schoolspacemedia.tv i have customize smf player , added method in silver light project interact web service required parms. i getting error on system , on other system able debug code , run site using silver ight player. for resolving issue have tried many solutions : a.)formated system many time , reinstalled software  b.)installed older vision of silver light 5.1.20513.0 , 5.1.40728 c.)check installed vision of wcf rai services v1.0 sp2 (4.1.62812.0) d.)check on windows 8.1 , 10 e.)check mime type wcf service added inn iis or not .xaml,.xap,.xbap please please me am frustrated , waiting support or help  thanks  error : --------------------------- message webpage --------------------------- unhandled error in silverlight application  code: 4004     category: managedruntimeerror    ...

hi all, im unsure how shrink database. i've gone enterprise manager , selected shrink database, says db 5gigs , have 1.3 gigs free space in (which 25%), choose shrink 10% free space left.  press okay , instantly says been shrunk, when @ it, still 25% free space , file size no different.  am doing wrong?  proper procedure this, , recommended "best practice" shrinking database files, ie % of free space should try maintain. thanks, mcm SQL Server  >  SQL Server Tools

no longer any questions :( hi bernd, according description, have issue on rendering line item in report. right? in reporting services, supposed render line properly, no matter line in report body or page header. as tested in our local environment, it can also render line when exporting pdf file. please check rsreportserver.config see if there modification on pdf render extension. please share screenshot of issue if possible, can reproduce in our local environment. reference: exporting pdf file (report builder , ssrs) if have question, please feel free ask. best regards, simon hou SQL Server  >  SQL Server Reporting Services, Power View

hi, i need filter dimension values there no hexvalue - (a cal member). presently seeing empty values in result set.  the data type live title interger. set name col wchar, converts interger value hex value. key of title integer name col title. with member [measures].[parametervalue] as [media].[title]. currentmember . uniquename member [measures].[hexvalue] as [media].[live title]. currentmember . name select { [measures].[parametervalue], [measures].[hexvalue], [measures].[sales] } on 0, nonempty ({ [media].[title].[media title]. members }) on 1 from [abc] result set looks this title  parametervalue             hex value     sales a     [media].[title].[51726]                        36 b      [media].[title].[51728]      45b7e6         2 c      [media].[title].[51729]                         3    i want filter hex value empty report drop down... thanks imran shah  using filter function on row axis should work: with member [measures].[parametervalue] as [me...

hi, has tried use above ? i had no problems rc3 ( aprt missing images ) version gives error on 64 bit blogs on net seem point being issue 64 bit systems.  c:\temp\cxmlbase\binfiles>pauthor /source csv c:\temp\cxmlbase\tasks.csv /target deepzoom c:\temp\cxmlbase\output\tasks-dz.cxml [2010-12-10t16:15:14: error] problem occured while processing collecti on: microsoft.livelabs.anise.api.aniseexception: inline0@79,15: failed instan tiate new csvcollectionsource ---> microsoft.livelabs.anise.api.aniseexception : inline0@79,15: failed invoke constructor microsoft.livelabs.pauthor.str eaming.oledb.csvcollectionsource ---> system.invalidoperationexception: 'mic rosoft.ace.oledb.12.0' provider not registered on local machine. [2010-12-10t16:15:14: error] @ system.data.oledb.oledbserviceswrapper.get datasource(oledbconnectionstring constr, datasourcewrapper& datasrcwrapper) [2010-12-10t16:15:14: error] @ system.data.oledb.oledbconnectioninternal....

i'm using following web service: public class fileservice : system.web.services.webservice { private string filepath; public fileservice() { filepath = httpcontext.current.server.mappath("files"); } [webmethod] public string helloworld() { return "hello world"; } [webmethod] public string uploadfiles(string filename, byte[] byfile, string strfileno) { try { if (byfile.length > 0) { //make sure filename has no path information. string file = path.combine(filepath, path.getfilename(filename)); //string strfilepath = httpcontext.current.server.mappath("//10.0.2.30/files/" + filename); using (filestream fs = new filestream(file, filemode.create)) { ...

i’ve noticed when deleting records sql azure database amount of space consumed database doesn’t drop immediately. sql azure take care of defragmenting indices , data within database free pages, or there need periodically? ms tech talk persona - if found post useful, let know clicking "vote helpful". - #mstechtalk the dba still needs index maintenance , optimization sql azure. can take 15 minutes until space freed delete/truncate operation. please see article more information: http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-faq.aspx#databasesize   ms tech talk persona - if found post useful, let know clicking "vote helpful". - #mstechtalk Microsoft Azure  >  Azure SQL Database ...

hi, i trying delete work item my project collection using command on visual studio command line x64 right clicking as administrator             "witadmin destroywi /collection:http://server:8080/tfs/collectionname /id:50" the command right giving me error .cant connect server, url not valid , server maybe offline windows error 404 not found "  all these error in separate lines i dont understand wats problem , using nlb at's used both server name , nlb cluster ip both giving same error , know command right wat problem , running command on server no firewall issue , m admin of tfs , server  and collection name has space "collection name project " , writing "collectionnameproject" 404 not found error if type server url in net explorer. be relevant ? because of nlb or ? please if can me!!   -shabi since mentioned collection name has space, need wrap in quo...

hi all, we have silverlight solution lot of projects. we use dashworks.master.sln file open solution projects in vs2008. have dashworks.master.sln file in solutiontobuild tag in team build tfsbuild.proj configuration file , looks this: <solutiontobuild include="$(buildprojectfolderpath)/../../../src/dashworks.master.sln"></solutiontobuild> when start building solution in order produce binaries on dedicated machine, errors appear in report: 1) "compiling sources cpu/release" 2) project "tfsbuild.proj" building "dashworks.master.sln" default targets and few more errors there. other tasks done successfully. in log file first things that were failed these: csc : error cs0006: metadata file 'c:\buildtemp\dashworks\master\binaries\release\dashworks.dashboardcontrols.datavisualization.dll' not found done executing task "csc" -- failed. done building target "corecompile" in project "dashworks.client.smoketest....

  hi programmatically creating ssis package.so set different connection properties using c# coding.   there 2 properties need set establish connection.those connection manager properties , connection moniker properties.   my questions are   1)both of these have connection string properties.do have 2 set both of these separately or setting 1 connection string enough?   2) in excel manager connection there server name,user name,password,initial catalog properties can ignore these , set connection string properties directly?   can 1 give me info abt this.   thanks lucki hi, need set properties of connection manager. , can set connection string property directly.  here complete sample on adding connection managers. sample sql server 2008 sample package, can publicly downloaded microsoft website:  private void addconnectionmanagers(string destinationdatadirectory)  {             // add oledb connection manager.             connectionmanager adventureworks ...

i have transparent button in project used everythere. buttons icons , small graphics (for example cross close buttons in dialogs). however struggle find proper solution have disabled , mouseover states dont know content , shape of content going have... normally if creating control template i have collapsed shape same main content shape (say rectangle) , on disabled show .5 opacity , make darker... neat , simple solution. what generic solution create button no shape disabled (and possible mouseover) state? Silverlight  >  Designing with Silverlight

i'm trying check size of new clustered columnstore index (sql server 2014 cu2). if use disk usage top tables report in ssms 64,585,168 kb data , 0 index. if query sys.column_store_row_groups dmv , sum size_in_bytes column 46,457,196,533 bytes ( 45,368,355 kb). looking @ disk space usage report , space used value, seems agree first value. there no deleted rows , row groups compressed. there 1 billion rows. why discrepancy please? should looking @ size? regards ken ken e ken, numbers matching within 4%. discrepancy rounding size of each segment , dictionary whole pages before adding them up. if half of last page empty on average each of these objects sunil agarwal, sql server pm SQL Server  >  SQL Server In-Memory Technologies ...

hi guys, we know can use "was ever" assignedto field in the queries work items assignedto user since begining on time. how acheive same using mdx? thanks! i ended creating waseverby field. created tfs query gets work items ever assignedto user (xyz) , filled waseverby field xyz user. used waseverby field in tfs reports (mdx) , job done. now, writing cusotm tool automate "running wasever tfs query" , "filling waseverby field". thanks looking , suggestions. SQL Server  >  SQL Server Reporting Services, Power View

h there, i have built ssas cube before, using straight forward star schema , works well.   faced entering budget values have many - many relationships item dimension.  let me try explain normal cubes sales cube, 1 fact table, , multiple dimensions, customer, item, date, shipping.  my budget fact table holds budget values @ year/month level.  have 2 fields in budget table relate item dimension.  brand , class 2 in item table, brand @ class 1 level (lower class 2), situation have many brands relate many class 2 fields.   fi reverse that, have class 2 has many brands.   sales guys wish able build reports combine both levels, either class 2 -->  brand  or brand --> class 2..   i have setit far can have both fields, 1 one relationship.  my pk in budget table have linked item table class2+brand  joined together..  i desperatly looking help.. have looked @ many many dimensions, proble...

hi,   i hope went through issue , can give me pointers.   i have 2 servers:   box1: primary domain controller - windows server 2003, active directory, dhcp box2: domain server - windows server 2003, as2000   it takes 12 seconds connect as2000 (box2) from box1. if try connect as2000 (box2) box2, connects immediately. testing network has 2 servers. ideas?   gustav   SQL Server  >  SQL Server Analysis Services

i created policy cube , wanted direct written premium different statuses. direct written premium field present in fact_policypremiumtransaction table. statuses present in dim_status table. there no direct relationship between fact_policypremiumtransaction table , dim_status table. but dim_status table has relationship fact_policytransaction table status key fact_policytransaction has relationship fact_policypremiumtransaction policy key. when processed cube out providing relationship in dimension usuage between fact_policypremiumtransaction , dim_status. m getting repeating values direct written premium. the granularity of both tables different. premium transaction have record if premium a  policy gets changed.. please suggest on how establish relationship in dimension usage. is there policy dimension (based on policy key) relates directly both fact_policytransaction , fact_policypremiumtransaction - or can add one? if so, can establish many-to-many relation between fact_policypremiu...

i connect lot of different servers in sql management studio, find not there no way delete old connections (dbnames, usernames, etc.), start show duplicates. is there way clear them/reorder history? can't seem find easy way. thanks! chris hi, please refer this: http://blog.sqlauthority.com/2008/11/05/sql-server-clear-drop-down-list-of-recent-connection-from-sql-server-management-studio/ thanks, tejas tejas shah http://tejasnshah.wordpress.com/ SQL Server  >  SQL Server Tools

hi all i need insert 10 records in destination using dataflow. now issue in case if there error @ row1 jump next row . my query ; select top 10 * table1 please me how can skip error row. please me resolve issue. thanks & regards bi_group in destination first set max commit size , max insert size 50000. drag error redirection ole db destination values of 10000 each. drag error redirection of task ole db destination both values of 1 each. connect ole db destination gather error column. this way can obtain redirect single error row , allow processing. regards, karthik please remember click mark answer , vote helpful on posts you. can beneficial other community members reading thread. SQL Server  >  SQL Server Integration Services ...

hi everybody! i started learn how work access databases , it's work, understood data can go 1 computer other. don't have computer check if works. can please answer? thanks,        omer. when open access database file, can open database shared users on other computers can share same database.  file needs located on shared network location can specify unc path.  example, if database located on share named "somesharedfolder" on computer "somesharedcomputer", unc file path " \\somecomputer\somesharedfolder\someaccessdatabasefile.accdb "   dan guzman, sql server mvp, http://weblogs.sqlteam.com/dang/ SQL Server  >  SQL Server Data Access ...

i have scenario want able access database @ times. if not in office hosted sql server is, want local version available on laptop when not connected. when return office, want version of laptop sync hosted database. thinking database mirroring, wanted hear other options on scenario. the reason want off-line version internet not available, , therefore system cannot used. if local version available, , data added, efficient.  is possible achieve? , if yes, best approach available me?  sql server replication have been looking into, have sql server 2016 developer edition on 1 machine , sql server 2016 express on laptop additional information: i not 1 accessing database. (only 10 users or require access), , limited 5 tables only. i can lock down rows of data staff member on application, should solve issues conflicting modifications. ok, got it. mirroring out of question (as other ha/dr features availability groups, failover cluster , log shipping) since database acce...

the client working wants install dual tier vsts 2005 database on centralised database asset admin/backup purposes. have implemented sql across 3 separate database server instances, data, analysis , reporting. when vsts setup run can't find analysis , reporting , fails. got ideas? then, try trick msproperty.ini file: http://blogs.msdn.com/mab/archive/2008/04/16/how-to-use-or-setup-sharepoint-on-a-separate-port-or-machine-with-tfs.aspx   they 1 works tfs 2005 well...   p.s. don't let url confuse - post body mentions ssrs well Archived Forums V  >  Team Foundation Server - General

finding "pieces of information" need install sql server express edition complex.  uninstalls "not" uninstall completely, leading failure of sql install.  can suggest thorough, one-stop site directions order of app uninstalls , order app installs following... sql server express edition visual studios 2005 jet 4.0 newest upgrade .net framework 2.0 (or should use 3.0) vs2005 security upgrade anything else need creating database vs2005 visual basic project? i trying use ms access backend db try sql express   thank you, mark       you can check out instructions @ http://msdn.microsoft.com/vstudio/express/support/uninstall/  to remove products. these pre-release, general order still same. it if gave details specific problems having. if don't have pre-release software on computer there solution other uninstalling. point of confusion many people many different , independent components installed when install products such sql expres , visual s...

this has been kicking butt.  have tried lot suggestions multiple postings can't seem past error.  update command works in sql manager.  when select update on webpage fails.  (vs 2010, c#, sql 2008 r2) any or guidance appreciate.  (hope onthe right forum) here latest code: <asp:sqldatasource id="sqldatasourcefleetmf" runat="server" connectionstring="<%$ connectionstrings:mf tool ngconnectionstring1 %>" selectcommand="select tbl_mobilefacility.mf_shellsn serial, tbl_configuration.config_code config, tbl_mobilefacility.mf_aslstat [asl status], tbl_mobilefacility.mf_cspcode csp, tbl_mobilefacility.mf_divcode div, tbl_mobilefacility.mf_brcode br, tbl_organization_1.org_nomen tycom, tbl_organization.org_nomen org, tbl_mobilefacility.mf_lastinvdate [last inventory date], tbl_mobilefacility.mf_wspdcode wspd, tbl_mobilefacility.mf_embarkwt [embark weight], tbl_mobilefacility.mf_phyloc physi...

hi all, can use numerical values database name "dkc123" or issues applications giving name that? regards, kalyan ----learners curiosity never ends---- you can have whever name want (limited 128 characters), blank. *want* follow rules regular or standard identifiers. see instance here: http://msdn.microsoft.com/en-us/library/ms175874.aspx tibor karaszi, sql server mvp | web | blog SQL Server  >  Getting started with SQL Server

the question is,   what i want   to understand   what architecture is   an application   template   for silverlight bussines application? reflections : there a   client application.   he   tied up   the data access logic   (presentation ), not   as business   logic. there a   northern   annex.   here it   is   also responsible for   business logic and   access   to the data ( model and   controller).   in particular,   such a   server application   created   the data model   using the   ado.net entity,   access resources   - provides   service   wcf ria. in opinion   it something   either   j2ee,   pcbmer ,   "parent"   which the   mvc.   perhaps   mvvm? tell me   who   he thinks   knows?   or maybe   there is   a branch   where ...

i have tomcat instance connects via jdbc clustered sql database using pooled connection. the problem each time there's change of nodes, tjhe following error: com.microsoft.sqlserver.jdbc.sqlserverexception: connection closed. at com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdrivererror(unknown source) at com.microsoft.sqlserver.jdbc.sqlserverconnection.checkclosed(unknown source) at com.microsoft.sqlserver.jdbc.sqlserverconnection.createstatement(unknown source) at com.microsoft.sqlserver.jdbc.sqlserverconnection.createstatement(unknown source) at sql.bufferconeccoes.createstatement(bufferconeccoes.java:179) at servicos.validautilizador.validautilizador.validate(validautilizador.java:45) at org.apache.jsp._005flogin_jsp._jspservice(_005flogin_jsp.java:157) at org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70) at javax.servlet.http.httpservlet.service(httpservlet.java:717) at org.apache.jasper.servlet.jspservletwrapper.service(jspservl...

hi experts,  using lot intermediate table in sp, @ end of sp, table getting truncating.but pages still unallocated , unused , how unallocated space , add os drive. because of above scenario, wasting lot of space. seeing lot of unallocated space. pls guide me. hello, you can use command dbcc shrinkdatabase (transact-sql) release unused space, note: cause (high) index fragmentation , end in poor performance. if not low on disk space, don't shrink database (file): olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  Getting started with SQL Server

hi, trying connect sql database c# program, , having following problems. 1) connects fine, other times fails connect.  using integrated security / windows login. 2) trying pass select statement (which works sql server management studio), doesn't seem work in program.  code doesn't appear really... 3) when use code generated vs, loads information datagridview, want filter using select statement. here code generated vs: private void form1_load(object sender, eventargs e) { this.collectiontableadapter.fill(this.dbdataset.collection); } here code: code snippet private void form1_load(object sender, eventargs e) {             //connect database collections table             sqlconnection thisconnection = new sqlconnection(@"server=(local)\sqlexpress;integrated security=true;" +                 "database=db");             //create dataadapter object             sqldataadapter thisadapter = new sqldataadapter("select number [#], image1 [image], title1 ...

i using 2 date parameters in report. if using datetimepicker(for declared 1 parameter of datetime type , 1 string , string parameter using parameter in query. i assigned string date parameter = "[date].[date].&[" + cdate(parameters!fromcreateddatectrl.value).tostring( "s" )+ "]" but report data showing wrong. if populating date combobox dataset. working fine. but need have datetimepicker instead of list of dates. plz me??????????????? you can see in out-of-the-box reports how can done. basically, create datetime parameter , string parameter. datetime parameter used show user datetime picker, , string parameter formula correct format mdx query. ewald - please remember mark replies answers if help. blog: www.ewaldhofman.nl Archived Forums V  >  Team Fou...

i have work code transfer database using smo.transfer object. this code start transfer , subscribe event handlers. have such problem: discoveryprogress - does not approach. maybe need use additional options? m_tr.scriptingerror += new scriptingerroreventhandler(m_tr_scriptingerror); m_tr.scriptingprogress += new progressreporteventhandler(m_tr_scriptingprogress); m_tr.discoveryprogress += new progressreporteventhandler(m_tr_discoveryprogress); m_tr.datatransferevent += new datatransfereventhandler(m_tr_datatransferevent); m_script = m_tr.scripttransfer(); m_tr.transferdata(); sergey,   you can define event handlers this: public static void datatransferhandler( object sender, datatransfereventargs e) {     console .writeline(e.datatransfereventtype.tostring() + " : " + e.message); } public static void progresseventhandler( object sender, progressreporteventargs args) {     console .write("progress {0} of {1} . . . {2} \n", args.totalcount, args.t...

i have client data form letters have sent stored in database table. legal purposes, want create pdf image of every letter have sent, , create link in table file location pdf lives. i had thought of creating "letter" ssrs report, , using ssis pump table key report , automatically save results pdf file in directory, update db pointer pdf execute sql step or something.  the concern have i've never used ssrs in batch mode create pdf files, , i'm not sure how efficient -- since i'm going need create 150,000 pdf files. that's long ssis loop. feasible, or should looking @ word mail merge done in batches , maybe encoding db key in file name , having later task run , build db link? hi joseph, question if these scanned images (typically happen). if yes, can produce report out of table straight in ssrs without ssis. perhaps need report per image or page, not sure there if users need select print. but if want non-interactively bulk save images pdfs...

hi i have seems simple question has been confusing me while. i have time dimension (not yet set proper time dimension) used filter user query 1 particular period.  there second date on measure group can used refine results event further if required. however usage second date used less (<).  scenario: day1 value=1, day2 value=2, day3= value=3. by default should shown agg of 6 (1+2+3) however if user picks day2 result should 3 (1+2: day1+day2)   please advised have not yet setup proper time dimension , dimension being treated regular dimension (with role playing) by default i have set default_member lastchild second date (rpd)   could annyone advise on mdx syntax needed calculations script.  had made poor attempt @ scoping:     alter cube currentcube update dimension [date2].[date], default_member=[date2].[date].lastchild; scope ( [measures].[measure], [date2].[date].members ); = (...

hi all, i'm trying create named set in ssas 2005 cube contains list of products launched year. of these products have not been created dimension members yet building cube fails. is there way can create named set display valid products , ignore members not yest exist, or have no values? i know can use if(is error, true, false), work if exist (other doing 1 "if(is error...)" per member. thank help, m no, can't put code cube.   but how testing theory, can see how accidentally lead astray   sorry, can't think of additional techniques have not suggested. SQL Server  >  SQL Server Analysis Services

hi!  i build asp tree bar in silverlight. know possible build silverlight using asp don't know how that. know how build static bar in silverlight. ideas? know if possible?  any appreciated.  thank you. the basic menu concept not difficult, particularly if more toolbar thing. if in 1.0, can lash server side using ajax. biggest problem i've had situation handling sub-menus. it's do-able, interactions pretty obnoxious. i have full-up functioning menu pull-offs here: http://www.wynapse.com/silverlight/tutor/silverlight_code_samples.aspx this launches many of pages, although believe there couple broken links. need revisit code in general, haven't updated xaml lately. concept still works though. as toolbar, code magazine article discusses that, , first part of here: http://code-magazine.com/article.aspx?quickid=0711061 it uses flat images rollovers similar ie. both of these lashed server-side data in manner outlookbar on right-hand sidebar of wyn...

hi team, i have report requirement need show count based on groups. see below table data , expected report: appreciate inputs regards, please don't forget marked answer if post solved problem , use vote helpful if post useful. helpful other users. hi eswararao, create report table having 2 groups parent group -  group on interfacename shown in below screen:- add child group 2 columns interfacename , activestatus column hsown in below screen:- delete detail default group , report design below:- run report , thanks prasad SQL Server  >  SQL Server Reporting Services, Power View

greetings, i have ssis package derived columns. one of derived columns, "term_in_days" performs datediff , outputs integer. now need derived column, time_balanace multiply existing column, current balance derived column,"term in days." here have far, i'm not sure if it's possible use values derived column "term in days" in time_balance.  [current_balance] * [t_term_in_days] i'm not sure if it's derived column can't used in derived column or if maybe casting issue. feedback appreciated. you can't reference derived column within same derived column transform. create subsequent derived column transform create new value using product of  [current_balance] * [t_term_in_days] SQL Server  >  SQL Server Integration Services ...

hello everyone, i working on filter function sql database (c#), , running bit of difficulties, , thought i'd ask if can see wrong code.  in program, have 3 comboboxes: gendcombo, agecombo, , regioncombo.  have filled them (except region) with search criteria (i want other 2 working first).  when hit onrunfilterbtn, load filtered criteria listview... composed of 5 items:  id, title, text, age, gend. i'm not sure going wrong one, , direction helpful.  tried load columns (age, example) combobox, didn't seem want work me, went ahead , added myself.  tried change string strsql = "select ca_titel, ca_alter, ca_sex fragenkatalog"; to string strsql = "select * fragenkatalog"; which didn't work either.  i believe either not filtering of columns of database (i.e. 3 of them) , can't spit them listview, or strsqlfilter line foul.  either way, i'm not sure it, , therefore grateful help,   thanks again,     martina   here...

hi all when process cube times error  "ole db or odbc  error: operation cancelled; hy008. internal error: operation terminated unsuccessfully  " https://connect.microsoft.com/sqlserver/feedback/details/286505/error-in-processing-cube?wa=wsignin1.0 in above link microsoft said increase query time out, made 0 repros i using sql server 2008.   thanks sunny, please check similar thread . let know your observation..   let try | http://quest4gen.blogspot.com/ SQL Server  >  SQL Server Analysis Services

  hello!   i´m having trouble converting values represented strings decimal data type. i have flat file source, read currency rates represented without decimals. before sending values sql server destination, want convert them represent correct values.   an example clarify:   if source contains column named "curr_rate" value 000092500 want send to destination 9,2500.   so set dervied column component, converting value so:   ((dt_numeric,9,4)curr_rate)/10000   my problems precision lost, , that´s sent destination table 9,0000.   how should go convert strings without losing precision in process?   thanks in advance! convert decimal instead of numeric before division SQL Server  >  SQL Server Integration Services ...

hi all! try this select * doc.webdocs contains(*, n'web , not headline') byt doesn't work. also try run fts query on machine don't understand why doesn't work. Сделаем содержимое сообщества лучше, вместе! hi yatajga, from screenshot, found “web” , “headline” keywords in different columns. far know, sql server full-text search search columns 1 one according search condition, rather search column data combination. made example, can refer codes: use cases; go   create table testandnot ( id int, headline2 varchar(20), webheadline varchar(20), constraint pk_test_id primary key (id) ) insert testandnot (id,headline2,webheadline) values (1,'headline 2','web'),(2,'web headline',''),(3,'','headline'),(4,'','web headline'),(5,'','web');   select * testandnot;   create fulltext catalog fulltextcatalog1; create fulltext index on testandnot(headline2,webheadline) key index ...