cmc123 (11/23/2015)

---

Hi,

can someone help me in writting a cursor with following update statements .This statement will updates each database in an instance of SQL .

UPDATE dbo.Property

SET USERTXT1 =

(SELECT...

Your question is not clear to me. Please provide sample data, DDL and desired results in a consumable form, as described in the first link in my signature.

Erm. The hyperlink in my post.

caojunhe24 (11/20/2015)

---

@Phil Parkin

I am using M:\Products & Services\Business Planning & Analysis\ProjectOzRawDataFile_DoNotDelete_Atif\RawData\SAPARawData_PatBell in my package not UNC path I guess so if I have to use UNC path I have to...

John Meyer-239467 (11/20/2015)

---

One advantage to the varchar solution is that (if it was converted to use ISO data formats), the end dates could have 'T23:59:59.997' added to them so the...

caojunhe24 (11/20/2015)

---

And I saw some people had same issue with job agent and they solved problem by making folder as shared folder. But the point is my folder is in...

Can you confirm that you are using a UNC path (\\server\share\...) and NOT a drive letter (X:\data\...) ?

Sounds a bit too damp for my liking. 'Whet' is the word I think you were looking for...

A possible alternative is iff(), which can be used in a SELECT:

select iif(datename(weekday,...

Fernando Margueirat-273899 (11/19/2015)

---

Phil Parkin (11/19/2015)

---

Jack (11/18/2015)

---

I remember reading an article that tested this with many thousands of records and there was a material impact. Since then I have always...

Jack (11/18/2015)

---

I remember reading an article that tested this with many thousands of records and there was a material impact. Since then I have always used the more efficient...

drew.allen (11/19/2015)

---

I actually tried to create a test on SQL 2012 (don't have SQL 2014 available) and when I tried to create the unique constraint, it failed saying that it...

If you create a unique index on GroupID & PayorID, does that fix it?

Shudder.

Error? Or message box?

I tested it this morning and it worked perfectly.

Try with an Excel file on your local hard disk. Maybe you have some network or permissions issues going...