May be, something like this?

WITH CTE(ID_NUMBER ) as

(

select distinct O.ID_NUMBER ID_NUMBER from Table as O

WHERE (O.FIRST_DATE BETWEEN '20090101' AND '20091231')

)

select ID_NUMBER , count(ID_NUMBER) R_Count from CTE

GROUP BY...

I dint exactly understand what you wnat to do, but as far i could comprehend from your post, here is a set of code that might interest you.

1. INSERT only...

Seth, yes. A copy-paste is not enough. And also, i need T-SQL statments only. THis is kind of automating an existing work-process which is using SQL and Excel 2003. He...

I don't know what the best possible solution is, but i will try the following step:

1. Write a SP in Database1 that will check if a row is already existing;...

Repeated post. Please pour in your suggestions and replies at the following location http://www.sqlservercentral.com/Forums/Topic915042-392-1.aspx.

Thanks!

Buddy, this cant be done, unless you provide the Schemas of the tables, some sample data , a refined question and clear-cut desired results. Then, i promise you, there are...

Reg, for Access 2003, you will have to use the brackets...

Quite possible, buddy.. but you will have to tell us atleast the description of the house; we ourselves will find out the address and the fastest way getting there.. now...

Simon, i would suggest that, u just

1. create a stored procedure with only one parameter.

2. create a comma-delimited string with the Table_Name+Columns.

3. Pass this concatenated comma-delimited string to...

Jeff Moden (4/30/2010)

---

ColdCoffee (4/29/2010)

---

Sri, sorry for saying this, but your question is one of the vaguest i have seen in my stint with SSC..

There is absolutely no information about...

Sheesh, NewBee..:blush: that one awesome appreciation.. i would say u are a Honey Bee.. lol...

Sri, sorry for saying this, but your question is one of the vaguest i have seen in my stint with SSC..

There is absolutely no information about the emp table...

Here is another method. Again , Thanks for the Setup BOB!

;WITH CTE(RecID , RecType , Hierarchy , Msg,R)

AS

(

select RecID , RecType , Hierarchy , Msg, ROW_NUMBER() OVER(PARTITION BY RecType ORDER...

Another variation of the same functionality but with much faster code

;WITH ORDERED_TABLE (ID, period1, R1, pname1, R2)

AS

(SELECT ID1

,period1, ROW_NUMBER() OVER(PARTITION BY ID1 ORDER BY...

Thanks, NewBeeSQL