Or maybe my brain is making it harder than it really is. 🙂

No problem. I going to guess that you...

Thanks for the updated info. The problem here is...

You must have something funky in your data. The insert you posted works perfectly fine with either query.

What about this one?

select app.endtm

FROM dbo.[_import_2_1_AppointmentsWorking] AS app

where isnumeric(app.endtm) = 0

pamozer (2/5/2014)

---

I know the field. Its the endtm field. It is all numbers even though its being stored as varchar. The weird part is if gather all the...

That is because your intellisense needs to be refreshed. ctrl+shift+r

Wait a couple seconds and the "red squigglies" will go away.

Can you post your sample data as insert statements?

SQLRNNR (2/5/2014)

---

Sean Lange (2/5/2014)

---

WayneS (2/5/2014)

---

Sean Lange (2/4/2014)

---

What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow....

Duplicate thread. Please direct replies here. http://www.sqlservercentral.com/Forums/Topic1538311-391-1.aspx

Well as I quoted previously and tried to point out from BOL, if you pass NULL as the Offset it will APPEND the existing data.

Since we don't have table structures...

WayneS (2/5/2014)

---

Sean Lange (2/4/2014)

---

What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got...

My pleasure.

I am pretty sure that Jeff was thinking of using the DelimitedSplit8K function for this.

I create the ddl and sample data for you to demonstrate how you should post this...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

vahid.arr (2/5/2014)

---

hi everybody

I have two table that have many to many relationship so i add table between them.and this table column is Id of each table.my question is i want...