Hi All I have a table that contains a comma separated list of products that I want to pivot so that they each product is listed individually. Below is a sample of the table and the data as well as how I am trying to return the data. Any assistance anyone can provide would be appreciated. ...more >>

Hi, I have two tables with a UNION ALL joining them. There are 3 columns. All cols are the same name except one. The difference is they pull data from differerent tables, though the Alias name is the same. How can I group this? e.g. Select a.col1 AS [Col1], a.col2 AS [Co...more >>

Hi there, I'm having trouble coming up with a query for the following scenario: I have a database of movies, and actors that have played in these movies. I would like to find movies which have two actors in common. The [actors] table contains actorId and name; the [cast] table contains acto...more >>

Hi. I'm quite new to SQL Server 2005, so please forgive me if this quesiton is sophomoric. I need to export a table (including it's primary key, etc) and a stored procedure from one database to another database. In SQL Server 2000 there was an option to Export Objects and you could specif...more >>

Cannot connect to UFDCRDEV0005\SQLSERVER. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of ...more >>

I have a VB6 application that runs fine under sql server 2000 if I open a > connection on the server side and set the cursertype to adOpenKeyset. This > does not work with 2005. I need to have the connection open on the server > not the client and be able to movelast, movefirst, etc. Is there a ...more >>

I have installed it on my computer. I have loaded some databases to it and it seems to be working fine. What I dont understand is why when I click on a SP or a function with a right mouse button, I dont see properties choice in the popup menu. Can someone help, please? Thanks ...more >>

I have one database where the .ldf is growing out of control I am approaching 40gb and the .mdf is approx 5gb. I've backed up both files but the .ldf size is not decreasing. Can anyone help? thanks in advance, bob....more >>

Here is a sample data: ID JOB_ID OLD NEW UPDATETIME 15621 9726 3 4 2007-03-28 10:24:24.610 15620 9726 4 3 2007-03-28 10:18:33.900 15613 9726 3 4 2007-03-28 08:39:19.410 15587 ...more >>

hi there, I am trying to get one record from a table based on three fields sort order: select prodname, CostB, CostC, CostD, E from Costs order by CostB, CostC, CostD desc Costs has 5000+ records. I only want 100 rows returned for each of the unique prodnames in a 2nd table based...more >>

This works fine: Select * From Server2.Db2.dbo.ContractIndexUnique If I try DROP TABLE Server2.Db2.dbo.ContractIndexUnique This bombs with: Msg 117, Level 15, State 1, Line 1 The object name 'Server2.Db2.dbo.' contains more than the maximum number of prefixe...more >>

i want to update my second combo box based on the choice on the first combobox. what is the simplest way to do this? i had my first combobox works. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200704/1 ...more >>

Apologies if this is answered elsewhere... I've got a SQL query where I want to say roughly this: SELECT count(user_id) FROM user WHERE user_id IN ( SELECT user_id FROM firsttable WHERE [wherecondition] ) AND user_id NOT IN ( SELECT user_id FROm secondtable WHERE [wherecondition] ) ...more >>

I am on a project with other contractors using one SQL Server Express database that will be distributed to users. The Artificial vs Natural Key argument has reared its ugly head. Can anyone point me to any articles online that comes at the issue from the most even-handed and academic perspect...more >>

Hi I have to search for a range of values. For example I have to search where a value of a column is a; another time I might have to search for a or b; another time for a or c; another time for b or c; and then another time for a or b or c. What is the best way to do this? I am thinking of ...more >>

Is there a way to remove large amounts of records from a table without entries to a log file? I can't use truncate. Thanks in advance ...more >>

Hi, Is there a way in either SQL server 2000/2005 that would allow me to create a stored proc from the output of a query? Eg. To demonstrate my question lets say I have a script to create a table and populate the table with sequential numbers from 1 to 100000: PRINT "Create Procedure u...more >>

There is a seemingly easy T-SQL I have trouble to write, could anyone help me? I can only use SQL2000, so if your solution uses new clauses in SQL2005, it will not helpful for me. My requirements are following: 1. The final select statement will return all columns, 2. returned records mu...more >>

