show the real query, and you can generate an estimated execution plan without running the query at all. just highlight the query and click the button for estimated execution plan.

Krishna1 (6/4/2013)

---

Dear All

I am using sql 2008 . While compiling the procedures it does not give error even if table not present.

I need to trap this error. How to achieve...

if you have a specific performance problem, we really would want to see at least the estimated execution plan, and the actual query.

when you abstract it out, you end up...

like this?

SELECT

snetworkname,

REPLACE(sNetworkName,'.noc','')

FROM WhatsUp.dbo.NetworkInterface

RIGHT OUTER JOIN WhatsUp.dbo.device

ON WhatsUp.dbo.NetworkInterface.nNetworkInterfaceID...

Brandi has a nice analysis;

for this one:

SQL Server Integration Services Recipes: (Beginner)

I swept through forums to identify frequently asked questions posted by people getting started with SSIS. In this demo-centric...

Besides NOLOCK being a bad idea in general, as it can lead to bad thinks like missing data, duplicate data and more, the NOLOCKS on a temp table are pointless.

if...

because my Google-Foo is strong, I Gave "mysql send email" a try.

That lead me to a link on the MySQL forums, and a subsequent link to a Visual Studio project...

Sean Lange (6/3/2013)

---

You lost me a bit in here. There is no MERGE statement in what I posted. There is no delete. It is simply an insert statement with an...

that's the point... there is no need to use the exact same screen to add administrators that you saw during the initial installation; that screen is just for convenience, and...

glad i could help; if there were more than just two...

If the Data ALWAYS contains the @ symbol, you could use some of the SubString functions:

;With MySampleData([val])

AS

(

SELECT '1596424@DAR'

)

SELECT *,

LEFT(val,CHARINDEX('@',val) -1) as OneWay,

SUBSTRING(val,1,CHARINDEX('@',val) -1) As AnotherWay,

SUBSTRING(val,CHARINDEX('@',val) +1,30) As RightSideWay

FROM MySampleData

WHERE...

Minnu (6/3/2013)

---

Hi Team,

Can u please tell me that the msg "UPDATE' is not recognized as an internal or external command,"

is coming from the SQL exec call or from the batch...

Also Logon Triggers are per server, and not at the database level, so i can login, and then access multiple databases with multiple commands, and a Logon trigger would not...

well, I've got two suggestions:

first, you should be using the INSERTED table so you only get the rows that were touched in this INSERT.

The second, is just to review the...

Ed Wagner (6/3/2013)

---

WOW! That's an intense nested CTE.

It ran fine until the year 2808, so I figured you must be bumping up against a converted numeric somewhere that was...