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

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