I would normalize and create a child table for the names. Then you can set the size to something sensible, like VARCHAR(25) or smaller for FirstName and LastName columns.

You can probably do it with a combination of LEFT, RIGHT, and CHARINDEX

The ONLY difference between LIKE in SQL Server and LIKE in Access is the wildcard character...

Access uses * for a wildcard and SQL Server uses %

Developer is SUPER cheap... like $40-60. Definitely worth the investment if you want to learn SQL Server.

This looks remarkably like a homework assignment... have you covered the GROUP BY clause yet?

Awesome!! So even even I could do it at 7 AM without coffee!

THANKS!

Access and SQL Server are very different beasts. SQL Server has no GUI, so any query that points to a control on a form will fail when you try...

Oh please! Do your OWN homework!!!! This is stupid easy stuff that you can get help with from Books On Line (BOL)... It's not our fault you're too...

I would create a join table between the Users table and the Groups table (call it Membership). It would be set up just like any other junction table -...

I would start with the features that SQL Server Standard does not support that Enterprise does. Those would be the most obvious. (Like partitioning tables, etc)

no need to shout.

create a top values query and sort in ascending order.

I have a function that retreives summary data often. So i can get this data, i create temporary tables to store some filtered data and then select some rows of...

Here is the initial data:

USE SampleDatabase

GO

INSERT INTO Workstation (WkstationID, Manufacturer, OS, IP)

VALUES ('JFK1ABCD123', 'DELL', 'Windows 7.0', '123.123.123.21')

INSERT INTO Workstation (WkstationID, Manufacturer, OS, IP)

VALUES ('JFK1ABCD124', 'DELL', 'Windows XP', '123.123.123.22')

For starters, you...

It should. IIRC, you can specify the collation in your query if you absolutely have to. Either that or you can set it globally in a stored procedure,...

sqlguy,

I *think* you're on the money. I asked Louis Davidson (a SQL Server MVP/author) here in town about a question like that, and he says he deals with subclassing...