Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the...

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was...

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was offsides?"

Well, I've just seen...

Please stop cross posting your questions. It only fragments replies.

Direct future responses here. http://www.sqlservercentral.com/Forums/Topic1427835-391-1.aspx

tony28 (3/7/2013)

---

:w00t: you know, i am learning myself and nobody, even my boss, doesnt know about lot of things sql.

So I cannot discuss about my work with someone better than...

alan_lynch (3/6/2013)

---

I am trying to insert records into the database as follows

insert into lookuptable

select * from lookuptable1

which produces

Msg 2627, Level 14, State 1, Line 1

Violation of UNIQUE KEY constraint 'uqLookuptable1cols1'....

Not sure if this post was intended as help...

T_Peters (2/22/2013)

---

In some circles this could be as touchy a topic as asking which religion to follow.

I'm a full time DBA with an interested in learning some web development....

Check out Paul White's articles.

http://www.sqlservercentral.com/articles/APPLY/69953/%5B/url%5D

http://www.sqlservercentral.com/articles/APPLY/69954/%5B/url%5D

And then I would recommend changing the datatype to an int or whatever number type makes the most sense.

Maybe an even better approach would be to remove the cursor and do your inserts set based? Cursors are notoriously slow and over used. They have their place but very...

You have something in there that can't be cast as a datetime and it is failing. Your where clause also casts Col1 as a datetime so if there is something...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1427363-391-1.aspx

Did that get you the desired results?

Well DataGridViews are limited to a single datasource, this does not mean that the datasource can't have data from more than 1 sql table. I know you aren't looking for...