Answer Questions

• Chimme Random Number procedure problems!

  Hey Guys, I have a quick stored procedure question for you. I created a procedure that returns a randomly generated number. I know there is a built in Rand() function but I need to be able to specify the range. Anyways, it’s returning multiple numbers (1 for each row in the tempTable) But I just want one number returned. I tried using MAX( ) but that’s not a good way of doing it. My question is, how do I return just one record or number Thanks Fellas, Chris ALTER PROCEDURE dbo.spx_GetRandomNum AS DECLARE @Start_Num int DECLARE @End_Num int DECLARE @ReturnValue int DECLARE @RecNum int DECLARE @CurrentRe ...Show All

• Kim Ohrns Here is one more failure that I can not get by . . .

  This error continues to occur even after a couple of uninstalls and re-installs, only to result in the same error.  I can send the logs if you like, but they are large, so this is the short popup I am getting: ( I can't paste the message, but here is the text:     The installer has encountered an unexpected error: The error code is 2331. Error loading library C\program files\microsoft SQL Server ... sqlca.dll or finding entry point.  The specified module could not be found.  Here is a better message out of the event log: Product: Microsoft SQL Server 2005 Notification Services -- Error 2331. The installer has encountered an unexpected error. The error code is 2331. Error loading libra ...Show All

• kangalert Single source, multiple lookups against same table

  Let's say I have 4 columns coming from my OLE DB source. Column1 Column2 Column3 Column4 I also have a table that I'll be using in a lookup, LUPTable. In LUPTable, I have two fields, LUPField, ReplaceField. In my data flow, I need to take columns, 2-4, and look them up against LUPField in LUPTable. I then need to add the value of ReplaceField (when a match is found) into the data flow. The problem that I'm running into is that I don't want to sequentially do the lookups in the dataflow, because that's just a waste of time/memory. I only need to build the in-memory lookup table once, because that exact same data (it is static, for the most part) will be used for the remaining lookups. What is the best way to achieve this The goal is to hav ...Show All

• Danny Thorpe MSFT URL image disappear after postback (sorting)

  On first rendering of the report, the URL image (she's into the report header, a logo) is ok i can see her. But when i use interactive sorting (arrow at the right of an header column into a table) the URL image disappear. I made "view source" on the report viewer page and i see <IMG SRC=""/>, so i lost the URL image on postback. I see in previous posts that the SP1 of SQL Server 2005 should resolve this problem but we have it installed and the problem stay. How can i fix or work around it Sorry for my english, it's not my first language ;) Thanks. Link with SQL Server2005 http://www.microsoft.com/downloads/details.aspx FamilyID=6a166667-29e4-4329-a5af-72bf0f23c621&DisplayLang=en ...Show All

• Kamii47 Query for 4 weeks average ..Need help

  i have 3 tables, each with a date(it has daily dates) column(column name is same in all tables) Each table has columns say "value1","value2", "value3" i want data from all these tables together.such that my first column will have data weeks and other 3 columns count1,count2,count3 will have average of next 4 weeks count..placed infront of week. weeks count(value1) count(value2) count(value3 ) 1/1/2005 101 88 221 1/8/2005 100 81 151 1/15/2005 87 96 301 Average calculations Here : week 1 2 3 4 Count1: 101 = ( 99 + 105 + 110 + 87 )/4 100 = (105 + 110 + 87 + 98 )/4 Plz lemme know if u have any suggestions.. Also, are ...Show All

• Jimmy.Lin Clustering

  Hi, Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster Thanks sql setup log might give some clues as why it fails. Thanks It helped. Th eonly other question is that before installing the SQL cluster do we need to configure the MSDTC or is there any prereq required after the Windows 2003 cluster is setup adminup, did the article help Thanks I figured it out it was probably a share from network drive to MSDTC service accont which was causing this but all well now set up completed thanks for all the help go here http://msdn2.microsoft.com/en-us/library/ms189910 ...Show All

• Mateusz Rajca Cannot view database properties

  Hello all.... I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS. I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS. The user databases have been restored and are accessible by all applications. If I try to view the properties of any database (system or user), I get the following error: ********************************************************************************************************************************* TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL IN ...Show All

• R.Tutus how can i select numeric columns only?

  hi all, how can i select numeric (int, money, numeric, etc) columns only from syscolumns. i need to run a sum() aggregate on all numeric columns thanks, joey Do you need to OR in conditions for FLOAT and REAL Try this query as a starting point. You need to link to the systypes table, but also need to filter out to the actual types if there are user-defined types in play. select o.[name], c.[name], c.[type], t.[name] from syscolumns c Join sysobjects o On o.id = c.id And o.type = 'U' Join systypes t On t.xtype = c.xtype And t.xtype = t.xusertype Where 1=1 And ColumnProperty( c.[id], c.[name], 'Scale' ) is not null And ColumnProperty( c.[id], c.[name], 'Precis ...Show All

• LouisVanAlphen Running Sql Server Developer Edition with VS 2005 and ASP.NET

  I am having problems installing Sql Server Developer edition (2005) with VS 2005 and getting any ASP.NET projects to work. It says SQl Server express must be installed. I would like to use the full developer edition to link to my projects. Can someone help Thanks, Mike G So does that mean the App_Data folder is only used with SQL Server Express and not to be used with SQL Server 2005 John I am having the same problem. When I try to add a new sql database to an asp.net web application using the following steps: 1. Right-click the App_Data folder 2. Select "Add New Item" 3. Select Sql Database 4. Change SQL Datab ...Show All

• TommieJ Accumulated values in analysis services

  Hello, I'm making a report where I have a matrix showing the weeks of a month in the columns and certain data. The user selects a month and I use it as a parameter to show all the calculations from a cube. I already have all the data needed for the matrix, the problem is that I need an accumulated value in the last row that sums the first week's accumulated value and the second week's value and so on (the month can have 4 or 5 weeks). The first week's accumulated value is the data itself since there is no previous value. week1 week2 week3 .... data x1 x2 x3 ... accumulated value x1 x1+x2 x1+x2+x3 ... I don't know if I can do this from the cube using ...Show All

• idos Report Headers vs Page Headers

  Hi, this is probably a simple question but I just can't figure it out. I'm using SQL Server Reporting Services 2005 sp1. I'm trying to design a report that displays a particular embedded image on the first page, and then a different one on every subsequent page. I.e full, fancy company logo on the first page, and a trimmed down version on every other. In Crystal, I would have simply used the Report Header and Page Header sections to achieve this - easy. However, in SQL Reporting Services, there is only a Page Header section - therefore whatever I place in the Page Header shows on every page. Now, I know how to stop it displaying on the first page, but I don't know how to display the other image instead. I read in a support forum t ...Show All

• Lisurc SQL Server 2005 Database Tuning Advisor DTA tuning SQL Server 2000 FAILS

  Hi all, I am using the SQL Server 2005 Enterprise Database Tuning Advisor to try to tune an SQL Server 2000 Enterprise Edition database. I created a .trc file uning the SQL Server 2000 Profiler. I ran this for 24 hours. I chose the template SQLProfilerTuning. In the Gui, for workload file, I entered the name of my trace file that I captured over the last 24 hours. In database for workload analysis I chose: tempdb. In select databases to tune, I put a check mark next to the name of my production database. On the toolbar, I clicked the button representing "Start Analysis" In the Progress Tab, after 5 minutes, I big STOP X appeared. It died on the step "Consuming Workload" It said: Error: ...Show All

• Lucas Cond&amp;#233; Expand/Collapse all in drilldown report

  Good morning folks, I have created a drilldown report with two groups which when run displays the information in it's collapsed state. Is there a way to add a button to expand all expandable rows in the report so that all information within both groups is displayed without having to expand each row one by one I have seen a couple of posts on the subject but when I follow the advice given it only seems to affect the Toggle Image - I still get the report in its collapsed state but the toggle image is displayed as - instead of +. Thanks, CPH Thanks for your help JP, much appreciated. For anyone else struggling with expand/toggle all there's a bit more clarification available in this thread: http://forums.micro ...Show All

• MarlAtkins Report Builder and optional parameters

  Hi, Is it possible to create optional parameters in Report Builder An *ordinary* parameter is created by marking a filter expression as "prompted". At run-time, the user will be asked to provide a value for this parameter (or accept a default value if it is available). This works fine. What I want is to let the user choose whether to provide a value, or leave the parameter empty. In latter case, the reports should not take the parameter into account and display all available data. Example: I have a list of products grouped by the name of the supplier. I want users to be able to see the entire list, or narrow it down to one supplier only. So I create a free text parameter that will contain a part of the supplier's name. I ...Show All

• Derek Chan Synonym to a Database

  Hi All, I know this might sound very stupid but am really pondering whether its possible to create a Synonym over a database, SQL 2K5 is what am using, and when i click the drop down to specify on which object type this synonym has to be created, there is no 'Table' in it. Can somebody help on if its possible If yes then how to do it thanks, Creating a synonym for a database is not supported in sql2k5. Asvin Ananthanarayan MSFT wrote: I am not sure if I understood your question correctly. Do you want to create a synonym for a database or a table Indeed creating a synonym for Database is what I need. Is it not possible in SQL2k5 ...Show All