Jeff Moden (3/4/2013)

---

Sean Lange (3/4/2013)

---

Ed Wagner (3/4/2013)

---

Thanks, Sean. Good article. You know, I'm consistently impressed by just how many different uses there are for the tally table. ...

You are...

You will have to move your where condition to the join also. I have to say that your tables look like they could use some normalization.

Something like this is maybe...

Well obviously your sample and your query don't quite match up. 😉

But you still have an inner join in here.

SELECT rc.ResultCode,

COUNT(a.AccountNumber)

FROM dbo.ResultCodes rc

LEFT OUTER JOIN dbo.Accounts a ON rc.ResultCode =...

asm1212 (3/4/2013)

---

Hey guys,

I have these result codes from one table...There are like 12 distinct ones...When I join to the another table to get how many accounts were associated with each...

Are you trying to figure out after the...

Excellent job setting up the problem. This is certainly possible using a tally table.

;with DateVals as

(

select SchoolID, min(CalendarDate) as StartDate, max(CalendarDate) as EndDate, datediff(day, min(CalendarDate), max(CalendarDate)) as TotalDays

from #x1

group by...

Looks like Lynn beat me to the punchline. 😀

sunder.mekala (3/4/2013)

---

Hi Friends,

I have a requirement where i have to write a Sql for :

basically i have 2 columns 'startdate_SK' and 'enddate_SK' columns in table 'A'

'startdate_SK' is a integer...

Just a rambling here...you seem to be somewhat concerned with storage space. You also have obviously realized the challenges of using a unique identifier as your PK. You have ended...

dhananjay.nagarkar (3/4/2013)

---

Hi friends,

Im new to TSql -

I have requirement to display date as 7/31/2013 but currently I'm getting it from DB as 2013-03-01 18:40:24.000.

any help on this will he...

It is very unclear what is going on here. Is your query working but the results are too slow? Is the query not working as expected? If it is a...

Ed Wagner (3/4/2013)

---

Thanks, Sean. Good article. You know, I'm consistently impressed by just how many different uses there are for the tally table. So simple in design,...

This should work based on your description.

declare @WeekOfYear int = datepart(week, getdate()) --10

declare @Year int = datepart(year, getdate()) --2013

declare @DayNumber int = datepart(weekday, getdate()) --2

declare @BaseDate datetime = cast(@Year as...

Hi and welcome to SSC. You seem to have a challenge you are dealing with. Unfortunately you haven't posted anywhere near enough information for anybody to be able to provide...