An introduction to TSQL brute force. When all else achieves FAIL state:
USE [cpqaAnswers]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[cpqa].[tblKD]') AND type in (N'U'))
DROP TABLE [cpqa].[tblKD]
CREATE TABLE [cpqaAnswers].[cpqa].[tblKD](
CustomersID uniqueidentifier,
CompanyName nvarchar(50),
RegistrantName nvarchar(50),
AddressLine1 nvarchar(50),
AddressLine2 nvarchar(50),
City nvarchar(50),
[State] nvarchar(50),
Country nvarchar(50),
Zip nvarchar(20),
PhoneNo nvarchar(50),
MobileNo nvarchar(20),
FaxNo nvarchar(20),
Website nvarchar(250),
Email nvarchar(250)
)
Put some data in a .txt file ... call it data.dat ... use a format that seperates values with a single {TAB}
BULK INSERT [cpqaAnswers].[cpqa].[tblKD] FROM 'C:\cpqaAnswers\KD\data.dat'
CREATE TABLE [cpqaAnswers].[cpqa].[tblKDIdx](
Idx [int]IDENTITY(1,1),
CustomersID nvarchar(555),
CompanyName nvarchar(50),
RegistrantName nvarchar(50),
AddressLine1 nvarchar(50),
AddressLine2 nvarchar(50),
City nvarchar(50),
[State] nvarchar(50),
Country nvarchar(50),
Zip nvarchar(20),
PhoneNo nvarchar(50),
MobileNo nvarchar(20),
FaxNo nvarchar(20),
Website nvarchar(250),
Email nvarchar(250)
)
INSERT INTO [cpqaAnswers].[cpqa].[tblKDIdx]
SELECT * FROM [cpqaAnswers].[cpqa].[tblKD]
SELECT * FROM [cpqaAnswers].[cpqa].[tblKDIdx] ORDER BY [Idx] DESC
Now leverage the TOP 1 factor ... or use a WHERE clause and the result of:
(SELECT COUNT(*) FROM [cpqaAnswers].[cpqa].[tblKDIdx])
as the [Idx] equality to return the last record.