Answer Questions

• R.D. T-SQL Trigger challenge

  I have a customer table that contains ID (string), Company (string) that are set to NOT Nulls However , when inserting empty string '' into the table, the NOT Nulls accept it because it is an empty string. So, I want to create a trigger to check if ID or Company contain zero length value (empty string), then raise error "Sorry please enter ID" and do not execute insert As I am new to T-SQL , I am unable to "get the paramenter out of the INSERT query passed into SQL Server from my application" Be plain: 1. In my application , I execute "Insert into customer (ID, Company) Values ('VarID','varCompay')" 2.In the SQL Express, there is a trigger that listen on Customer table for Insert action. ...Show All

• drinkwater Slowly changing dimension:inferred members update

  Hi, Anybody who knows how inferred members update function in slowly changing dimension I came across this when I started using some of the functions of the Slowly changing dimension object. Thanks! cherrie The inferred member enables you to have a Slowly Changing Dimension which is treated as Type 1 when the inferred member flag is true, and Type 2 otherwise. http://msdn2.microsoft.com/en-us/library/ms186969.aspx Donald Hi, Did you find any information about inferred members Did you have an answer to your question I'm in the same situation, and I don't really understand this feature... Thanks in advance. Regards CedrickB ...Show All

• Jan Meeusen Adding SQL Reporting Services to SQL Server 2005 SP1

  I'm using Reporting Services Configuration tool to add the Reporting and ReportingTemb databases. Once the have been created, the tool attempts to upgrade the databases and can not create a script. This are the errors I see from the from the Reporting Services Configuration Tool after creating the databases: ! Verifing Database Version The Database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database. ! Creating upgrade script for database version C.0.8.40 ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseUpgradeScript(Strin ...Show All

• Dietz Sorting Data in a Table

  After you start adding data to a table can you resort it so when you open the table it is in ascending order Thanks No; the only way you can guarantee that you'll get your data back in a specific order is if you use an ORDER BY clause in your SELECT statement.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < RayClark096@discussions.microsoft.com > wrote in message news:37d8d2a5-d53f-42e6-9ae7-7591b5f06514@discussions.microsoft.com ... After you start adding data to a table can you resort it so when you open the table it is in ascending order Thanks ...Show All

• J. Clark Database Integrity Check

  I have a database hosted that doesnt passes the integrity test. Here is the error it gives : Executing the query "USE [db_cs] failed with the following error: "Could not locate entry in sysdatabases for database 'db_cs'. No entry found with that name. Make sure that the name is entered correctly.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Any idea whats wrong and how I can let the integrity test pass for this db. Thanks, Rubal Jain please mark an answer unless you are still exp. problems Hi Derek Just did it ;) Than ...Show All

• NeTBaPb The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

  The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_Allergy". The conflict occurred in database "MSCPROJECT", table "dbo.Severity", column 'SeverityCode'. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_Allergy". The conflict occurred in database "MSCPROJECT", table "dbo.Severity", column 'SeverityCode'. I had the same problem so tried one of the solutions above about checking existing records but couldn't get this to work either. Eventually I realised that I had a few test records in one of the tables. So to fix this issue, make sure that any tables that you are adding foreign key constraints to are empty. Job d ...Show All

• mahima Not getting all the data from the stored procedure

  Hi, I am new to SQL reporting services and currently trying to create a report using an existing stored procedure. Using the wizard I created a dataset and associated the stored procedure with it. When I go to the Data Tab and execute the stored procedure I am not getting all the rows back. I am getting around 100 rows although I am expecting more than 250 rows. I ran the SQL profiler and the parameters that are getting passed to the database when the stored procedure is run from the Data Tab is right. If I use the entry of SQL Profiler in the SQL Server Management Studio (copy and paste), I am getting the right information back (i.e., around 250+ rows). Till now I haven't set any filter on the dataset. A quick analsiys of the result ...Show All

• b0bd0gz round up

  X is a float and I need to perform x/10 and round the result up to the integer. So if result is 0.4 -> 1, if 1.1 -> 2. How can I do this with SQL Use the CIELING function:   SELECT CIELING(x/10) FROM YourTable   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < JIM.H.@discussions.microsoft.com > wrote in message news:4165a8e6-3d64-4db1-9c4b-1cec7040f35a@discussions.microsoft.com ... X is a float and I need to perform x/10 and round the result up to the integer. So if result is 0.4 -> 1, if 1.1 -> 2. How can I do this with SQL ...Show All

