Answer Questions

• Whoisit SQL Server 2000 Reporting Services SP2 Fails

  Hi, This may be a trivial question but neither SQL Server 2000 Reporting Services SP1 or SP2 wil install against our SQL Server 2005 Developer edition installation. Our Version: Microsoft SQL Server Reporting Services Version 9.00.3027.00 Does anyone know whether the Services Packs are for SQL Server 2000 only if so, whether the new functionality in SP2 will be made available to SQL Server 2005 Many Thanks, Mike The SQL Server 2000 Service Packs only apply to SQL Server 2000 (and not to SQL 2005). SQL 2005 SP2 is targeted to release to the public fairly soon (no formal release date yet). This will include numerous fixes across the entire product. Are you looking for specific RS fixes If ...Show All

• Allan-Nielsen Grand Total Needed

  I have two subreports (Revenue and Expense) that each have subtotals. This works just fine, but I need a Grand Total that would sum the two subtotals. How would I go about doing this So it looks something like this: Revenue Report (matrix) Subtotal Expense Report (matrix) Subtotal <~~~~ Need Grand Total here. I'll try it and let you know. Thank you for all of the help by the way! Greg, It would be difficult across two data regions, myself, I create Calculated GrandTotal field in my dataset and then use that field for display. Ham Ok, so say DataSet1 has Total1 and DataSet2 has Total2. How would I sum the two and display the result at the end of the second report ...Show All

• darthziv ALTER DATABASE planned relocation procedure

  Ok, The SQL server my Database is currently on is going away. They are replacing it with a new SQL 2005. My database has been told to find a new home. No body asked me if it was ok. I have another SQL 2000 Server to move my database to but I can't find any instructions that make since on the MSDN website. I've restored backup copies of databases to the same server but never done a complete move like this. MSDN says i should use the ALTER DATABASE planned relocation procedure, Any body out there know what thier talking about I've hunted for it and I could only find the suff in the SQL 2005 books online for ALTER DATABASE (TRansact-SQL). There was no mention of moving or relocation planned or otherwise in that section. I need to mov ...Show All

• Joseph W. Leathlean Some strange error

  Hi, In my package I am executing 8 'Execute package' tasks which calls 8 different packages. All these tasks are indepent so they are not connected to each other. In each package I have defined a variable at the start of each package there is a script task to assign the 'StartTime' system variable value to the user defined variable. If I run the tasks individually, it is running without any problem. When I am running all the tasks in the parent package, very often the package fails and each time different different tasks are failing. But the error happens at the script task which is used to define the start time. The error message is 'Error: The script threw an exception: Object reference not set to an instance of an object.'. But in ...Show All

• arturm How to put different update on the same table in one query ?

  I have a table in which there are 100 of thousand of record.In on e of the stored procedure I am updating different columns in different go. Now I want's to update them in a one go. How can I do it queries in my stored procedures are UPDATE Job SET CompanyName=c.Name FROM Job j JOIN Company c ON j.CompanyID=c.CompanyID WHERE CompanyName IS NULL AND NOT ((c.Name IS NULL) OR (c.Name='.')) UPDATE Job SET CompanyDescription=left(c.Description,1000) FROM Job j JOIN Company c ON j.CompanyID=c.CompanyID WHERE ((CompanyDescription IS NULL) OR (CompanyDescription=' ')) AND NOT ((c.Description IS NULL) OR (c.Description='.' OR (c.Description=' '))) UPDATE Job SET HomePageURL=c.URL FROM Job j JOIN Company c ON j.CompanyID=c.Comp ...Show All

• Esenthel Cluster setup

  We are on SQL Server 2000 A/A cluster and are moving to SQL Server 2005 cluster. Following are the list of things before proceeding, please let me know if it needs any corrections and add-ons: (side-by-side) Planning for new installation of SQL Server 2005 ( SQL2005INST1 and SQL2005INST2) on node1 and node2 and restoring the databases on SQL2005INST1 and SQL2005INST2 from respective 2000 instances. 1) SQL2005INST1 SQL Network Name SQL IP address 2) SQL2005INST2 SQL Network Name SQL IP address As 2000 is already existing on the cluster.Want some clarity on following questions. Can I keep the data files on the same disk as 2000 was using Do I need to have new disk for the Quoram drive Under & ...Show All

• R.Tutus Upsizing Wizard

  A few days ago I installed SQL Server 2005 Express edition and successfully used the upsizing wizard to convert a MS Access database to SQL Server database. Today I found I could get VB.Studio Express. The instructions said to delete SQL Server Express and .NET before installing VB Studio because it would re-install them both. I faithfully did that but since then I have been unable to get the upsizing wizard to work again. I have uninstalled SQL Server and re-installed it but still cant get it working. From SQL Server Configuration manager I can confirm that Shared Memory and TCP/IP protocol are both enabled for both protocols for clent and protocols for SQLEXPRESS Both the SQL Server and the SQL Browser are running. And from SQL Server Su ...Show All

