Answer Questions

• project123 Cannot connect SQL server 2005 Express with VWD 2005

  I have installed MS Visual Web Developer 2005 Express Edition on my Notebook (WinXP Pro SP2). And it's working fine. Then I tried installed SQL Server 2005 Express Edition SP1. There is no error during installation and it seems to be working as I can see the SQL Server (MSSQLServer) service is running. As SQL server configulation manager., the protocal shared memory , named Pipes and TCP/IP are enabled. But when I want to add connection using VWD 2005 by pointing to datasource (MS SQL Server database file and selecing file from .mdf file from SQL sample database file. Then test connection, I got a error that "An error has occurred while establishing a conneciton to the server. when connecting to SQL server 2005, this failure may be ca ...Show All

• esharpcoder Trying to split my columns up into Years, but the rows must be next to one another

  Hi, i'm reasonably new to reporting services and am looking for a way to split my reports' Years to compare the months in year 2005 to 2006 but i can't get my data nest to one another in a single line, it splits the years into different rows as an example this is what i want if you can decipher that 2005 2006 Growth 2005 Year to Date 2006 Year to Date Year to Date Growth turnover gross profit turnover gross profit turnover gross profit turnover gross profit Jan 250500 75300 280200 84100 11.85629 11.686587 250500 75300 Feb 205000 67950 190350 59900 -7.14634 ...Show All

• rgabel Function in select statement

  How can I put a function in a select statement such as SUM(code.GetValue( A, B, C, D, E)) AS TC_Reserve I want to pass the function several values and have it perform a complex formula and return a value.  And then sum the value returned for each row. This data is then used to create a chart "Dollars by Product Category" Is this possible.  I've only been at this for a week so I have no idea if it can done.   I get the message below =============================================================== TITLE: Microsoft Report Designer ------------------------------ Could not generate a list of fields for the query. Check the query syntax, or click Refresh Fields on the query toolbar. ------ ...Show All

