Viewing 15 posts - 3,436 through 3,450 (of 3,482 total)
Awesome!! So even even I could do it at 7 AM without coffee!
THANKS!
July 8, 2011 at 6:35 am
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...
July 7, 2011 at 10:24 am
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...
July 5, 2011 at 12:26 am
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 -...
July 4, 2011 at 9:42 pm
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)
June 10, 2011 at 12:43 pm
no need to shout.
create a top values query and sort in ascending order.
June 9, 2011 at 3:41 pm
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...
June 6, 2011 at 12:28 pm
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...
June 5, 2011 at 9:35 pm
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,...
June 5, 2011 at 1:12 pm
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...
June 5, 2011 at 8:56 am
Outer join Products to the Sales and Returns tables. Do a totals query. Then you'll get a record for every Product regardless of whether it has had any...
June 5, 2011 at 8:49 am
FWIW, I took the SQL 2005 Developer cert exams. The Measure Up exams were significantly more difficult. (And realistic).
I'm really not sure having certs proves anything at all. ...
May 22, 2011 at 9:09 pm
FWIW, I would keep both in the same table at least for the time being. Then at least you can use the old/new keys to test that everything is...
May 14, 2011 at 7:51 am
Worked a champ! Thanks!
Pieter
May 8, 2011 at 2:26 pm
What if you partition the table on the date field and then you can drop the partitions you no longer want/need?
April 10, 2011 at 10:46 pm
Viewing 15 posts - 3,436 through 3,450 (of 3,482 total)