Charles,

You have mised two different methods of joins. You start out using the old method joins where you list the tables in the FROM clause and make the join...

Frank,

Thanks for your reply. It seems that the Site Owners (The great people that they are) have added a new listing under My Accounts that should take care of...

What about giving them permission to run a SP in the production database that runs the same scripts. I would also have in the SP a means of logging...

Frank,

The problem is that the only way I have found to get to your profile is through one of your threads that you either authored or replied to. This...

DECLARE @vcItem varchar(50), @dtStart datetime, @dtEnd datetime

SET @vcItem = <Item to Search For>

SET @dtStart = <Start DateTime>

SET @dtEnd = <End DateTime>

IF EXISTS (SELECT NULL FROM Orders WHERE Item = @vcITem...

There are numerous way to do this. The way I prefer is throught the use of derived tables.

CREATE PROCEDURE p_Get_YearlySalesByMonth (

@iYear int)

AS

SET NOCOUNT ON

SELECT...

Have you tried setting the import up in a DTS package? I believe it is the fourth tab on the transformation object that allows you to set the IDENTITY_INSERT...

You may have also max'ed out your virtual memory on your computer. I have experienced delays in SQL statements when I have many windows open but work fine when...

Is the domain account used for the agent also a member in the Administrators NT Group on the server?

Thanks everyone for your advice. The issue turn out to be some software from CA called ETrust (anti-virus software) that did an automatic update of its software on the...

Instead of using an inner join:

Select field1, field2 from table1 INNER JOIN table 2 on field1 = someid

Try using an outer join:

Select field1, field2 from table1 LEFT JOIN table 2...

Assuming the cust_id = dup_code, why not do a simple select count of all matching records between the two tables

SELECT @Count = COUNT(t1.*)

FROM unique_cust t1 INNER JOIN unique_cust t2 ON...

mccork,

The tape backups finished at 10:30 pm. The database dumps start at 12:05 am.

This job has been running successfully for the past 4 months, and now it is failing...

try: sp_spaceused '<table name>'

I usually set this SP into a loop of each table I want info on and save the results to a temp table to be displayed.

...

I forgot to mention, in the ORDER BY clause, if you do not designate a sort order for a column, it will default to ascending (ASC).