You haven't provided enough information. Please read the following link about asking questions.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Grant has already guessed at the problem you are facing, but he shouldn't need to guess what...

I prefer using DELETE

FROM [TableName]

WHERE RowID IN (

<Subquery here>

)

I like this, because it's very clear which table you are deleting rows from.

Drew

glugingboulder (7/29/2009)

---

ok sorry about the poor formatting.

Basically i need to combine data from 2 tables into 1 that have no relationship to each other. It will transfered to a monitor...

You should not be joining on columns that contain Nulls, because, except for certain functions like IsNull(), any expression containing a null value evaluates to null under ANSI Standards. ...

I would use a CTE with a Row_Number().

WITH Rooms AS (

SELECT

Row_Number() OVER (PARTITION BY HotelRoom.RoomID ORDER BY HotelRoom.RoomID,...

In the properties for your Data Flow Task, there is a property called MaximumErrorCount. Set this to the number of errors you want to allow before failing the Data...

I recommend that you TEST your solutions before posting, even for something apparently this simple. It helps no one...

Iron Chef SQL (7/29/2009)

---

for some reason my if condition (to test if NULL then INSERT) inserts data no matter what.

I'm trying to figure out why but maybe it's something simple...

Wrong. If the tables are in a one-to-one relationship then a left...

Why don't you use

IF Not Exists (

SELECT ct

FROM ironchef.dbo.war_conferenceregistrations

WHERE eventmeetingsetupid = @eventmeetingsetupid

)

This has the advantage that it will...

Providing enough information is key to getting the help you're requesting. Check out this article http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Drew

Carefully reread Jack's response and you'll find the answer to your other question.

Drew

Because SQL doesn't process the statements from the top to bottom. Check out this website for more information http://blog.sqlauthority.com/2009/04/06/sql-server-logical-query-processing-phases-order-of-statement-execution/. The WHERE clause is processed before the SELECT clause,...

I was thinking something similar, but I would add a Having clause like HAVING Min(IsNull(Column_Name,'') 'creation_date' OR Max(IsNull(Column_Name, '') 'last_modified_date' You may also want to specify the...

Another option SELECT Convert(Datetime, Replace('20Jul 15:46:1', ' ', '2009 '))

Drew