Activity overview
Latest activity by RRB
Correction: the prompt failures are ONLY related to the references to the "NewData" object. / comments
Correction: the prompt failures are ONLY related to the references to the "NewData" object.
Prompt Failure w/MERGE statements
<Extract>
MERGE Wine.Producer AS CurrentData
USING
(
SELECT DISTINCT ProducerID, ProducerName
FROM Wine.Import
) AS NewData
ON CurrentData.ProducerID = NewData.ProducerID
WHEN MATCHED THEN
UPDATE
...
Suggest List Does Not Show Newly Created Tables
This is just an example:
CREATE TABLE [Wine].[WineList]
(
[WineID] INT IDENTITY(1, 1) NOT NULL ,
[WineName] NVARCHAR(128) NOT NULL,
[RegionID] INT
)
GO
CREATE UNIQUE INDEX Wine_WineList_WineName ON...
I am experiencing this problem was well with much smaller scripts (approx 300 lines).
Running W7 64-bit, SQL Server 2008. / comments
I am experiencing this problem was well with much smaller scripts (approx 300 lines).
Running W7 64-bit, SQL Server 2008.