Oksana March (9/26/2012)

---

Hi everyone,

I need help understanding something.

The situation is - I have a table that stores comments about shipments, and sometimes the same comment is in a table...

Are you sure that works?

For me it has errors. There's no such thing as "DELETE field FROM Table" as it will delete the entire row. And AFAIK you can't use...

jrichards54 (9/25/2012)

---

Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help...

jrichards54 (9/25/2012)

---

"Can you use ADODB instead of OLEDB?

I don't understand what you mean at all with second issue. Are you saying you can't connect to your database with Visual...

Excellent job posting ddl and sample data!!!!

I did change up your columns a little bit so it is easier to figure out what is going on.

CREATE TABLE #orders (order_id INT,...

yuvipoy (9/24/2012)

---

Hi,

I have an assignment to check the consistency of SQL server database for different conditions.I am having some 200+ columns i a table i need to populate data...

sathiyan00 (9/24/2012)

---

Hi all,

i have to move invalid records(data type mismatch) from excel into error log and have to process only valid records.

But...

komal145 (9/25/2012)

---

Hi...I am getting this message

Msg 245, Level 16, State 1, Line 7

Conversion failed when converting the varchar value 'd1867 ' to data type int.

Below is...

sqlguy-736318 (9/25/2012)

---

What's your opinion on check constraints in SS?

Check constraints seem good for enforcing constraints at the table level. Putting validation at other levels does not prevent a user...

jrichards54 (9/25/2012)

---

Hello to all. I have installed SQL Server 2005 Developer Edition and Visual Studio 2005 Standard Edition on my Windows 7 machine using the 64 bit mode. This has...

ChrisM@Work (9/25/2012)

---

dwain.c (9/24/2012)

---

Sean Lange (9/24/2012)

---

And of course if the exact rows matter this can get a LOT more challenging because there may be more than 1 pair where the sum...

rpouwels (9/25/2012)

---

Hi Sean,

I am trying to import the data in to Access from an SQL Server Database.

I already have the data imported, but Access keeps bugging me with the location...

mick burden (9/25/2012)

---

is the following that I put in a thread earlier not good enough? it created a table with the desired data inputted. What I wanted is an output...

rpouwels (9/25/2012)

---

Hi Everybody,

I am trying to fetch some data from an SQL Server Database.

I have a query, but it keeps prompting for credentials.

SELECT Invoices.NavisionInvoiceNumber, Invoices.NavisionInvoiceDate, Invoices.NavisionCustomerNumber, Invoices.NavisionCustomerName, Invoices.NavisionTotalDeliveries, Invoices.FilesDistributed, Invoices.IsComplete,...

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