john_edman24 (1/31/2013)

---

i try to convert from access database to MSSQL Server but there's an error the error msg is "Attached table is not updatable because it has no unique index."...

duplicate thread. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1414381-1291-1.aspx

You don't want to use datepart(day...) here. That will return the day of the month. You want to use datepart(weekday...)

I like to use the full word instead of the abbreviation...

One other point is that if you use a unique constraint to function like a primary you MUST have the column defined as NOT NULL.

create table dbo.Car (

CarID int...

computer.mike (1/31/2013)

---

Only tried it once with the end user and can't remember error message. It didn't seem to matter at the time cause I knew they didnt have a...

What is the error message?

saxena200 (1/31/2013)

---

---------------------------------------------------

--The underlying IV Not working, kindly help

---------------------------------------------------

[/quote

"Not working" is not very descriptive. I am guessing you are getting "Must declare the scalar variable.." message???

I reformatted your code so it...

So put in a space or an underscore or something so...

computer.mike (1/31/2013)

---

I have a Excel spreadsheet that updates a table in SQL Server using ADO code. It works fine for me cause I am admin, but I developed for...

vlad-548036 (1/31/2013)

---

Thank you for your input.

the sole purpose for it is to generate unique sequential numbers...

Snargables (1/31/2013)

---

We just recieved new ip2Location data. it appears our old one is a few years old. i need to basically replace the existing w/ this new one.

I was planning...

SQL_Enthusiast (1/31/2013)

---

Thank you for the help. Is this an example of a good post? http://www.sqlservercentral.com/Forums/Topic1414095-392-1.aspx or are you just picking on me?

I don't understand the need for the table creation....

Can't help but post Lowell's handywork.

I think if you put it inside the code tag it should work...

Then you can combine that with Dwain's logic and voila!!!

;WITH Actions (message) AS (

SELECT '20:32:12 [Rachel] Thank you for contacting Our Company....