Not 100% sure what you are trying to do here. It sounds like you want to delete duplicates from a table? This seems like an awfully complicated way to go...

hillerz19 (10/10/2012)

---

Hi Sean Lange,

I am a new to SQL. And i try doing looking at a book but gives me error and lots of it. i am not sure how...

This looks a LOT like homework. What have you tried? What do you think you need to change?

Without something to work with it is impossible to know what you are doing here. You said you have repeated data but there are no duplicate rows in your result...

Eskandari (10/10/2012)

---

Consider this Table :

CREATE TABLE Test ( field_one nvarchar(10) );

DECLARE @i int;

WHILE @i<= 1000

BEGIN

...

As Stewart said that will only work for single row updates but it also will fail if the table is empty. The values you are getting into your variables are...

To get the count of cities for each state you need to remove City from the select list.

SELECT [State]

,COUNT(DISTINCT[City]) AS City_Cnt

FROM [dbo].[MySalesDataTableAggregatedMonthly]

WHERE [State] IS NOT NULL AND [City] IS NOT...

Be careful with approach. Deleting tables just because they haven't been used in a couple months can very likely come back to bite you. What about reports that are only...

jbalbo (10/10/2012)

---

Hi,

I ran an update on one record to update the datetime using current_timestamp

I might be losing it...

but before the update when I looked at a date/time field its looked...

sqlstud (10/10/2012)

---

Hi,

I have table "Trial1"

One of the columns is

DATERECEIVED DATETIME NULL

Loading data from Excel to staging table using ssis 2005.

Datareceived column contains data as below

17/12/2010

18/12/2011

DECLINED

NULL

I need to load...

nitin.varshney (10/10/2012)

---

actually there is no need to aggregate the some value. only need to identify the distinct records. which also can be possible using the group by clause. so i...

Fantastica (10/10/2012)

---

Bit of a late answer, but found this usefull when I had this same problem.

http://www.syntaxwarriors.com/2012/t-sql-splitting-strings-into-multiple-rows/%5B/url%5D

Even has an example of how to make sure that any other columns of data...

Gianluca Sartori (10/9/2012)

---

Sean Lange (10/9/2012)

---

Gianluca Sartori (10/9/2012)

---

Sean Lange (10/9/2012)

---

Reason #91029037403884 you should ALWAYS use the proper datatypes. Datetime should ALWAYS be stored in a datetime column. Otherwise you end...

Gianluca Sartori (10/9/2012)

---

Sean Lange (10/9/2012)

---

Reason #91029037403884 you should ALWAYS use the proper datatypes. Datetime should ALWAYS be stored in a datetime column. Otherwise you end up pulling out your...

You're welcome. 😀