Answer Questions

• Tryst help with sql query returning last max record

  I am having problems with a SQL query. Table has 10 fields and I need to return them all. The three most importaint, at least for the filter I need are: id, studentid, date, canceled. I need to return the last max(date) grater than or equal to @dateparam which is not canceled for each studentid I have worked out some solutions but am not happy with them. Specially woried about performance when the table grows. I am expecting in full production a table growth of about 3 million records per month. what would be grate is if there where a way of returning a the coresponding id like in: select studentid, max(date), related(id) as ids from tablea where canceled=0 group by studentid then I could do: Select * from tablea inner ...Show All

• krhyzsy SQL 2005 error

  Hi, When i tried to double click on the stored procedure in the SQL server 2005 management studio I have received following error. If you know anything about this message please let me know. ------------------------------------- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.ArgumentOutOfRangeException: InvalidArgument=Value of '1' is not valid for 'index'. Parameter name: index at System.Windows.Forms.ListView.ListViewItemCollection.get_Item(Int32 index) at System.Windows.Forms.ListView.set_VirtualListSize(Int32 value) at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.set_ ...Show All

• Yustme Memory Allocation Failure When Deploying AS2005 Project

  Hi, I have an AS2005 project that I am trying to deploy. It contains one fact table with approx 20 million rows. I have never had any problems deploying the project unitl recently. What is happening is when between 3 - 5 million of the rows have been read it will fall over, giving the following error message: "Memory error: Allocation failure : Not enough storage is available to process this command. . Errors in the OLAP storage engine:" I have read about this occurring during the processing of a data mining model, and a hotfix exists to solve this. However, my project contains no data mining at all. Can anyone shed any light on this Dave Edward, I could understand this being ...Show All

• dmkp231 How to select rows that may be locked & deleted with UPDLOCK by other connections?

  I have this procedure that Selects with UPDLOCK and then Deletes the Row but does not commit the transaction until later. While the delete transaction is still active and has not commited, I'd like to have other procedures from other connections be able to still see the deleted row. How can I accomplish this Thanks Costas If you work with SqlServer 2005 you can use snapshot isolation and row versioning. They are well described in the following document: http://msdn2.microsoft.com/en-us/library/tcbchxcb.aspx ...Show All

• Abdul Aziz Group By

  Hi, I have the report,Report datasource is stored procedure.The stored procedure is returning results like this: ID Name Count 1 Own Residence 50 2 Other Residence 20 3 xxxx 89 4 vvvvvv 78 Now i want to display the report like in the following format: Name Count Residence Own 50 Other 20 xxxx 89 vvvvvv 78 How to achevie this Thanks in advance Assuming you can't change your store procedure. To do this you need two distinct tables on your report designer surface. One will have a filter to get rid of all names without 'Residence'. Then, you simply list the names and ...Show All

• IxxI Problem with MDX query using date range from Date dimension table.

  We are facing problem with MDX queries using date range. We have a Date dimension table populated with dates from 2005-01-01 to 2020-01-01 Date dimension table contains dateid as the primary key, which is associated with dateid column of fact table. Following is our MDX query: WITH MEMBER [DATE].[Date].[DateRange] AS AGGREGATE ( STRTOMEMBER(@startDate) : STRTOMEMBER(@endDate), [Measures].CURRENTMEMBER ) SELECT NON EMPTY { [Measures].[PRODID Count] } ON COLUMNS, NON EMPTY {[PRODUCT].[PRODUCT NAME].[PRODUCT NAME]} ON ROWS from [PRODUCT] WHERE ([DATE].[Date].[DateRange]) where startDate and endDate are my query params. startDate=[DATE].[Date].[All] endDate=[DATE].[Date].[All] We have data from 2005-01-01 to 2005-01-31. If we give startD ...Show All

• mahima Derived column in SQL Server 2005 SSIS

  Hi, I am trying to upload a csv file into a destination SQL Server table using Data FLow objects in MS SQL Server 2005 SSIS. My destination table X has a date column while my source data file (for which i have a flat file connection) does not have a date column. I created a Derived column for date using the system date function in my Source data object and ran the package but it returned errors. I changed the data type of the derived column but I still get errors. is there any other way i can get the date on the fly i.e generate a date for the incoming source file and map that (insert into) to the destination table Thanks. Devived column name - Name for your date field De ...Show All

• Walker Boh running MDX as user

  When browsing a cube, you can browse using the credentials of a particular user or using any combination of roles. How can I do the same thing when executing an MDX query Is there some sort of "run as" type of clause in MDX Thanks for your answer, Mosha. Is there a way to set connection properties when executing MDX from Management Studio Or will I have to execute this using code in Visual Studio It is connection string property EffectiveUserName. You need to be administrator in order to be able to use it. OK, thanks for the answer. Unfortunately, we do not have AS2000 here. I guess I could probably build an MDX analyzer on my own. Thanks. ...Show All

