Paul Morris-1011726 (2/1/2012)

---

What I need to send...

Tom

ChrisM@home (2/1/2012)

---

Too quick for me today...

HowardW (2/1/2012)

---

Steve Jones - SSC Editor (2/1/2012)

---

GSquared (2/1/2012)

---

HowardW (2/1/2012)

---

Is this guy annoying the hell out of anyone else?

Not sure whether to call it spam or not, but most of his...

WHERE date_received >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0) AND

date_received < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)

Sean Lange (1/31/2012)

---

You could always just add a little string manipulation and still keeping is a lot easier to read.

SELECT

CAST(((DATEDIFF(minute,StartTime,EndTime) - BreakPeriod) / 60) AS VARCHAR(5)) + ':' +

LEFT(CAST(((DATEDIFF(minute,StartTime,EndTime)...

dinesh8804 (2/1/2012)

---

I have two tables.suppose i have table1 columns-Marks int and in table2 -comments varchar(10) and i have different no of rows in both tables.I want to combine and display...

No problem.

If you need any help understanding it, try these great articles by Paul White: -

Understanding...

What has vb.net got to do with this question?

SELECT *

FROM #AF_Fraud_Jan_24 af

CROSS APPLY (SELECT COUNT(*) AS CountOfSOSCalls

FROM #StagingClaCases scc

...

I guessed the intention of the question correctly, this time, but we could do with a correction for those that didn't.

Old

SSIS an option?

Not really a SQL question 😛

It has been a while since I did anything like this, but I think you need to suppress the error report.

for /f "tokens=1 delims=" %%b...