More "guidelines" than "rules". They...

codebyo (10/31/2011)

---

No problem. 🙂

If you need all possible months between two dates you could use something like this:

DECLARE @STRING VARCHAR(500),

@DATE1 DATETIME,

...

Thomas Abraham (10/31/2011)

---

I definitely can see both sides of that way of thinking. Pride makes you want to be able to answer a question from your own memory/knowledge. I get...

Hello and welcome to SSC!

It seems that your DDL script has become detached from your post, or perhaps you were unaware of the benefits of providing one.

When you have time,...

farooq.hbs (10/31/2011)

---

Hi All,

I need a help on date Diff Concept..

I want to get the Month Number of...

Thomas.s (10/31/2011)

---

hi

i m having table like this

empno ename sal

1 kkk 21000

2 ...

Knocked this up in a couple of minutes. It's based off what I remember from my previous job, in my new job I'm strictly a developer so I don't perform...

Had no idea, took a random stab in the dark and got it right 🙂

phil.wood 94423 (10/31/2011)

---

How is knowing this going to help me in my career?

Please let's avoid pointless...

SELECT DATEADD(dd, DATEDIFF(dd, 0, @OrigDT), 0)

--EDIT-- Mis-read your post, the above removes the time from a datetime. Should have been like the below

SELECT DATEADD(dd, 0-DATEDIFF(dd, 0, @OrigDT), @OrigDT)

emdavies82 (10/27/2011)

---

Thanks so much so it should be like this:

SELECT COUNT(Address_Line_1) AS EXP2, (Post_Code)AS Expr1, Address_Line_1

FROM Pers_Static_Personnel_History

GROUP BY...

iluvmyelement (10/26/2011)

---

When pulling data, I need to summarize totals by Week of the current month.

e.g. if the 1st of the current month falls on a Wednesday, Week 1 would be...

Ninja's_RGR'us (10/26/2011)

---

Cadavre (10/26/2011)

---

Ninja's_RGR'us (10/26/2011)

---

You can try with

FOR XML PATH.

I've seen that suggested in the past. I don't have a full understanding of what it does so I recommend...

Ninja's_RGR'us (10/26/2011)

---

You can try with

FOR XML PATH.

I've seen that suggested in the past. I don't have a full understanding of what it does so I recommend you read...

heh. I'll attend by...

phual (10/26/2011)

---

Both do the job nicely and are MUCH simpler than anything I was coming up with (although the second has the consequence that it converts 'fish; & ; chips'...