Being that you have sql 2005 there is no such datatype as date. As you said you have to use datetime. You can display your datetime field in any format...

The IsNumeric function has been the cause of a lot of failed code over the years. It is really not a good way to accurately determine if a value is...

You have mixed datatypes in your case statement. The first case will be a decimal and then your case else is trying to put a string in that column. You...

Is it an actual foreign key as established on the table or is it only a logical foreign key?

Sounds like you have an order by on your select statement that is different than the order by in your row number?

select *, ROW_NUMBER() over (order by N) as RowNum...

I don't know how the task in SSIS works but there are countless books and examples of regular expressions. C# has a regular expression class. Not exactly sure what you...

Here try this link. It has plenty of great examples.

Ninja's_RGR'us (8/2/2011)

---

For the 3rd...

Are you quoting me to say that my suggestion is also yours or did you forget to include your comments?

You got your parameters mixed up in CHARINDEX. 😉

DECLARE @FullName varchar(25)

SET @FullName = 'COYOTE^WILE^E'

--SET @FullName = REPLACE(@FullName,'^','8')

SELECT @FullName -- = COYOTE8WILE8E

SELECT CHARINDEX('^', @FullName,1) -- = 0

I wouldn't even try to roll your own. Take a look at Jeff Moden's string parser[/url]. What you have is a delimited string using ^.

WOW!!!! There is no way anybody is going to decipher that for the wages we make around here.

There is a ton of stuff in there that is crippling your...

Sounds like the OP is used to working with Access where if you write a query like that and the parameter is not passed to the query it will create...

GSquared (8/1/2011)

---

I started write a refutation of just about everything Joe wrote, because he's wrong at just about every level, even his use of English, but then I decided not...

You could achieve this fairly easily in an instead of insert trigger.