foo fighters

http://www.convertcsv.com/generate-test-data.htm

CREATE TABLE RandomText(

ID INTEGER NOT NULL PRIMARY KEY

,randomText VARCHAR(702) NOT NULL

);

INSERT INTO RandomText(ID,randomText) VALUES

(1,'Puv loluh...

Yet Another DBA (7/24/2015)

---

just started reading this.....thanks ...food for thought.

or this....similar to Steve but altered the filters accordingly

SELECT ED.EMPLID, ED.CHECK_DT, ED.AL_DEDCD, ED.AL_AMOUNT AS HSA_DEDUCTION, EM.AL_AMOUNT AS EMPLYR_HSA_CONTRIB

FROM PS_AL_CHK_DED AS ED

LEFT OUTER JOIN PS_AL_CHK_MEMO AS EM

ON ED.EMPLID = EM.EMPLID

AND ED.CHECK_DT...

Jeff Moden (7/26/2015)

---

There are a couple of things to note. First, there are NO matches in the data where a company match actually occurred according to the match of...

bgolembiesky 4883 (7/25/2015)

---

Here you go. I just took a very small off-cycle payroll on 7/6/2015 for the insert records into the 2 tables. Thank you for your help. The only...

Rithmetic 😀

ok...glad to hear it.

seems I was posting my response whilst you were editing yours. no worries

can you clarify your rules please.....do we exclude weekends...

SELECT ID,

CASE WHEN COUNT(*) OVER(PARTITION BY ID) > 1

THEN ISNULL(Name + ' ' + Identifier, Name)

ELSE Name END AS Name,

Identifier

FROM SampleData;

Edit...seems you have already changed your mind re NULLS...

SSRS Newbie (7/23/2015)

---

sgmunson,

Thank you for your response. The code you suggested works. I need to assign a Scheduled Ship Date to the closest Monday. For example- if the Requested Delivery...

conduct

coherent

antithesis

can you amend this

http://www.sqlservercentral.com/Forums/FindPost1671071.aspx