Answer Questions

• jakistra prorating the date fields with cost

  Hi all I have got 3 columns in my table- start date,finish date and cost..in the following format... start_date finish_date cost 12/12/2000 20/12/2000 $2000 01/09/2000 12/10/2000 $400 Now if the month and year of the start and finish date is same, the cost remains same... but if the month of the two dates are different, i have to distribute the cost between the two months by calculating the cost f ...Show All

• Michael B. Price Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host.

  Hi, I'm having a problem processing my cube. I keep getting the error stated below everytime I process the cube. I'm a newbiew and can't quite understand the error fully. I'm processing the cube from the server itself so I cant understand why there will be a communication link error.Why do I keep getting this error OLE DB error: OLE DB or ODBC error: Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Protocol error in TDS ...Show All

• Huntz Encryption and recovery on standby machine

  Hi there, to follow on my question in the other forum, I have a database with triple des encrypted columns Master key created, certificate and symmetric key using certificate. Values inserted into table (encrypted) Can select etc, all works fine. Back up and restore database on another server, decrypting the data results in NULLs being returned. Backed up and restore the master key, cerficate, etc but either it completes successfully ...Show All

• Imre Inserting data from one table to another

  Well, I think this should be an easy question, but here goes: I'm taking data from one table and inserting it into another. According to the SQL Server Mobile Book Online, the syntax goes like this: INSERT INTO Table1 (col1, col2) SELECT (col1, col2) from Table2 So while I can do this with my tables: INSERT INTO sensor_stream (sensor_stream_id) SELECT (sensor_stream_id) FROM sensor_stream_temp If I add any more columns, I get an error. Like th ...Show All

• Colby75 Pass XML Data to a Stored Procedure

  Does anyone know how to pass a XML File to a MS SQL 2005 Stored Procedure (INSERT/UPDATE), and how to create the stored procedure so it will accept the XML values using VB 2005. Here is an example of the XML File. Code: <MYROOT> <TableName> <Field1>String</Field1> <Field2>String</Field2> <Field3>String</Field3> </TableName> </MYROOT> Thank you. bty The following lin ...Show All

• atje Data types Differences

  I've recently installed a new server for an aplication we used at work. In the old server we had SQL Server 2000; for the new one we bought SQL Server 2005. Everything is ok till now, the aplication has worked ok; all ok except one thing. I have a report in excel, all the format of the report is saved on one table, that table has fields bit, smallint, tinyint, varchar. Now if I try to make the report all the information is ok but the format i ...Show All

• Hossam Abdel Wahab Going from Express to SQL 2005 Standard

  I have used VWD and SQL Express with success.  Now I have uninstalled SQL Express and installed SQL Server 2005 Standard along with Visual Studio 2005 Standard editions.  The problem that I am having is when I go to use the ASP .Net configuration tool, it cannot connect to the new instance. Now I did run the aspnet_regsql utility to create the membership tables. Did I do something wrong in the setup of the new SQL Server 2005   I ...Show All

• hobbledskydiver Problems adding MS access datasource in VB studios 2005 enterprise

  I am running Visual Studios 2005 enterprise edition and I am creating a mobile application to keep track of some receipts. The problem I'm currently having is that even though I can connect to the MS Access Database with Server Explorer that I'll be aquiring data from; Everytime I attempt to use the Data Configuration Wizard to add a new data source that namely the database I get this error message: The new connection uses a data provider tha ...Show All

• tc ace Tricky Grand Total on Column Needed

  OK, I've created this query so far: Select Distinct CustomerName,                     CustomerNumber,                     FGoal AS FG,                     FSched,    ...Show All

• Avishay How to make tables & stored procedures in MSDE?

  Hello, I am a beginner using MSDE & Visual Basic.NET standard version (not Visual Studio.NET) . MSDE was downloaded from microsoft.com yesterday, which is sql2ksp3.exe. The problem is I don't know where to input data to set up tables or stored procedures after configured the MSDE. The MS Desktop Engine pops me "configuration sucessfully", then I can just open a small window with the title of "SQL Server Service Manag ...Show All

• Pvatsa Help retrieving values from 2 similar stored procs

  I created one stored proc, then copied it to create another similar stored proc with just some filtering changes in the second.  Now I want to obtain the results from both like this: ProjFee   ProjGross  DailyRunRate  Var1  InHouse1  InHouse2  GrossGoal  Group Name  PostedAmount ---------------------------------------- ---------- ---------- ---------- ---------- ---- ...Show All

• nka4 Prevmember versus Lag(1)

  My brain hurts again... I have a cube with Time Intelligence, and I'm trying to make a very simple function: Percentage Change (current month vs. prior month). To determine this, I compare ([Time].[Month]. Lag (1),[Measures].[ACTV QTY]) and ([Time].[Month]. CurrentMember ,[Measures].[ACTV QTY]) Seems pretty simple, right Except that Lag(1) keeps giving me the NEXT month instead of the prior month! So, I tried Lag(-1), which is ...Show All

• joms SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• Liamas Cannot connect to database using SQL Authentification !!!!!!

  I cannot connect to my database using SQL Authentification for a user who is working fine.  I know I'm putting the right username and password because I just recently logged in using Windows Authentification to my database, and retyped the password just to be sure it's right.  I even tried createing a new sql login and tried that, no luck. And yes, SQL is in mixed mode for Authentification as it has been all along. error when try ...Show All

• SteveNash72 Database Sort Order / Collation

  I have an O2 Xda IIs Pocket PC running PPC 2003 SE, WWE (Worldwide English) edition. I want to create a database which contains all Chinese characters that have been mapped under the Unicode Standard. I already have a similar database on my desktop PC. On my desktop PC, I have used the collation Chinese_Hong_Kong_Stroke_90_CI_AS. However, on my Pocket PC, I do not see any Chinese or even Unicode sort orders. The best I get is "General". ...Show All