It's a nice tip for a one-shot query, though it won't help you automating the data flow to a destination table.

I think it's not a good idea, for at least two reasons:

1) Storing more than one attribute in a column violates...

It will, but you're issuing unneeded SQL.

Should i check for records in each table before i update? Or should I stick...

You could use OPENROWSET and provide the connection string for each server.

You would have to enable ad hoc queries though.

Oracle doesn't allow inline subqueries that way.

Try this instead:

SELECT trunc(sysdate) AS refresh,

empd.GSP_GROUP_ID AS gpid,

...

CirquedeSQLeil (11/4/2010)

---

Ray K (11/4/2010)

---

I think you spoke too soon.

http://www.sqlservercentral.com/Forums/FindPost1016045.aspx

Mr. Celko, please go away. The question was obviously answered, DDL or not....

Oh, come on Joe!

This is the newbies forum.

People that post here didn't read your books (and probably never will, if you treat them this way...)

So it seems.

Nothing to complain about today?

Thank you!

It's strange, indeed. STATIC cursors have to make a tempdb copy of the data, I would expect this to take some time and lose compared to KEYSET. Go figure.

Do you have any reference to point me to?

Recently a MS consultant...

Dave D. (11/4/2010)

---

The question that comes to mind with that is why I could connect to the database if didn't put the named instance in the connection string? Does...

Fox87 (11/4/2010)

---

Do you have any other suggestions to move the header so that everything is in line? I just want to move the "Rundate" to be in the center of...

Try this:

USE msdb;

GO

-- Create a view to transform sqlAgent crappy dates into datetime columns

CREATE VIEW dba_JobHistory

AS

WITH JobHistory AS (

SELECT SUBSTRING(J.name, 1, 35) Job_Name, -- Shortened to fit the email

CAST(STUFF(STUFF(CAST(JH.run_date...

Do you have a firewall between your pc and the cluster? If so, it's an old and well known issue.

SQL Browser is not cluster-aware. This means that it can receive...

You will have to take plan caching and parameter sniffing into account.

See this great guide by MVP Erland Sommarskog:

http://www.sommarskog.se/dyn-search.html

EDIT: I'm unable to spell "URL"...