Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

very recently i had to restore all historical data, i'm trying to load them in, most went in just fine, but two months all fail on the last column. error converting the datatype to numeric
i don't know what/why, but i assumed maybe a problem w/the end-of-row terminator or something (not sure...)

the only way i could load them was by changing that last column from decimal((18,2)
to varchar(10)

now i'm trying to get those two months into the table properly so this historical audit can occur

well, chap, that works on the #t table, those values, minus the underscored number..... but when i run the same thing on my table, i get nothing back

is there a means of updating or something?

oh hell.

the dude looking for this just told me they won't need this field for the reports they're needing to run, so if i can load without, they won't mind.

good.

but i still would like to know how to resolve this, should it recurr in the future

also, do either of you have any idea if my bcp may have caused this? it makes no sense, i pulled 100M records out of this table, daily files since 5/16/06, and only 1.5 months is doing this to me
i don't get it

another table, same darned scenario -- three fields, the last one is decimal(18,2)
these files are generated precisel the same as what i posted up there.
the data load keeps failing to convert datatype varchar to numeric on that last attribute --- BUT only on SOME of the files.
I load it into a temp table where field3 is varchar(10), and for the life of me, i cannot cast the darned thing to decimal

WEll, this is kind of a hack way to do it, but you could use a cursor to loop through the values in that column and try to cast them one at a time....when you run into the error, you can inspect the data it errored on to see what the problem might be.

excellent, aneesh. thank you. i haven't tried it yet, but i will. i added the new column already, actually, thinking of a similar approach, but it just wasn't happening syntactically. i will give this a go and let you know.

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …

Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…