Answer Questions

• starLisa Pass parameters to complex procedure.

  Hello, I have this Stored procedure, a very complex one, and it works fine with the parameters wrote on it. But when I try to change the number to variables @param1, I got errors, can somebody tell me how to replace this please. DECLARE @return_value int, @lvaIndicador varchar(4000), @ecuacion varchar(4000), @numerador int, @denominador int, @lvaIndicador2 varchar(4000), @ecuacion2 varchar(4000), @numerador2 int, @denominador2 int, @porcentajeCumple numeric EXEC @return_value = [dbo].[SP_CUMPLENCONNIVEL] @nmtipoCompetencia = N'12,13,14', @nmdivisioncorporativa = N'18,19,20', @nmciclo = 9, @nmcicloCompara = 12, @nmempresa = 72, @nmcargo = N'20', @lvaIndicador = @lvaIndicador OUTPUT, @ecuacion = @ecuacion OUTPUT, ...Show All

• DotNetDave First Time Installing - Can't Find BIDS

  Thank you to all that take the time to read this! All software is installed on a single development pc. I have a SQL Server 2000 Developer Edition Database that I am using to test a new Accounting System. SQL Server 2000 is the required format. I would like to start developing some SRSS reports against that database. It was suggested that I install the SQL Server 2005 Reporting Services, because I was told 2005 is less buggy and easier to use. I installed SRSS 2005, and only SRSS 2005, and used the Configuration Tool to get it configured properly, I think. I have green checks on everything except "Email Settings" and "Execution Account" Now, I want to write some reports. BIDS is not under the "Mi ...Show All

• LanceM Problem opening local cube with ProClarity 6.2

  I am new to BI and have a perplexing problem. I need to create a local cube for offline use in ProClarity 6.2 for mobile users. I have created a sample cube in AS2005 using the following code: CREATE GLOBAL CUBE [RainbowBranch] Storage 'C:\SourceData\RainbowBranch.cub' FROM [Rainbow Trade Sales] ( MEASURE [Rainbow Trade Sales].[Adj Sales Value], DIMENSION [Rainbow Trade Sales].[Branch] ) The resultant cube can be opened in Excel 2003 with no problems, but when opened in ProClarity, there is no cube name to select, so I can never get to see the cube data. Is there a problem with my cube build statement Does it need more in terms of parameters, etc. Regards, Charles. ...Show All

• Nirth SQL Server Management Studio - "Save Results As" why no TEXT file option????????

  Hello, I'd like to say thanks to MS for removing or burying yet another feature of a product. Once upon a time in SQL Server 2000 ISQLW.exe, there was the capability to run a query with the results set to TEXT. It was then possible to right click in the RESULTS pane (or do a File-->Save As) and "Save Results As" TEXT or *.* and use .TXT as the file extension. This seems to be buried or lost. Running a BCP utility is not an option. I would appreciate any feedback on this ASAP. Thanks. Try SQLCMD with -q and -o option Eg.  SQLCMD -q"Select *from sys.Object" -osometextfile.txt   read about SQLCMD in BOL, very useful and advance feature for Scripting   ...Show All

• Bruce Bukovics help?

  I need a little help to get me going. I have built a web app in visual web developer and made and inserted an sql db into the site with multiple .aspx pages. It all compiles and seems great. Info from the db is displayed,however when it comes to edit,  insert or delete it bombs out "   incorrect syntax near'nvarchar'  or on delete........'int'   some thing needs to be set to true... All conection strings seem fine and test ok. ps, whats the best way to to totally smash your dell laptop to pieces and send it to pluto Have included error Hi jens thanks for your help recently. I found out that i was trying to load data to my sql with the details view "tool" .... ...Show All

