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

...

your original six part WHERE finds everything that is "OK", ie does not match the double spaced indexes.

this might work as w to find your exceptions and outliers:

select p_code

from Postcode

where...

i only see some minor suggestions so far, still reading, but it looks fine to me.

my permissions concert is alleviated by the EXECUTE AS statement.

Besides TCP that you are testing...

i think you can just search for double spaces, and not whether they follow the rest/standard formatting for like rules right?

if double spaces are not allowed, you could just replace...

i would lean more towards a logic error in the trigger.

the login trigger clearly rejected the login, but that might be because the login user does not have read permissions...

I've found the best way to resolve this issue is to sync the sids.

SQL users generate a unique Id that is different on each login...so My login[Bob] is not the...

Sql audit can track who made changes in general, and when, but to the best of my knowledge cannot say what row changed, but not whether your statusflag column was...