Thank you both for the feedback, I just wish I still had the time to hang out here like I used to. I think I have forgotten more in...

asbains8 (10/19/2010)

---

Sorry I made a typo on my original request what I meant to say is I would like to exclude records which are less than 14 days from the...

asbains8 (10/19/2010)

---

Thanks for that i am a newbiw on these forums will remeber for next time, i am using SQL 2000 so ROW_NUMBER wont work is there an equivalent in...

Jim, you can use the data import wizard, or lookup OPENROWSET() in BOL. With OPENROWSET, you can select directly from the spreadsheet into a temp table, or any other...

Mitch, I'm not sure if you are still having a problem, since this is an older post. But I just couldn't resist pointing out that this is absolutely terrible...

Michael, there are many places you could start, but...

Martin, to Waynes point, you really need to give us more information to go on. Without it, we have to make assumptions about what you have, and what you...

kschuler-851405 (8/18/2010)

---

charindex returns the start position of the searched for expression (":"), which is in position 21 of the string in this example; starting at position 14 of the string...

Andrew, I think I have mis-interpreted the BOL example, which is as follows...

DECLARE @document varchar(64)

SELECT @document = 'Reflectors are vital safety' +

...

kschuler-851405 (8/18/2010)

---

try this

DECLARE @string VARCHAR(100)

select @string = '08/01/2010 - J.Smith: just some text'

SELECT

[Date] = SUBSTRING(@string,1,10),

...

I think you want to change this to...

SELECT BI.BRCFORMID FROM BRCFORMITEM BI

inner join Lookupproducts...

You could search BOL or google for OPENROWSET and SELECT INTO.

tripri, search BOL(Books Online) for 'ALTER TABLE' for syntax, and you could probably find on google endless descriptions of what Jeff was talking about. Basically, here is how you...

Novicejatt, again, this is a 2000 forum, and it seems like maybe you have 2008? Anyhow, as far as the one time uploads are concerned, I personally find OPENROWSET...

Are you sure you posted in the right forum? SSIS was new to SQL Server 2005. SQL Server 2000 has DTS.