I run a query for the salesperson, company name, project name, service type for the project and profit. I have to group the results based on the service type. I would like to be able to sum the profits for each salesperson however if a project has two different service types(product and service...more >>

Hey there,, I know when updating,, Access can be differnt from SQL server this works in access from a vb.net 1.1 prog SQL = "Update Clients SET UnameID= '" + updatevalue + "' WHERE ID = " + checkValue + "" Can anyone just quickly tell me what i have to change for it to work in SQL server...more >>

Looking for an idea here. I've got a .Net app connecting to SQL2005 where I allow users to add pictures to the database. But I don't want them adding gigantic images, so I'm looking for an idea on how to control how big of an image they might add. I'm not interested in simply saving a pointer ...more >>

Guys, I have a major problem with an Excel workbook that i created and have been try to resolve this issue for a couple of weeks and my Bosses are breathing down my neck. Here is how it works: I have multiple users using the excel workbook at the same time (they will open as read only). On...more >>

Hi all, I have an insert/update triger that amongst other things calls a SP which amonst other things does a some of the current table. Prpblem is, the newly inserted/updated amount is not included in the sum, (yeah because it is not pysically in the table yet). Any ideas as to how i can achi...more >>

hi reading up clustered indices and i'm trying visualize the structuring. if i build a clustered index then it is a b-tree and the leaf is the data record does the clustered index page look like this? 1 (1st level) / \ 2 3 (2nd level) / \ data data (3rd l...more >>

I ran two different tests on instances of SQL Server 2000 and SQL Server 2005 running on the same machine. The first involved a simple tight loop (while statement) of 50,000 interations in a procedure with no processing. The second involved an insensitive cursor on a table of 50,000 rows agai...more >>

hi, i have the following output in Table1: Dept Item Region Price Date_Changed 4 555 north 99.99 1/6/05 4 555 north 109.99 2/6/06 4 555 east 89.99 11/13/06 4 555 east 108.99 1/6/05 4 111 north 99.99 2/6/06 4 111 north 109.99 11/13/06 4 111 east 89.99 1/6/05 4 111 east 108.99 2/6/06 ...more >>

I used to do the following in SQL Server 2000 to see if I had at least one column in a table that have an identity column. select @AtLeastOneAutoval = count(*) from tempdb.dbo.syscolumns where id = object_id(@TableName) and Autoval is not null However, for an unknown reason, the identity co...more >>

I hope this is an appropriate question for this group. I've posted this in the connect group without success. I just installed SQL Server 2005 Express edition with Visual Studio 2005, and created an app in Visual Studio using C#. I get the following error when trying to connect: ...more >>

HI all, I have a situation where in a trigge of a particular table, I have to exec a Sp (which adds rows to another table), for each row of a third table, passing values from each row into the SP so trigger on table a for each row in table b exec Sp tableb_columna_value, tableb_columnb_valu...more >>

whats wrong with this query? SELECT COUNT(*) FROM ( select * from components where components.coverageid = @CoverageA UNION select * from components where components.coverageid = @CoverageB ) it keeps saying Msg 102, Level 15, State 1, Line 21 Incorrect syn...more >>

I want some help on ideas of how best to go about analyzing some data so that I can determine the best of a group. The following is an illustration of the nature of the analysis needed. I have a table of persons with points being assigned to them. What I want to do is determine the best 80% (...more >>

I have been struggling with the following Stored Procedure. The goal is to return the top (n) customers at each store. I created a View called View_test that is the recordset I want to work with. View_test (approx 6500 records) CREATE VIEW View_test AS SELECT c.StoreId, t.CustomerId, SUM((...more >>

This goes under the category of "Everything You Wanted to Know about SQL, but were Afraid to Ask." I will use the Orders table from NorthWind to demonstrate the concept. When I do "ORDER BY CustomerID, OrderDate DESC" OrderID | CustomerID | EmployeeID | OrderDate 130000_____ALFKI________...more >>

SQL2000 SP3 I'm working with a suppliers calendar table which is used to determine working vs. non-working days. Goes a little something like this... CREATE TABLE [dbo].[AdmCalendar] ( [CalCentury] [decimal](2, 0) NOT NULL , [CalYear] [decimal](2, 0) NOT NULL , [CalMonth] [decimal](2,...more >>

Hi. I'm sorry to bother all of you, but I have spent two days looking at code samples all over the internet, and I can not get a single one of them to work for me. I am simply trying to get a stored procedure output parameter to be stored in a variable in my ASP code. The error I am getting is...more >>

Due to a removal of a column in one of our tables, we now have a table with many duplicates. Yes, this could have been avoided if database had been created correctly in the first place. So now I have duplicates, and I have fk's pointing to those duplicates. Any easy way to delete the duplic...more >>

Is it common for database administrators to lock the programmers out of the databases they are writing programs for? This is the first I have encountered this, and so much time is wasted because I have to wait for a database administrator to fix something. Seems pretty silly when the datab...more >>

Hi all, I'm geting this error and is related to the first Coolumn in the Select list with the J.[name] Column? Server: Msg 451, Level 16, State 1, Line 8 Cannot resolve collation conflict for column 1 in SELECT statement. SELECT DISTINCT CASE WHEN C.[name] = 'Report Server' THE...more >>

I need a programatic way of checking for and and moving new records from a view in one databse to a table in another. Can someone give me an example? ...more >>

I have a table called ATable(field1 varchar(1), field2 integer). The rows look like this: ATable: ===== field1 - field2 x-1 x-2 x-3 y-1 y-2 I want to find out distinct "field1" which has both 2 ****AND**** 3 as field2 values... SELECT DISTINCT field1 FROM ATable Where field2 IN (2,...more >>

Hello, I'm trying to find a book for an intermediate SQL programmer and figured this would be the best place to go for suggestions based on any experiences you've had. I appreciate any help and/or suggestions you might have! ...more >>

Hello, I am moving from Access to SQL and I am trying to create DELETE and a SELECT procedures. I was following the Asp.Net 2.0 Membership, Roles, etc procedures but I am not getting there. Could someone, please, post just the 3 procedures for this example? It would be a start for me to wo...more >>

Hi. I would like to do something like this. SELECT TOP (n+5) * ORDER BY OrderColumn. But I get a error message. Somebody know how can I do (n+5). It is a syntax mistake but I do not know how I can resolve it. Thanks. ...more >>

Hi =20 Im not an SQL n00b, but I'm no SQL guru... I'd like to work out the SQL code required to achieve the following goal = in pseudocode: Grap a record Using info from that record, add (the width) to a running total. When the running total exceeds a certain value, stop grabbing records...more >>

What is the difference with or without the ';' at the end of a statement??? ...more >>

Hello there I need to build a dinamic sql that looks like this: SELECT * FROM Customers where CostomerName = 'Roy' the only way i know to use it as dinamic sql is: exec ('SELECT * FROM Customers where CostomerName = ' + char(39) + 'Roy' + char(39)) is there better way to do this? ...more >>