I need a query to run on 2 to N identically-specified tables that returns a full set of columns from each table but that intersect around just one of the columns. And, I should be able to programmatically generate the complete SQL query (no INTERSECT since I'm using 2000 and not 2005). For exa...more >>

Hi everyone, I don=B4t read this group very often, no databases on my typical work, but this time I really need some help. We have to get some data from a table, but (there=B4s always one) when the table was designed, a terrible misunderstanding was made. We needed a table with 5 fields, ...more >>

I have a server where I am the only user. My applications are the only ones on this SQL server. Recently, the tempdb log file is growing extremely quickly - I usually get to 10G within a week or so, forcing me to clear it out on a daily basis. The only thing that has changed is that I re-...more >>

I have a table that has 888,387 records and I am trying to alter the table to add a column TX_THEFT_FEE money and it doesnt complete. I run a sp_who2 and it displays -2 in the blkby column. Any ideas?? ALTER TABLE POLICY ADD TX_THEFT_FEE MONEY go TIA...more >>

We just installed SQL 05 and we are trying to restore a new DB over an older DB. We go through the usual process of restoring the DB when we get this error.... Restore Failed for Server "name" (Microsoft.SqlServer.Smo) Additional Information System.Data.SqlClient.SqlError: Exclusive acc...more >>

Hi, I'm migrating some SQL code from postgres to SQL Server. Under postgres there was a handy syntax that allowed you to use $mytag$ as a string delimiter - ie for cases where your string might contain occurances of single quotes etc. eg you could say WHERE thisstring = $mytag$ this stri...more >>

Hi, Could someone please assist with the construction of a T-SQL query? I have data, of which an example is shown below: Server CaseID User Date/Time SERVERNAMEME 600-02-3104205 Joe Bloggs 2007-04-02 00:00:00.000 BG2782H-Y7 600-02-3104244 Mister Somebody 2007-04-02 00:00:00.000 UHQW...more >>

Having trouble accessing a MS SQL 2005 DB I just created through an ODBC connection. I'm able to create and view tables, but I'm unable to write to them. Can anyone help me on how to set this up correctly? Thanks in advance. ...more >>

Hi, When we create a aggregate function using c# in sql 2005 we need to use the “SqlUserDefinedAggregate” attribute to the structure. Then we have to create four methods 1) Init 2) Accumulate 3) Merge 4) Terminate I like to know how these functions relates to each ot...more >>

I've read a lot of articles over the net about executing SQL commands. but which is better? to perform this database directly or not(using dataset)? -- Message posted via http://www.sqlmonster.com ...more >>

Some time ago a Stored Procedure was run which should have dropped several tables. All except one were dropped correctly, but in one case the tabe disappeared but its entry in [sysobjects] did not. On other occasions the SP has run correctly, except when it has another go at deleting the probl...more >>

I am running a Stored Procedure in SQL Server 2005 to import a large amount of data. In order to speed up the processing I would like to be able to attempt to insert a record and if the INSERT fails then use an UPDATE instead. (This is much faster than checking for existence of the record since ...more >>

Hi, I want to use PIVOT to transfer my rows data to columns(for example in 10 rows one columns is price which has prices of each month). The result is showing 10 rows and column containing price. I want to see price of 10 rows(for each month) in column manner means for result should display r...more >>

In MS SqlServer 2000, I have a DTS package that has a mainframe connection via ODBC. Thus, in my "Execute SQL Task" statements, I am connecting and selecting 2 columns from a view. ie. SELECT * FROM OPENQUERY(DB2_DBI, 'SELECT CLIENT_LOCK, ENABLED FROM CDST001.VSHADOW_AMN') This will select...more >>

Greets, Has anyone ever had any problems with conditional expressions using EXISTS, that failed to evaluate correctly when executed under OSQL.EXE? Example: if EXISTS (select * from dbo.sysobjects WHERE id = object_id(N'[dbo].[MyTbl_Trigger1]') AND OBJECTPROPERTY(id, N'I...more >>

I'm running Vista Business edition on 2005 Virtual PC. Installed SQL Server 2005 Express latest download, with instance of MSSQLSERVER and service accounts running under "NT AUTHORITY\SYSTEM". Mixed mode authentication specified and sa password specified. Used server manager to create user login...more >>

I have a basic question. Within a READ COMMITTED transaction, will an UPDATE statement lock the table, or the row being updated ? And what is the granularity of the lock if the transaction is READ UNCOMMITTED ? ...more >>

We are starting to use GUID's our or PK's now because of the massive amount of data we are going to be storing... and for other reasons like tracking down where its used quicker... we set the column as a uniqueidentifier, set its default value to "newid()" and make it a primary key, but then I...more >>

Is there a way to pass in a username and password to a stored procedure and have that store procedure validate the username and password against the aspnet_membership tables? here is the scenario. I have a handheld device, the user will pass a username and password to a stored procedure, th...more >>

Hi, I want to do something like this.. declare @table varchar(50); set @table = 'TableName' DROP TABLE @table But I get the error Msg 102, Level 15, State 1, Line 4 Incorrect syntax near '@table'. How to go about doing this? The variables in TableName are stored in anothe...more >>

I need to update some field based on wheather Field Invtid begins with 1 to 9 and then update the others which do not begin with 1-9 . i.e all others other then those that begin with 1 to 9. I am using this query but this is only for Invtid beginign with 1.- update inventory set invttype ...more >>

Hi All Can someone help me with the following t-sql statement: SELECT A.ID, A.BusinessName, (Select Count(*) From dbo.Member Where (Account_ID = A.ID) And (Active = 1)) AS CurrentMembers, (Select Max(CountCreditCard + CountDirectDebit) From dbo.Settlement Where Account_ID = A.I...more >>