i looked through your post history, and you seem to be adding this comment to lots of old scripts; this one was nine years old;

contribute...

OK so zero seeks on the primary key, and we know it's also the clustered index since it is index_id = 1

so nothing, really ever says WHERE PK = {somevalue}

would...

can you show the entire error message? maybe show the entire contents of the step that is cursoring through the emails;

it looks like the email sent correctly, but an...

this page on the forums is my go to for linked servers to MySQL.

if you are running 64 bit SQL, you need the 5.1 64 bit MySQL drivers. 32 bit...

here's what i came up with to get the first date of the month, to the "latest" sunday 5pm

there might be a shorter datemath to do the same work, it's...

{edit added this comnetn to wrong post!}

here's what i came up with to get the first date of the month, to the "latest" sunday 5pm

there might be a shorter datemath...

etl2016 (5/10/2016)

---

many thanks.

Every sunday evening 5pm is a cut-off mark and certain aggregations are to be done for that week, with Sunday 5pm as cut-off. As we know,...

it really sounds like it's just plain old parameterized query;

you could be using something like date math to add days or weeks on demand to expand or shrink your...

it depends on whether the data is stored as varchars or proper datetime/time data types.

the datetime datatype allsowds you to add to it.

if the columns are datetime, the CTE is...

ok, so are you rounding up to the nearest power of 10, then?

like this?

SELECT Power(CONVERT(BIGINT, 10), N) AS MaxVal

FROM (SELECT TOP 18 row_number()

...

The group by is fine if you KNOW...

specific error is probably helpful; i suspect it's the column name is misspelled due to copy paste?

or is it because the table busidentity is not in the join criteria on...

there's a pair of functions that you can use to get either the things the views reference, or the things that the view consumes.

--objects that USE the views

SELECT

schema_name(vwz.schema_id) As...

that's a tough one, since the bat could be doing anything, and it's outside of SQL server.

you could open up Task Manager on the server, but the real question is...

i have specific jobs that are identical on all servers, things like backups, statistics, indexing.

i connect via Central Management servers, and run the create job script on all of them...