Lowell (4/10/2012)

---

hbtkp (4/10/2012)

---

i am getting result like

item1 item2 item3

1 pen 34

1 ...

richard.noordam (4/10/2012)

---

yes this is option two. :-). I think I'm looking for the 'minimal' approach here. or basically, the least # of times i have to run the...

gmamata7 (4/10/2012)

---

Hi Using the below script to insert database into a table.

But the data inserted is wrong and I want to rollback.

But it looks like, it's already been committed.

I want...

when you load the data into your staging table does the data then match the table in your database you will be loading the data into? if so i...

what about a calender table. add the dates to run to the calendar table and have a job that runs each day check the table if the current date...

Lynn Pettis (4/10/2012)

---

ColdCoffee (4/10/2012)

---

Lynn/Capt.Hector , correct me if i am wrong, we dont need DATEADD+DATEDIFF in the GROUPBY/ORDER BY; just DATEDIFF would do.

Why i say this, SQL needs to just...

damn beat me to the convert for the date type

some thing like this may work.

SELECT DATEADD(MONTH,0,DATEDIFF(MONTH,0,[datefield])), COUNT(*)

FROM table

group by DATEADD(MONTH,0,DATEDIFF(MONTH,0,[datefield]))

if you would like tested code can you post the DDL (Create table scripts) and some sample data (Hard coded...

well lynn you beat me to it. had almost the exact same code.

Can you post the DDL (create table script) and hard coded inserts for us so we can be sure on the data and table structure. if you need help...

jitendra.padhiyar (4/9/2012)

---

Thanks Vinu for suggestion, i tried it but it did not work when I save the changes.. its give me an error..

"Saving changes is not permitted. The changes you...

abecker 5532 (4/7/2012)

---

Thank you so much for your reply. I can't test your query now, but I don't think it will work because lastD is not unique? idD is not...

Jeff Moden (4/6/2012)

---

capn.hector (4/6/2012)

---

Jeff Moden (4/6/2012)

---

capn.hector (4/5/2012)

---

Jeff Moden (4/5/2012)

---

Considering that you input data is only a half of what your output data is, your going to have to describe how...

thats one way but an inefficient way. all the cte's will be compiled into a single query by the optimizer but may not achieve the optimal plan if you...

Jeff Moden (4/6/2012)

---

capn.hector (4/5/2012)

---

Jeff Moden (4/5/2012)

---

Considering that you input data is only a half of what your output data is, your going to have to describe how the data describes...