No, datetime values are not stored in any format - just as two integers, like Lowell said. You can use varchar to store dates in any format you like,...

Yes, I don't see why that shouldn't work.

John

Like I said, it's pseudo code, so you'll need to check the exact syntax of ALTER LOGIN and the structure of server_principals to see what the column names and the...

The only way I know for existing logins is to execute the ALTER LOGIN statements one by one. You can generate them very easily something like this (pseudo code...

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...