kreuzer (5/12/2016)

---

Hi,

for me as a human user, it would be OK to type a captcha to post something.

Or, only confirmed accounts can post something. I think, it should be possible...

rathimittha.mb (5/12/2016)

---

Hi,

Thanks again for the quick response.

I tried with 4 part query. And it keeps throwing an error.

It says 'Invalid use of schema or catalog for OLE DB provider...

there's a few things that can be improved here;

your code is assuming one row from inserted exists, it should be modified to handle multiple rows.

calling xp_cmdshell requires sysadmin privileges,...

if you include the fn now function, there are seven ways i know of to get the current datetime; there's a few threads around that points out that a potential...

Thanks for the script.

couldn't resist.

there is a built in stored procedure from Ms to get the objects in FK hierarchy order.

If you have a circular reference, you can get stuck in a loop(A references...

Once you have the Linked Server in place I have found a few different ways of interacting with the mysql database:

Select Statements:

select * from mysql5...country

select * from OPENQUERY(mysql5, 'select *...

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