since you've set up teh DSN and the linked server, do you get a list of tables from this command that you could then query?

exec sp_tables_ex [AccessSchedule]

you get results that...

is the datatype of the source CHAR/NCHAR and not varchar/nvarchar?

exporting char values maintains their defined length.

you'd probably want...

how does whitespace wreck the import?

importing a csv is fairly straight forward;

you could bulk insert directly to a staging table, and trim the data before it inserts into the permanent...

DennisPost (6/6/2016)

---

Hi Lowell,

Thanks for taking the time to read and reply.

That approach won't work for us as the server is set to UTC and we need to be able to...

it sounds like your UTCToLocal functions are scalar which are notoriously slow, where including some datemath columns as the calculated value would definitely be faster since it would be treated...

floats are a pain. As Luis said, the underlying value is still digits, but when being presented in the GUI or exported out again, it's a bit ugly.

when converting a...

mw112009 (6/2/2016)

---

Need help with the following UPDATE statement.

The objective here is to update one field with a | delimited statement using the rest of the fields.

This works out well....

I'm now offering certifications in SQL Fertilization. If you act now i'll offer you 50% off my already low price of $99.

A DOS attack, as in denial of service attack?

That's a very poor way to try and justify disabling that setting. I don't believe the person who developed the list knew...

not sure why you think it's a security violation.

if database mail is enabled, the only users that can use it are sysadmins of sql, or users who have been...

if the only thing the query is doing is a SELECT statement, neither the XACT_ABORT nor...

i've got a similar process, where i need exactly 17 files in a folder that is cleared out daily.

a simple script task to count the files what i use;

string...

based on your design, i'd guess you have to refresh this view every day, since it looks like you build one table per day.

i would bet that those individual tables...

ChrisM@Work (5/31/2016)

---

Google "SQL Fertilization" with the quotes and most of the links appear to relate to a single job advert, something to do with Broadridge. Best guess? A dopey recruiter...

that is a great set of study topics for anyone starting out in SQL.

After you get some experience and practice, you should be able to answer each one;

there's no shortcuts...