Sounds good, thanks everyone!

Sorry didn't mean to be vague!

Example:

You have a list of data:

a = 1

b = 2

c = 3

d = [1:1:100] (an array of values 1-100 - 1, 2, 3 ... 100)

Since...

Jeffrey Williams (4/24/2009)

---

You don't insert columns - you insert rows. Each insert statement is going to insert 1 or more rows into that table.

It sounds like you are trying...

Jeffrey Williams (4/24/2009)

---

See if you have a column defined in MyTable with a default defined as 'TBD'.

When inserting into a table, you have to provide values for all columns that...

interestingly enough, I tried going from the successful version i have in SQL 2005 and bring it in to 2008 but all my relational data dissapeared :unsure:

I used the Access migration assistant to upsize the database from access 2007 to SQL Server 2005. However, it only transferred the tables, data, and relational information. I have to...

I'm sorry but could you please clarify?

Sorry if I wasn't clear before, but in my access system a column value is

"70 or 60 or 81"

and when the query is run that specific value in Access is...

I have to leave my office until Friday, so pardon my lack of response until then!!

😀

Msg 245, Level 16, State 1, Line 5

Conversion failed when converting the nvarchar value '77 or 70 or 81' to data type int.

ah, it seems to be working ok, except that I have a value in "mycolumn" = 70 or 60 or 50" which doesn't successfully convert. Is there a way to...

Thanks for the reply, I'm still a complete SQL Server newbie so it will take me a bit to get this to work, but I'll post success/failure as soon as...

Here is exactly what I'm trying to do:

I have a column with various values, but for sake of shortness, one of those values is 65484.

In an Access 2007 query,...

Have yet to find a working solution to this problem, anyone else have any ideas / pointers / vast amount of awesome knowledge on this issue? 😀

Thanks for your help, I figured it out. Its a lot easier than it appears at first. 🙂