Lowell, actually, if u look at the new dataset the OP provided, there are dups.. so, a GROUP BY of managerID with COUNT > 1 wont work on dups..

You...

Awesome.. happy to be of some help 🙂

Yes you can;

something like

CountofRows = COUNT(*) OVER(PARTITION BY YourGroupingcolumn)

Change the datatype of the column C in the table variable to VARCHAR(5)...

So you will need, C1, c2, c3, c4, c5.... etc etc depending on the rows, right?

For your sample data:

declare @testtable table

( A int, B int, C time , D datetime)

insert into @testtable values

(1 , 61 , '1:00' ,'5/10/2011 2:00')

,(1 , 61 , '2:00', '5/10/2011...

Will all A B combination have only 3 rows each ?

navireddy.g (5/23/2011)

---

How to get previous month id for an entry if present month id field is null?

I have some many records in the table,i have to get the above mentioned...

Try this:

DECLARE @Parent TABLE

(

ParentID INT

)

DECLARE @child TABLE

(

ChildID INT,

ParentID INT

)

-- Inserting Sample Data

INSERT INTO @Parent

SELECT SPT.number AS ParentID

FROM master.dbo.spt_values SPT

WHERE SPT.number...

You're welcome, Mike.. does that query fit your requirement? And were the comments enough and informative?

As promised, here is the solution to it:

; WITH DistUserCnt AS

(

--== Get the distinct user count per department

SELECT Department, COUNT(DISTINCT UserID) DistUsrCnt

FROM Permissions

GROUP BY Department

)

, BaseGrps AS

(

/*

The GROUP BY...

I...

Why not use a JOIN ?

If JOIN is a prohibited substance (:-D) , then u can use something like

SELECT *

FROM MainTable

WHERE col1 in ( select col1 from SubTable)

TroyG (5/19/2011)

---

thats awesome! I was trying to do recursion with the cte but my brain was just not kicking in and sorting it out for me. Thanks for that. This...

You may wonder where i got the ID column from. From the purpose of running totals, if adopting my code, it requires an unique ID to each row; thus, i...