Viewing 15 posts - 4,666 through 4,680 (of 9,643 total)
As Gail has mentioned it might depend on who is teaching the class.
Here's my take otherwise.
If the main thing you are interested in is learning and getting in-depth knowledge, then...
July 20, 2009 at 9:37 am
I understood you to mean that you could have several different ways the manager wants to look at the data. If it is only those 2 then I would...
July 20, 2009 at 9:36 am
Please run this against the same database and post on the results:
SELECT @@VERSION AS version,
SERVERPROPERTY('ProductVersion') AS version1,
...
July 20, 2009 at 9:33 am
You have to put a ";" before the WITH. It's a little annoying, but it is required. You either have to end the prvious statement before the cte...
July 20, 2009 at 9:12 am
This can be done. Here are a couple of tips that should help. Check out the STUFF() function in BOL and lookup Tally table here on SSC. ...
July 20, 2009 at 8:49 am
Your options are either to limit the selections the manager has and run a specific stored procedure for each option, return the all the detail data and do all the...
July 20, 2009 at 8:40 am
Are you running SQL Server 2005? That statement should work on 2005/2008 against any table. Can you post the actual table structure?
July 20, 2009 at 8:28 am
July 20, 2009 at 1:03 am
I believe you are getting this error because there is no PK or Unique Index on the table so SSMS can't identify what to delete.
Behind the scenes SSMS is running...
July 17, 2009 at 3:48 pm
Looks like the error is being returned from the mail server because your mail server limits the size of mail messages. I don't think this is a SQL Server...
July 17, 2009 at 2:31 pm
Yes the restore to a new or temporary database is the way to do this.
The syntax for restoring a backup to a different database is this:
RESTORE newDatabase FROM DISK='Path to...
July 17, 2009 at 2:29 pm
Isn't this something that should be handled in the application, not in SQL Server? The application receives an error message or time out message from SQL Server when there...
July 17, 2009 at 2:23 pm
Jeff has pointed you in the right direction.
July 17, 2009 at 2:19 pm
Try running with a recompile hint. You might be just re-using the cached plan.
July 17, 2009 at 12:52 pm
You may want to check out this blog post[/url] by Grant Fritchey as it applies to your query.
What happens if you remove the TOP operator.
July 17, 2009 at 10:12 am
Viewing 15 posts - 4,666 through 4,680 (of 9,643 total)