You can't make direct updates to system tables from 2005 onwards. Use ALTER LOGIN instead.

See here:

http://technet.microsoft.com/en-us/library/ms189631.aspx

John

Assuming the drawing numbers in the small table are unique, just do a SELECT DISTINCT.

I'm afraid that if you don't have INSERT statements, we can't provide you with a tested...

Please will you provide full DDL in the form of CREATE TABLE statements, and sample data in the form of INSERT statements. A table is an unordered set, so...

First of all, your Drawing number column is char(6), and yet the values in the second table are longer than six characters. Please provide some real sample data in...

Jeff, I don't think that's what Vijay was asking for. Your solution splits the scores into four evenly-sized groups. The requirement was for the scores to be split...

Depends what your Itemstock stored procedure does. You may need to rewrite that as well.

John

This sounds like a "gaps and islands" problem. Have a look at this - does it help?

http://www.sqlservercentral.com/articles/Advanced+Querying/anefficientsetbasedsolutionforislandsandgaps/1619/

John

One way is to use a CASE expression, something like this:

Declare @TestScores table (StudentID int identity(1,1), Score int)

DECLARE @Highscore decimal(4,2)

insert @TestScores (Score) Values (20)

insert @TestScores (Score) Values (03)

insert...

You don't need to assign permissions on the underlying tables and views. This is one great advantage of developing your application so that all access is through stored procedures...

You really need to find out what RDBMS you're using. It sounds like it's MySQL, in which case you may not find anyone here who can help - this...

Now I'm confused, because your latest query contains a column (Project Number) that wasn't in the sample data you posted. This is why it's important for you to provide...

You have more than one value of Cost in Market_Prices_Haulage_Rate for each value of HaulageRate in @tmpOutput - that's what it's saying. Which one do you want to use...

You just need to qualify your Drawing Number column in the GROUP BY clause by putting the table name in front of it, in the same way as you did...

Does select * from [sheet name$A6:A6] not work? If not, could you select * from [sheet name$A6:B6] and only use the value in the first column?

John

Still need DDL, sample data in the form of INSERT statements and expected output. Here's a hint: use GROUP BY in the way that I suggested. If it...