Brandie Tarvin (5/27/2016)

---

I just heard from my husband (who works at Deutsche Bank) that there is a holiday coincidence for Monday. A confluence of several countries having bank holidays at...

ZZartin (5/27/2016)

---

Brandie Tarvin (5/27/2016)

---

I just heard from my husband (who works at Deutsche Bank) that there is a holiday coincidence for Monday. A confluence of several countries having bank holidays...

Age (of)

That's a good effort. You can do updates to several columns in a single statement.

Declare @DayInterval INT;

Set @DayInterval = Datediff(day,(select MAX(dviendtime) from PrmDeviceVisit),GetDate());

Update dbo.PrmDeviceVisit

Set DviEndTime = DATEADD(DAY,@DayInterval,DviEndTime),

...

I was just showing you the formula. You need to generate the UPDATE yourself.

fergfamster (5/26/2016)

---

Ok, well i cant give you all my code. If you wanted to create an Inline function and have separate queries returned based on an IF statement is the...

This might give you an idea.

DECLARE @Sample TABLE(

DviStartTime datetime,

DviEndTime datetime

);

INSERT INTO @Sample

VALUES

('2016-04-18 22:27:33.000', '2016-04-18 22:36:21.000'),

('2016-04-18 10:11:23.000', '2016-04-18 10:16:29.000'),

('2016-04-17 20:14:01.000', '2016-04-17 20:36:46.000'),

('2016-04-16...

When you say folder name, is it the root folder or the parent folder?

Can you give several examples? Mainly to get exceptions to the rule. Don't forget to include expected...

jasona.work (5/26/2016)

---

I'm really starting to hate the SSIS Catalog...

Two servers, same permissions on both. On one, the user can deploy their project no problems (with the deploy project wizard.)

On...

Courage

drew.allen (5/26/2016)

---

Do not EVER do this. I believe that there are only...

Don't get me wrong. I can help you, that's why I gave simple hints on were to fix the code.

But if I just give you the answers, you won't get...

drew.allen (5/26/2016)

---

Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly not in...

Here are some errors:

- You didn't create the specified columns on your view, you just mentioned them. You need to use a join to get information from the employees...

Probably this could help. The problem is that you have a char(10) and you're looking for 8-character strings.

SELECT *

FROM dbo.Postcode

WHERE p_code LIKE N'___ ___ ';