I have not heard that one. Can you share a...

All you showed was the SELECT column list. Could you please provide the full query based on the test table I provided in an earlier post? I would like to...

...or TOP (n) PERCENT

Ed Wagner (1/14/2013)

---

In SQL Server, you could use the following:

SELECT 'Your performance is ' + CONVERT(Varchar, grade);

I would consult the MySQL documentation under "string concatenation" for details on how it's...

Steven Willis (1/14/2013)

---

...if for some reason additional keys are deemed necessary for a temp table care must be taken to make sure the keys have unique names. For example:

DECLARE

...

paul.j.kemna (1/14/2013)

---

A user on another forum suggested that I dump the error output into a text file.

I did this and I believe it has shed some light on the...

I do not work with DB2 much and am not sure how great the driver is or how well the engine reports its own metadata when SSIS asks. Does DB2...

The SSIS package definitions are stored in msdb.dbo.sysssispackages. Because the definition is XML you can cast it to the XML data type and then operate on it using XQuery. A...

Output. External is just what SSIS thinks the source is.

If you download this SQLCLR component...

http://groupconcat.codeplex.com/%5B/url%5D

...then you can write code like this in SQL Server very similar to what you would expect to be able to write in MySQL. Adding...

Jeff Moden (1/13/2013)

---

bobd125 (1/10/2013)

---

I have a Execute T-SQL task which purged records from table. I would like to record in a log file the record count of how many...

I like to check to see how many CPUs are online as well:

-- cpu overview

SELECT osi.cpu_count AS LogicalCpuCount,

osi.hyperthread_ratio AS HyperthreadCoreRatio,

...

I meant in the Linked Server node in SSMS Object Explorer, under Providers, right click MSDASQL and go to Properties. What do you have setup for options?

That's solid. I meant to come back to this because using RANK seemed clunky and I knew there had to...

You're quite welcome. I am happy it helped.