• Mark Macumber Date from a Datetime field

  Hi, a colleague need to get the date from a datetime field with a select query. Is there an easy way to get this date I need an excample. Thanks Thomas The suggestions so far would return your column as a string. If you want the data type of the returned column to be DateTime (with the time component removed) you can do this instead. Select DateAdd(Day, DateDiff(Day, 0, dtcol), 0) As dtcol select convert(varchar,datepart(mm,DateTimeCol)) + '/' +convert(varchar,datepart(dd,DateTimeCol)) + '/' + convert(varchar,datepart(yy,DateTimeCol)) from DataTable   select CONVERT ( CHAR ( 10 ), GETDATE (), 110 ) select CONVERT ( CHAR ( 10 ...Show All

• Bernard Brisson How to deal with the problem? "Errors in the OLAP storage engine: "

  Who can tell me how to result the problem Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: ProductKey, Value: 212. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Product of Dimension: Product from Database: Teradata Adventure Works Test, Cube: Teradata Adventure Works, Measure Group: Fact Sales Summary, Partition: Fact Sales Summary, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while process ...Show All

• timmi o tool Server Error : launching SSIS using a webservice and Asp.net

  Hey guys, I have a webservice set up on the same box where my SSIS packages sit at. I have an ASP.net app which calls the webservice. The webservice in turn invokes the ssis package and , I run it on file system. i keep getting this error System.Web.Services.Protocols.SoapException was unhandled by user code Message="Server was unable to process request. ---> That assembly does not allow partially trusted callers." Source="System.Web.Services" Actor="" Lang="" Node="" Role="" StackTrace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Ser ...Show All

• Sinno SQL 2005 SP2 (CTP) installation

  Hello I am trying to install PPS (CTP) this requires SQL 2005 SP2 (CTP) but during the install of the SP2 I get the following error while trying install it: Unexpected Error Occured Unable to create backup Folder Next thing is that A Send don't sent error is created for the hotfix.exe. The install terminates at this point. I am working in a VPC image, logged on as Administrator, anyone give a hint as to what this could be Many thanks Hotfix.exe was written to use UNC paths to reference files in the payload, as well as files on the local machine. If the user turns off default network shares, then the OS will not resolve the UNC paths that Hotfix references, and the execution ...Show All

• Jignesh Vyas When is a date not a date?

  The answer is of course, when it is a date expression that SSIS desparately wants you to convert from something that it just is not. Can anybody clue me the magical piece of syntax that lets this trivial expression know that the comparision is really really, honest honest, I tell no lie, two dates and that neither of them in their entire lives has ever been nor ever will be a string value so, given that they are dates, just compare the two of them and work it out!! "update tblFoo set changed=1 where LatestUpdatedDate>" + @[User::varLastChecked] At the point of being pedantic , LatestUpdatedDate is in TblFoo as a DateTime data type, and of course the package variable is also set up as Datetime, so why oh why do I kee ...Show All

• BMS-Joppe Conditional Where using a Parameter

  How do I construct a select with a conditional where: If DefaultWH is not blank I want to add a "AND part". SELECT DISTINCT Name FROM Warehouse WHERE (Cono = @Company) CASE WHEN @DefaultWH' <> ' ' THEN AND (@DefaultWH = whseid) END Neith of the examples worked. I need to have the query run in 1 of 2 formats Parameter 1 = select company Parameter 2 = select DefaultWH Parameter 3 = SELECT DISTINCT Name FROM Warehouse WHERE (Cono = @Company) < === from Parameter 1 or SELECT DISTINCT Name FROM Warehouse WHERE (Cono = @Company) AND (@DefaultWH = whseid) <===From Parameter 1 and 2 I need to be able to drop or includ ...Show All

• goreng Calculated Member Issue

  Dear all, My project running on AS2005 contains a dimension with 5 values in its table. The fact table contains values for 4 of the values of the dimensions (the last one has not value yet). When I browse the cube, if I display a calculated member (a sum) as measure and the dimension, I can see the measures for the 4 values of the dimension (the last value is not displayed). But if I display a calculed member (done with "CALCULATIONS and which correspond to Measure.A/Measure.B), I see the measures for the 5 values of the dimension (the last value is displayed even if it has no value in the fact table). The fifth one is blank. How can I avoid this Thanks in advance for your support. Juan ...Show All

• Madhur Bhardwaj Upgrade.exe You have got to be kidding!!!!!

  It’s 4Q 2006, Microsoft is touting .NET 3.0; VS 2007 yada yada yada.. And along come the SQL Mobile guys with an upgrade tool that has to be executed from a DOS command. Don’t get me wrong I love DOS commands. But, are you telling me my neophyte users out in the field going to have to key: Upgrade.exe /S “\SD Card\DataDir\SQL.SDF” /D “\SD Card\DataDir\SQL30.SDF” Delete “\SD Card\DataDir\SQL.SDF” Rename “\SD Card\DataDir\SQL30.SDF” “\SD Card\DataDir\SQL.SDF” I don’t think so…… I wrote a utility to do the above. However, I launch Upgrade.exe with a CreateProcess() and I have no good way to determine if it was successful; other that reading upgrade.log and make sure there is no 0x8nnnnnn message in it; ...Show All

• jaxrpc Staying with the SQL Agent during Execution

  I need to create a stored procedure that triggers off a particular job in the SQL server 2005 agent, waits for the job to complete and then returns back the control to the calling application with the job execution results. As far as triggering off the SQl server agent is concerned, I can use the sp_start_job procedure. But what is the best way to wait for the job to complete execution (Because the sp_start_job proc returns back the control immediately after starting the job). I could use the sp_help_job proc in a loop and wait for the value of the "current_execution_status" column to change from 1 to 4...but is there a better way of doing this Appreciate inputs here. - Thanks, Manmeet Hi Manmeet, What you suggested is ...Show All

• Colin Josey Validation issues

  Hi there, I have a package that runs fine in BIDS, however fails when run in a job with the following error: "The Validate method must succeed and indicate the result using an "out" parameter". The task it is failing on is a third party FTP task that uses expressions for the filesource and filedestination and username. I have set delay validation on for this task, yet it still seems that it is trying to validate it. Any suggestions Thanks. The only difference between the CL in the job and the dtexec is that the dtexec has the extra swith "/REPORTING EWCDI". If this is a permission error, what permissions should i be looking at: the job currently runs as sa. Thank ...Show All

• Tero Kruth Backup MS SQL 2005 -> Restore MS SQL 2000

  hi there i've made a backup from a MS SQL Server 2005 database and i tried to restore this database to a MS SQL Server 2000. Unfortunately, I got following error The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrad this database. what can i do is it possible to restore the MS SQL Server 2005 DB on a MS SQL Server 2000 Philipp I faced the same situation many times. The easiest method is to just create an empty database on SQL Server 2000 and use the Export Data wizard from SQL Server 2005 Management Studio to copy your tables and views. For stored procedures you need to create scripts on 2005 and run it on 2000. Check out ...Show All

• Raj MS How to avoid cursors and loops

  hi, My problem is basically i need to call a stored proc for each entry in a table, i.e, basically a for loop calling stored procs with parameter coming from the table. I know two ways of doing this .. using cursor and using while loop with temp table. I dont like both approaches. Is there any good practice for this situation.. declare mycur cursor fast_forward for select ID from sometable open mycur FETCH NEXT FROM mycur INTO @AID WHILE @@FETCH_STATUS = 0 begin exec dbo.storedproc @AID FETCH NEXT FROM mycur INTO @AID end CLOSE mycur DEALLOCATE mycur Sorry, I am unable to get you properly Please see the following example Create function fun() returns int as ...Show All