Can i Do Delete from table and the INSERT new record into the table?

what are the potential hazards?

Hi,

Thats a question....where should i use the update statement...in front of select or after group by...the thing is when i set my column names equal to result table column names...

Hi John

how can i update the final table with the result of these query because INSERT INTO command adds additional rows with same data everytime. I just want to UPDATE.

MyTable

Id Fruit

-- -----

1 Apple

2 Banana

3 Apple

4 Watermelon

5...

Hi Guys,

I had a success in what initially i was trying to do. Thanks for your help.

I have another question. Basically what i need is put results of this query...

its Just two columns

as described in the example in my first post.

DECLARE @cnt int;

SELECT @cnt = Count(Distinct Fruit) from [MyTable];

UPDATE Result SET Count=@cnt;

Hi John,

As i am a beginner to SQL..

I am struggling to write a query for this. So far i managed to write a query which count distinct values in a...

Hi,

PLEASE CAN ANYONE HELP ME IN THIS....AS I AM NEW TO MS SQL

rEGARDS,

BILAL