Frank,

Now that I actually READ the error that was posted I see that your were correct in leaving the listeral out of the Group By Clause. Of course had I...

Andy,

I think this would be nice. Often I like to refer back to the previous posts when I'm replying. Now if I want to do that I open another window...

I think Tom stated it best. Your design with the 3 tables allows you to have the situation where you need to add a new type of address or phone...

Christy,

What Sloan has said is good advice. In your case what you might do is take his approach and modify it slightly. Take the data that he suggests you put in...

Frank,

I had written it that way at first and then I thought about the way that the join was being done in Access and changed it back to that join....

Can you post the script you used to call the SP?

It should be something like

EXEC yoursp N'Greekcharfield1', N'...etc...

OR

DECLARE @GreekField1 nvarchar(500)

SET @GreekField1 = N'Greekdata'

EXEC yoursp @GreekField1

BTW: Rather than using...

The FOR READ ONLY shouldn't make any difference. The way I have declared the cursor just makes it use a local variable rather than using a global cursor (I firmly...

What you will want to do is use DBCC CHECKIDENT... to reseed your identity column to the value you want after doing the "merge" of the two tables. The problem...

chisholmd,

I have never had a problem with it. Try the following and see if it works for you...

SET NOCOUNT ON

DECLARE  @tblVar TABLE(somefld int)

DECLARE @iVal int

DECLARE @c cursor

INSERT INTO @tblVar...

I believe you should be able to use something like this....

SELECT ITEM_H.ItemNo

    , INV_LVLS.MaxOH - Sum(IsNull(PID.PQty, 0)) AS QtyReq

    , "Rush - 4 Weeks" AS TimeFrame

FROM (ITEM_H

        LEFT JOIN...

You will need to use dynamic sql for your create statement.

DECLARE @sql nvarchar(4000)

set @sql = 'CREATE DATABASE FOOBAR2.... FILENAME= ' + @dirMDF

exec sp_executesql @sql

Just to clarify Allen's point the logical filename is what comes directly after the MOVE and before the = sign. You can either use the SP or you can go...

Hmm... did you set up the service to run under your "Domain" account? If not I would try that.

If you look in BOL at the topic "Estimating the Size of a Table" it will outline how to actually calculate the rowsize and table size. It also talks about...

Henk,

I think what you need is something like this...

Backup your original DB.

BACKUP DATABASE Northwind TO DISK = 'D:\Junk\Northwind_data.bak'

Then run something like this...

RESTORE DATABASE Northwind_Copy

FROM DISK = 'D:\Junk\Northwind_data.bak'

WITH MOVE 'Northwind' =...