Answer Questions

• OsirisTerje Select Distinct

  Hi there, I run that query SELECT Products.recid, description, partno, price from Products JOIN stock ON Products.recid = Stock.recid Now I want to run the same query but I need the Products.recid to be Distinct, I've tried this but it won't return a distinct value SELECT DISTINCT Products.recid, description, partno, price from Products JOIN stock ON Products.recid = Stock.recid I don't get why it won't return a Distinct value ...Show All

• geckoman Management Studio Still will not install

  I followed the thread " Re: Management Studio for SQL Server 2005 Standard " But these remedies did not resolve the problem. Environment: AMD Athlon64 XP-Pro 64 2gig ram Office Pro 2003 Visual Studio 2005 SQL-Server 2005 Developer I get an error at the end of the install attempt: None of the selected features can be .... and so on. It is saying that the reason is because the upgrade is blocked....SQl-Serev ...Show All

• Salomi Unique Integer IDs

  Hello, I wanted to hear from you - if you've used any unique integer generation technique in the context of a disconnected smart client/local data store and have been successful with it. Any ideas/suggestions will be great. Thanks, Avinash Many thanks. Will read through it and revert if I have any questions. Regards, Avinash We generate GUIDs and th ...Show All

• ShadowedOne Diagram and DTS snap-in's don't work

  Neither of these work. I tried uninstalling and reinstalling client tools but still no luck. Here is my info Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) SP4 ...Show All

• Stringtheory Print Report Window opens after 2 minutes??

  Does any one know what might causing the Print Window to open after 2 minutes SQL SERVER 2000 Reporting Services Windows XP ...Show All

• CDM2 return value of EXECUTE sp_executesql(SQLString)

  Hi, How can I check return value from EXECUTE sp_executesql(SQLString) Thanks, I'm not sure what "return value" means -- if you mean that your SQL generates a value that you need to assign to a variable, you can use an OUTPUT param:     DECLARE @x int   EXEC sp_executesql     N'SELECT @x = 1',     '@x int OUTPUT',   &nb ...Show All

• DeBeDos String truncate error

  Yesterday my program was inserting and loading data in the database just fine, now when i try to do a myriad of things(make a paramatizsed search ad a favorites option) when ever i add data to the database i get a string trucate exception, basically its telling me the data im uploading is too large, problem is the feilds in the databse can take it.Its telling me the column im updating to has a string limit of 255 , but in reality the column its ...Show All

• SMAL in SQL 2005, it have Auto-Number which depend on other column or not?

  Such as, I have 3 Columns EmployeeID(Auto Number) Dept Name I want to ID is auto running depend on Dept Column like this, EmployeeID Dept Name 1 Marketing Jim 2 Marketing John then if i input ID Dept Name Sales Jeave Then I want my ID is generate 1 (because this rows is the first row of Sales Dept I want to check that it have some kind of this feature in SQL 2005 or not.. I found it ...Show All

• lovely sql statement: listing all values

  Hi, i have two tables. Users: - userid, username Location: - userid, postalAddress, timestamp i want to create a view that lists all users (id and name) along with their latest Location address. i use the following sql statement which: select Users . name , Users .userid, Location.postalAddress from Users inner join Location on Location . userid = Users . userid where Location . timestamp IN ( S ...Show All

• Shrinidhi Connecting To SQLExpress From a VB Console Application

  I've been reading through the forums and I have seen that I am not the only person to have trouble simply trying to connect to a database from VB. Firstly I have created a console application, and from within that application I have created a simple 1 table database and added two rows of data. So I now the database is there and working. Problem is I keep getting the following error which trying to apply a connection string to an SQLConnection ob ...Show All

• chr_ Visual Studio 2005 Beta 2: Using SQL Server 2000 instead of SQL Express 2005

  Hello I installed Visual Studio 2005 Beta 2 without SQL Express 2005 because I already had SQL Server 2000 Developer Edition. Now I’m getting errors which says that SQL Express cannot create the needed databases when eg. launching a Web Starter Kit. Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. Description: An unhandled exception occurred during the execution of the c ...Show All

• mjorg Optional Multi-Select Multi Parameters

  Is there a way in RS where you can have multiple multi-select parameters and yet it is only optional to choose from all parameters Hi, I want to set the default values to my parameter from my .Net Application. Right now, I have set the default values to my multivalue parameter at BIDS(Business Intelligence Development Studio) IDE only. Samething I want to do programmatically. How it can be done Any Ideas. I am giving my sample of e ...Show All

• Tony Qu SQL Login using a computer account

  In SQL 2000 I use to be able to grant a computer account access to a SQL DB by adding that computer account to the SQL Logins using DOMAIN\COMPUTERNAME$. I have not been able to do this so far in SQL 2005. Does anyone know if this is still possible or has this functionality been removed from 2005 This functionality should continue working on SQL Server 2005. The way I have tested this functionality is by a ...Show All

• nihk packages and data source views do not work?

  Hi, doing my first steps in SSIS I wanted to copy data from 2 different SQL 2000 database servers to a SQL 2005 Data warehouse. For not having to deploy additional views and procedures to the individual systems I chose to create a Data Source View to create an abstract view on the different data sources. I found out that I can have named queries pointing to the two different data sources in the same view. 1 Project, 2 Data Sources, 1 Data ...Show All

• JayFunnell Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer

  Hi, I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer. Then when I try to delete it it gives this other error: Cannot remove the specified it ...Show All