• kevinj Output Buffer Remove Row?

  I am using a script component to create the output buffer dynamically. I use the Outputbuffer.AddRow() call. I then set all the fields I want, and its added to the output and later inserted into the database. If a field value fails it causes an error, but the record is partially inserted upto the point where the set field command caused the error. So if I set 10 fields, and it fails on field 5 it inserts data for the 5 fields that worked and nulls into the others. As a result I have a try catch clause, and if it fails I want to cancell the addition of the new row. Is there a command like RemoveRow(), rollback, etc that can be used to not insert the record in error Sample code.. Try PaymentOutputBuffer.AddRow() PaymentOutp ...Show All

• Stigern SP1 and Hotfixes on client

  I've just finished applying SP1 and the hotfixes (in the prescribed order) to my development SQL2005 server. I'm guessing that I need to upgrade my clients, too. I imagine the clients can be upgraded using the big SP1 installer, but do I need to install all of the hotfix packages or just the sqltools hotfix The article about the hotfix is pretty adamant about all hotfixes being installed on a server, even if particular components aren't installed, but they completely neglect the client where only SQL tools are installed. Thanks Steve If your machine only has client tools, you are fine only installing the Tools hotfix patches. The reason we suggest installing all patches (such as on the server) ...Show All

• Seraphino Installing SQL Server 2005 on Windows VISTA ULTIMATE

  Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Please help. Hi, You can install fresh / New copy of SQL 2005 as both MSDE and SQL 2005 Express can be installed on the same machine, how ever have you try Manual Un Installtion ! Refer below guidelines for the same: http://support.microsoft.com/kb/290991/ Hemantgiri S. Goswami ...Show All

• XNA Rockstar Multi-Server Jobs

  Why is it that when viewing Multi-Server Jobs on the MSX Server via Management Studio (Server\SQL Agent\Jobs\Multi-Server Jobs), only jobs that are in the default [Uncategorized (Multi-Server)] category appear Any other Multi-Server job that has been put into a different category is displayed under the Local Jobs folder. That still doesn't answer my question! All I was questioning was why when a job has been categorised in any other Multi-Server job category than [Uncategorized (Multi-Server)] it doesn't show under the Multi-Server jobs folder, (as it does in Enterprise Manager). http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=139988 This will be addressed in the next service pack. A mas ...Show All

• Isaiyavan Babu Karan How do I quit the package ?

  Hi, I have a main package that drives other child packages and under some conditions in one of the child packages, I decide to quit the whole thing. How do I do this Thx, -chiraj You could have a boolean variable called EndExecution or something. And then, on each precedence constraint, check its value. If it is FALSE then the next task should execute. If it isn't, it doesn't. -Jamie i'm not exactly sure what you want to do, but shift + f5 should halt package execution within BIDS. Thanks for responding. What I am trying to do is I will be automating my package and under some conditions, I need to terminate the execution of the whole package. For example. the main packa ...Show All

• t_1369 Invalid object name

  The following T-SQL code generates the error "Invalid object name 'tf_1.dbo.ADX_1'". The database is attached; I can view the table in SSMS and using VB8 code but can't get this statement to run without error. What am I doing wrong SELECT t1 .* FROM tf_1 . dbo . ADX_1 AS t1 , tf_2 . dbo . ALN_1 AS t2 WHERE t1 . [DateTime] BETWEEN '2004-01-01T09:30:00' AND '2004-02-01T16: 00:00 ' AND t2 . [DateTime] BETWEEN '2004-01-01T09:30:00' AND '2004-02-01T16: 00:00 ' AND t1 . [DateTime] = t2 . [DateTime] ORDER BY [DateTime] One final question (and then I will push this up to see who else can help). Can you post exactly what select * from sys.databases returns Can't b ...Show All

• ennisb Analysis Manager & Msmdarch - Application Error

  I have been receiving the follow error when I close Analysis Manger: mmc.exe - Application Error The instruction at “0x7c8327f9” referenced memory at “0xffffffff”. The memory could not be “read” I am also getting the following error when msmdarch completes an archive. msmdarch.exe – Application Error The instruction at “0x7c8327f9” referenced memory at “0xffffffff”. The memory could not be “read” I am not seeing anything in the event viewer for these errors. The system is a Win2k3 Server SP1 with 3.75 GB of ram and Sql Server Standard SP4. I have scoured google looking for an answer, but I am coming up short. Any insight into these errors Looks like somethi ...Show All