sqlguy-736318 (10/12/2016)

---

I'm calling a sproc via ADO.NET in a C# console app. However, it appears that old sproc columns are being returned. I had another developer double-check that the connection...

Barkingdog (10/12/2016)

---

We have 2 tables with the same schema on different servers. Let's call them TblSrc and TblDest. We need to "synchronize" the data in both tables based on...

Please tell us...

yogi123 (10/12/2016)

---

Hello

I have one task, where i need to generate csv files which has max 500 records in it. so let's one file has 1250 records, then i need to...

dianerstein 8713 (10/12/2016)

---

I am trying to load the valid lockID values into the cust table with the following sql:

DECLARE @Startlockid INT=0

DECLARE @MyTableVar table( lockID int);

insert...

dianerstein 8713 (10/12/2016)

---

In a sql server 2012 database, the first insert statement works that is listed below works:

insert into [dbo].Cust (custid,[number],lockid)

values (134,118692,1098)

The following insert statement does not work...

DamianC (10/12/2016)

---

Using your suggestion sergiy, I've managed to get it working

One question

You have:

declare @MaxID bigint

select @MaxID + MAX(ID) From TargetTable (TABLOCKX)

This returns NULL

I've amended it to (changed + for =)

declare...

lindsayscott23 (10/12/2016)

---

Hi Grant,

Thanks for your help and advice here - really appreciated.

That's a great suggestion to use a backup to create the development environment; I wouldn't have thought of...

Chris makes a good point. It's unclear from your initial post what a single row in the fact table represents. A transaction? A product price snapshot?

Sergiy (10/11/2016)

---

You may add ROW_NUMBER to the recordset being inserted and add its values to MAX (ID ) of the table:

begin transaction

declare @MaxID bigint

select @MaxID + MAX(ID) From TargetTable (TABLOCKX)

INSERT...

After saving the CSV, open it using Notepad or some other text editor. Do not use Excel to open CSV files.

Try exporting from Excel to CSV and importing from the CSV.

komal145 (10/11/2016)

---

I think to be more specific, i am deploying the solution from visual studio. the other solution has no issues. only the solution which I am working has this.

Why...

komal145 (10/11/2016)

---

I have created a project parameters at my solution level and after i deploy the solution to the server ,at Integration Service catalog level i have to configure my...

wendy elizabeth (10/11/2016)

---

I provided the ddl on the original post. here is sample data:

SELECT [lockID] = 4336

,[schoolID] = 134

...