• blanc0 Group by on a concatenate field

  Select TOP 100 CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) as CODE, Date_Issued, sum(Amount) from dbo.Enterprise_Credits_Import_90_days where CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) <> ' 0' and Service_Prefix like 'F' Group by How can I group by the field that I selected as CODE :) So has it helped Yes... this is the point I was trying to make. One thing to do it as an intellectual exercise about what you can do with T-SQL, but as soon as you're talking about performance, then you need to consider the fact that you really don't want to use the results of functions for filters/groups/sorts. Rob But this isn't ...Show All

• Melissa H. Oracle REF CURSOR

  Good day! Does SQL Server has aby analog of ORACLE's Ref Cursors ex: "type [name] is ref cursor" Thanks you! You could use the output cursors for your scenario. But there are more efficient ways to do this in SQL Server using temporary tables for example. In most cases you don't really need a cursor. So if you want to retain the exact logic, you could use output cursors but there are so many differences between PL/SQL (more richer programming language) & TSQL that it is not going to be a simple conversion. And there is no package object in TSQL so you will have to either create a schema instead of package but this just provides a namespace mechanism. You will have to handle permission ...Show All

• Robert Wakeland Need help using GROUP BY clause

  I have two tables A. TEST_SUBJECTS_TBL with the following columns // This table contains the subjects in a test 1. TEST_SUBJECT_ID //PK 2. SUBJECT_ID //FK 3. TEST_ID //Fk 4. PM // This is the passing marks for the subject B. TEST_MARKS_TBL with the following columns // This table stores the marks scored by students for each subject 1. TEST_SUBJECT_ID //FK 2. STUDENT_ID //FK 3. MARKS_OBTAINED I need a query which gives me the max, min,avg marks obtained in each subject for a test and the total number of students who have passed in the subject The query output should be something like this ___________________________________________________________________ SubjectID MaxMarks MinMarks AvgMarks TotalStudentsP ...Show All

• neversaynever Returning all selected values in multi-valued parameter

  How does one return all selected values in a multi-valued parameter Right now i have a filter on the dataset where (Expression) =Fields!LOCATION_ID.Value (Operator) = (Value) =Parameters!Loc.Value(0) This is just giving me data from the first value that is selected in the multi-valued dropdown. I need all returned from the parameter. Any ideas. Try this: =Join(Parameters!Loc.Value) Unfortunatly, this returns nothing. I believe it returns nothing becuase its not seperating the multiple values selected. Its combinding the values selected from the parameter together as one, which there isnt a valid record for that in the table and therfore returns nothing. I have read s ...Show All

• stang4lyfe SQL2000 and SQL2005 named instances on same server

  Is it the best practise to run SQL2000EE and SQL2005EE named instances on the same server on Windows 2K3 EE Any comments I would consider that a better practice than using Win2000 Server... or SE... If it is a production server then IMHO its not good to have both on same machine, as you might need to consider seperating them in near future. For the sake of availability & continuity you need this change. Also depends upon the database and user growth on both the applications using those versions. As such there is no problem, both will co-exists. but its all depend upon the load on the system when its implemented. if both the instance is going to host a very busy/huge/mission critical ...Show All

• mrmckeb SQL 2k database security question

  I'll try to make this as clear as possible: I have a database user. This user needs to be able to run a sp that truncates a table (see below)selects from it, inserts. I gave specific rights to those tables, and gave rights to execute the stored procedure. yet it's failing on the first step. CREATE PROCEDURE usp_crystal_Tech AS Truncate table Crys_ACDtech_weekly The user has select, update, delete, insert on this table. Why is it faillng Also, I made the user the owner of the job so it can run it, but is there another way to allow the db user to run the job without being owner Can I possibly execute the job as dbo at the top of the procedure YES ...Show All

• avenueofdesign Calling .Net Assembly or Dll from SQL Server 2005 at config Level 80

  Hi, I create a dll assembly with the strong name in VB.Net environment. Created assembly is registered also. SQL Server 2005 configuraton level is set at "80" I want to call that assembly from stored procedure with the database config level at "80" But when i execute the stored proecure i get the following error Error Source: "ODSOLE Extended Procedure" Description: "Invalid Class String" My Code in VB.Net is given below: Imports System Imports System.Reflection Imports System.Globalization Imports System.IO Imports System.data Imports System.Data.SqlClient Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server Imports Microsoft.VisualBasic Imports System.Diagnostics I ...Show All

• moGun How to list all filegroups for a specific database?

  Hi, all here, Would please any expert here give me any guidance for how to list all filegroups for a specific database within SQL Server 2005 Thanks a lot in advance for that. With best regards, Yours sincerely, Within the database use the following command: SELECT * FROM sys.filegroups HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- use northwind select * from sysfiles select * from sysfilegroups Hi, Jens and Joeydj, thanks a lot for your guidance. With best regards, Yours sincerely, ...Show All