Did you try use OPENQUERY to force the ORDER BY being performed at the MySQL side before transferring the data?

What happens if you run that query directly at the MySQL...

Something like this?

SELECT

MAX(CASE WHEN name ='Name' THEN data ELSE NULL END) AS Name,

MAX(CASE WHEN name ='Email' THEN data ELSE NULL END) AS Email,

MAX(CASE WHEN ...

The description in the original link is somewhat misleading:

the part related to "create function..." and the following part "While EXISTS..." are both part of the same function.

The function should look...

@lowell: I tend to disagree that design you posted will actually work as expected (beyond the typo FETCH NEXT FROM MynewCursor without moving INTO @item, @oper_num to the...

lokesh.shukla-634965 (1/3/2015)

---

Thanks Sujeet, for your nice comments and the link provided.

But, my 2nd question is still not better understood (How clustered index and non-clustered index are related?).

Can you elaborate it...

Steve Jones - SSC Editor (1/2/2015)

---

Be aware that anyone can spoof the application name in their connection string. In practice, it probably doesn't happen, but just be aware you have...

A slight correction regarding the clustered index:

The sort oder is not physical (in terms of sequential location on a spindle), but logical.

See for a great...

Step 1: create a calendar table that also include a column to flag a business day (e.g. tinyint with constraint 0,1). There are numerous blogs on how to build a...

Here are a few links that might help you to get started with understanding the different data types:

and

[url= http://www.databasejournal.com/features/mssql/article.php/1490561/Data-Structure-Differences-between-Access-and-SQL-Server.htm%5DData...

I've done more than one project where an app originally started with ACCESS only being converted to SQL Server back end and ACCESS as a frontend.

It's doable but there are...

I'd vote against a denormalized table. Stick with your current design at the table level.

If needed for an application layer you could use a pivoted view to display it in...

Yeha!!! It's spam time again! :angry: :crying:

The major question is: How important is this database for your company?

Will it change anything if, after a year or so, the system crashes and becomes unavailable and/or if all...

For the part of your question:

To send 3GB across a network and process it a the client side takes a while.

I can't think of any scenario why the display of...

Stupid error.... :crazy:

Replace

DATEADD(yy,x.N,DATEADD(dd,Number,@FY+'0401')) as FDay,

with

DATEADD(dd,Number,DATEADD(yy,x.N,@FY+'0401')) as FDay,

The first line add the year after the number of days are added. This leads to ignoring leap years if the start year...