• filson Excel file stays in use after I import it using a SSIS package

  Hello everybody... I have a very simple SSIS package that loop throught the worksheets of an Excel file and insert the data into a SQL server 2005 table. The SSIS is very simple and works fine the problem is that after the Package executes if I double click on the Excel file imported I have the message that the file is in use. I think that the Excel connection manager of the package doesn't release the Excel resourse but this is only a guess.. Do am I right If yes how can I release the resource Thank you very much Marina! hi marina, could it be that you're in an endless loop. as i suggest in your other post. get the data first to sql server import file or datarea ...Show All

• Bridgeway AS2005 Redistributable DLLs

  I am referencing Microsoft.AnalysisServices.dll in my C# project to get to the sweet AS2005 object model for automated cube processing among other things but know I need to start getting the deployment of these DLLs figured out for client releases. Currently our installs are deployed to relative paths on the client machines and we have avoided any GAC installations. So my questions revolve around - Are we free to redistribute the Microsoft.AnalysisServices.dll What other dependencies does it have or redistribution requirements Microsoft may have for it Thanks in advance for any help or if someone could point me into the correct direction PS - I have been extremely impressed with the programmability and ease of deployment of AS2005 ...Show All

• Steve Bostedor Conversion failed when converting the varchar value to data type int.

  Table:Student Name nvarchar(1000) Status int In the stored procedure - I have got a string which contains comma separated Status Values such as DECLARE @validStatus = '1000,1001,1002' I want to return the count of students having the status code as in @validStatus SELECT count(1) FROM Student WHERE Status in (@validStatus) But the above statement is erroring out with Conversion failed when converting the varchar value '1000,1001,1002' to data type int. Any help/suggestion appreciated. Thanks, Loonysan The In syntax does not work that way with variables. The variable is treated as single value and not as a list of values. There are two ways to work with a list of values. You can use Dynamic ...Show All

• Butterflyangel02 How can i get XML using a Dynamic Query ?

  i have a function like this, but i alwasys says wrong: alter function GROUP_CONCAT ( @tableName varchar ( 100 ), @groupByColumn varchar ( 100 ), @targetColumn varchar ( 100 ), @targetValue varchar ( 100 )) returns varchar ( 1000 ) as begin declare @back varchar ( 1000 ) declare @sql varchar ( 1000 ) set @sql = 'select ' + @targetColumn + ' from ' + @tableName + ' where ' + @groupByColumn + ' = ''' + @targetValue + ''' for xml auto, root(''root'')' declare @x xml set @x = exec ( @sql ) return @sql end I want to generate XML using a exec(...) , that is a Dynamic Query, but SQL Server 2005 always say something wrong with exec(....) How can i ...Show All

• TobsTec How can i configure sql server2000 with vb.net2003

  Hi I got an exe file of an application with program debug database. Once i am running that program it is giving an error. Can anyone suggest me how to configure SQL server2000 database with this application. I have installed client tool of SQL server2000 on my system. I am very new in MS platform. ................................................................................................................................ The error is like this it is showing this error System.Data.Sql.Client.qlException: SQL server does not exist or access denied. at DataAccess.DataAccess.ExecuteInsertUpdateDeleteQuery(String prsConnString, String StoredProcName,sqlParameter[]parameterLost) Thanks I'm ...Show All

• jsale_endeavor Matrix Report and Expression on field

  I have a matrix report that has two columns, and one of the colums has the following expression for background color: =IIF( Fields!Percentile.Value >= .10, "Yellow", "White") Basically if the percent is greater than 10 highlight the field, for some reason i have some fields that dont show up yellow, see below: http://duhaas.googlepages.com/percent.Jpg YOU DA MAN your colour expression needs to wrap the field reference with the same aggregate function as the textbox value expression. So, if you are using: =sum(Fields!Percentile.Value) as your value then change the colour expression to =IIF( SUM ( Fields!Percentile.Value ) >= .10, "Yellow", "White") this is be ...Show All

• elemr Paging in Business Intelligent Reports

  I have finally been able to create a simple master detail report of the records in the database. Is there any way to create a new page after each record, or to keep a record all together on the same page It took me two days to get SQL Express installed properly so I could get this simple report. They don't make it easy. Any help would be appreciated. Thanks Cal I have installed the tool kit twice but still no devenv.exe. I haven't tried to re-nstall 2005 express advanced yet. I'm going to move this question to the RS forum, they'll have specific advice about writting reports. (we're working on the BIDS install issue in several other threads) Mike I'd be in ...Show All