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...

since you have already set the isolation level to read uncommitted, the only thing a SELECT statement will do (assuming "-- report stmt" is really a select)

is to take out...

ptownbro (5/28/2016)

---

It in fact turned out to be a security issue. I gave access to the site and the top folder, but apparently that doesn't apply to every folder....

here's a more robust example, for more than one row in the original table, and where the end_serial_Number might be null.

the MiniTally table has to contain an integer greater...

seen that error before.

you don't have to investigate any jobs, just fix the login.

the default database for the logins does not exist.

so if I migrated the login mydomain\Lowell with a...

something like this gets the desired code name, but which would you want with multiple matches?

SELECT row_number() over(partition By T2.code_name ORDER BY T2.code) AS RW,T2.code_name As DesiredCodeName,T1.*

FROM dbo.table1 T1

...