• bonni Null Values in Destination

  Hi to all! I created a simple package – data flow task, containing OLE DB Source, with Data Access Mode – SQL command and OLE DB Destination. My SQL command is update support_incident set date_closed = rn_edit_date where status_text = 'Closed' and date_closed is null DECLARE @CMonth as datetime DECLARE @LMonth as datetime SET @CMonth = '10/1/2006' SET @LMonth = DateAdd (m, -1, @CMonth) select @LMonth as Reporting_Date, (select count(support_incident_id) from support_Incident where rn_create_date >= @LMonth and rn_create_date < @CMonth) as Opened, (select count(support_incident_id) from support_Incident where Date_Closed >= @LMonth and Date_Closed ...Show All

• ZardoS42 Setting up Client PC to access remote SQL Server

  Hi, I am a VB6 programmer and I'm really new to SQL Express, I have always used ACCESS because it was so easy to deploy. I've now written a VB6 program which uses SQL Express and I want to know how to deploy it. Basically my PC will host the SQL database as it has SQL Express loaded onto it. I now want to install my EXE onto other Client's PC and have them read/write to the database on my machine. Besides the EXE program, what software do I need to load onto the Client's PC so they can access my SQLExpress database... (eg: Net Framework, SQLExpress, etc). Also, if my machine is called ABC123, in my connectionstring do I just put in ABC123\sqlexpress as the datasource.. . Will this be enough for the other PCs to connect to mine ...Show All

• kymaita 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'. I had to re-read everyone's answer to the issue 3 times before I understood what the solution was. So for the slow people like myself here's the answer to the issue: If you're getting this error and you don't have any other relationships and you're getting an error on the constraint that you're adding then the constraint is ALREADY being broken. That is if you MUST have ONLY the Primary key's on your primary table and the foreign table has entries that are NOT in the primary then you're already breaking your constraint and you ...Show All

• chaza High CPU utilization in SQL Server 2005 SP2 (CTP)

  Hi, We are having a big performance issue at our site. Here is the configuration of the box running SQL Server 2005: 64 bit Windows Enterprise Edition + SP1 Dual CPU, 16GB RAM RAID 1 and RAID 5 - internal SQL Server 2005 64-bit Enterprise Edition With SP2 (CTP from December) The "Lock Pages in Memory" is set and is being run under the same account that is being used to run SQL Server Services. We are noticing that under load, the CPU utilization becomes nearly 100%. I have researched this and have come across a couple of posts that indicate that this issue was fixed in SP2 - example: One post talked about the hotfix #716 which is also a part of SP2 but even after the application of that service ...Show All

• Ramanakumar SSRS Query Performance = pass through, or ?

  When a user creates a query as Datasource in Visual Studio report designer, does it perform as of a pass through from an application ISSRS is integrated with SQL Server, but the queries used by reports are separate and not stored on the server as views or stored procedures. Is it reasonable to assume report query performance is inferior to the same when written as a SP or view on the SQL Server I ask because I the query designer in VS for reports is so convenient but my reports are running slowly. - ISV report server sends all queries to sql server for execution, it does not spend time on actually executing any part of the query. After the query has been sent, rs waits for sql server to reply with results. having your queries ...Show All

• Radeon512 UPDATE Method

  I have a column of values in one table that needs to be updated based on an adjustment factor in another table. The table which contains the adjustment factors is built with the following column names. RangeBeg RangeEnd Factor The factor is determined depending on where the value falls in the range. I have been trying to do an sql script with no luck. Any Help would be appreciated. Thanks Hi, this could be something like (just guessing because we really need the DDL and some sample data to see how your actual design is working): UPDATE SomeTable SET SomeValue = ( SELECT SomeUpdateValue FROM AnotherTable AT WHERE ST.SomeRangeValue BETWEEN AT.RangeStarting AND AR.RangeEnding ) ...Show All

• Parvaneh Spurious Errors With Package Execution on Local Machine

  I am having strange errors with a package when running locally that has not been an issue before. The main symtom is that several Data Flow Tasks are either not inserting records on the destination or are only inserting 1 single record before the package errors with the error shown below. Strangely, the debugger will show X # of records from source and destination, but either no records are actually written or, again, in many cases, only 1 single record is written. This is very strange. App, System and Security logs yield no indication of security or other errors. All I have to go on is the above anomolies and the error message provided below. Below is the error message, can someone help me decrypt it Many thanks, Rick ...Show All

• laue Reporting services in 2005

  Hi, How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks" http://msdn.microsoft.com/msdntv/episode.aspx xml=episodes/en/20050609SQLServerBW/manifest.xml When I add a report to my project, all I get is the layout view. When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video. Did I miss something I need when installing :-) hello, I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server ...Show All

• davefriend Creating a data source on the server to connect to SQL SERVER.

  My question is what is the proper way to do this I have been try the ways that it is instructing me to do. By creating the name, then I go to a list of potential sources, one being: the local, then another being: the actual domain on the network, last one being: the name of the created data source. I have already tried the local & domain, I will try the last one. But, my question is if this selection is not going to connect to SQL SERVER. Then, "What should I do within the server to make this connection possible to a client computer look for the access " Hi, I Did not understand your explanation. But anyway, if you want to let clients access SQL Server, you would have to do nothing more than 1.Enabling remote ...Show All

• FredDabb Update Variable after a conditional split

  I have a Variable called - UpdateIDs. I would like to create a conditional split on id's that have no responses and id's that have responses. The idea is. There is a whole bunch of tables that can be updated if the foreign key is in the no responses id's. So I have created a data flow. The conditional split is there, but I do not have a "Update Global Variable" Destination source. Is there away to achieve this. Basically this is the logic that I am trying to use Dataflow --> Store Id's into Global Variable --> Data Flow update/insert Tables and Rows where Id in Gloabl Variable. Is there another way this can be done Sorry I am very new to this, and would appreciate any help Thanks Andrew ...Show All