i'll bet at least one row is an empty string;

an empty string can be converted to Integer, but not Numeric:

SELECT CONVERT(int,'')--works! value = 0

SELECT CONVERT(NUMERIC(8,0),'') --fails! Error converting data type...

ok since we are showing off all our cursor abilities, here's my contribution to the same issue:

mine is designed to search the db, and provide you with follow up SQL's...

it depends completely on how you are exporting the data; you never mentioned what you are using.

Are you using SSIS? bcp? your own application?

bcp requires a format file to describe...

third party tools exist that are specifically designed for this.

What's UP! and SQLPing are two that come to mind,and both are either free or have free versions.

otherwise, if you are...

no, if you have already installed the ODBC driver on your server, you don't need any SDK or anything else.

all you need to do is use the screenshots int hat...

the errors pretty clear.

you are trying to create a unique primary key on an existing data. but at least one combination of those two columns are not unique. the values...

the IBM website has a walk through on using the SSMS GUI to create a linked server;

does this help?

https://www-304.ibm.com/support/docview.wss?uid=swg21195578

you can create a database that researves a ton of freespace for future growth; when you restore that backup, it requires all that reserved free space as well...so getting a...

yes. i think SQL Server Compact, but you can only use/access that database with a .NET or compact .NET on Windows Mobile;

if you are looking for something to sue...

either of these will do what you asked...they are functionally the same i think.

WHERE COLOR='RED' OR COLOR='GREEN'

WHERE COLOR IN('RED','GREEN')

now if you want where the product has BOTH, you have to...

also, using sys.columns is just an easy way to find a lot of items;

if you doi this:

--SQL 2005= 419

--SQL 2008= 483

select count(*) from model.sys.columns

that shows me that on my...

one of Jeffs other fine examples is creating a CTE Tally table that doesn't touch any existing tables, but creates it all on the fly;

there's not really much of a...

Nakul Vachhrajani (6/30/2011)

---

steveb. (6/30/2011)

---

Nakul Vachhrajani (6/30/2011)

---

A new table may not be feasible in all cases. If you have triggers deployed by interfacing applications, then dropping and recreating the table...

i just noticed that and fixed it; copy my code example again...i edited it to be syntactically correct, but with that code block at the end slightly changed to have...

ok correct me if i'm wrong, but the business logic is basically saying :

if this date is not null [do stuff]

ELSE

if this other date is not null [do stuff]

etc for...