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

First, you really should simplify your code. I struggled through what you were trying to accomplish with your statement. I figured out that this section CONVERT(DATETIME,STR(YEAR(CreateDate))+'-'+STR(MONTH(CreateDate))+'-'+STR(DAY(CreateDate))

+' '+STR(DATEPART(HOUR,CreateDate))+':'+STR(DATEPART(MINUTE,CreateDate))+

':'+STR(DATEPART(SECOND,CreateDate))) serves...

Well, you could use a CASE statement or a UDF, but you would need to use it in both your SELECT clause and the WHERE clause. Otherwise you're going...

You need to use the IIF(<Logical Expression>, <True Part>, <False Part>).

Also, I think that your false part can be greatly simplified by using the DateAdd() function. Try the following...

I did a Google search and quickly came up with a number of web pages that tell you how to do this. There is a third-party transformation, but that...