Hi mashtal, truely speaking, i am unable to extract info from your post. I reaaly cant comprehend what you want from the code!! People here are unpaid volunteers who put...

You're welcome, Wellington! 🙂

Good to see that your code is fixed!

Cheers!!

Nice intuitive question and an equally impressive explanation, Mr.Black Cap. Learnt quite a few behind-the-scenes of datatype conversions and roundings!

Thanks!

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...