Well if you told them to review and brought them in for another interview then at that point I would assume they really don't care and probably don't have a...

Barring me having botched order here since I don't have anything to test against this should be pretty colse to what you are after.

SELECT

 ST.student_id,

 ST.last_name + ',  ' + ST.first_name...

It is all a matter of preference sometimes and lack of formal disipline and knowledge, but the point of FKeys is to enforce referential integrity at the table level.

I myself...

First off from your naming convention should make table names singular.

So instead do something like this

Office -- I would change from BrokerOffice because even if other positions are in here...

No you cannot do

SELECT 1 FROM tblX

You have to specify the column name.

You can however use the previously descirbed to determine the column in an SP or in your...

One silly question thou is why? Why do you basically want to add data that is denormalized from what the data and tack it into the current table adding extra...

Just WorkOrder, you will also find that if the only value to return is TransactionDate based on choice of looking up a workorder that the index still acts as a...

Interesting enough here is another post on this last year http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=19701 and they seem to hint and my thoughts as well.

FIrst off 249 is a lot of indexes to have aon any one given table and the processing needed to manage these on inserts, updates and deletes would be extrodinary.

However...

It just isn't allowed, not sure if it has something to do with the pointer mechanism or something to do with memory management? When your data returns via a recordset...

Micrsofot's MSDN library has a few things, try the Netscape develoeprs pages and I thin the W3c site has a lot on it. But overall the only things I have...

There is no reason for anyone to get bent out of shape. The question I have is what is the poitn of this discussion?

Have them convert instead to YYYYMMDD instead as the ISO standard will not fail. If there is nothing on the SQL end to ensure it understands 01/02/2005 is Feb 1st...

I am using this example as previously posted

Create table dates( date datetime)

insert into dates values('2005-01-01')

insert into dates values('2005-01-03')

insert into dates values('2005-01-04')

insert into dates values('2005-01-07')

insert into dates values('2005-01-08')

insert into dates values('2005-01-09')

insert...

What was your query?