blandry (8/1/2008)

---

A few months after the reunion I heard from three class members asking that I pull their pages. Two were in the financial industry and one in healthcare...

The code you posted is incomplete. You are missing at least 1 END and you are not explaining what you want the code to do. If you look...

Sure you can create an on delete trigger that will log the delete. You may not be able to get the actual user name though, it all depends on...

What do you mean the IF ELSE is not getting executed and how do you know?

Are you sure the variables are being initialized?

You can compare 2 variables like this:

[font="Courier...

I am going to make some suggestions and then give you a semi-solution.

1. Don't mix LEFT and RIGHT Joins, nothing good can come of it.

2. Only use OUTER...

Use Information_Schema.Routines Routine_Defintion column.

[font="Courier New"]SELECT

   routine_name,

   routine_type,

   routine_definition

FROM

   information_schema.routines

WHERE

   routine_definition LIKE '%cursor%'[/font]

Here are a couple of articles on how to do it:

http://database.ittoolbox.com/documents/popular-q-and-a/setting-up-sql-mail-with-lotus-notes-email-system-2445

http://windowsitpro.com/article/articleid/14338/how-can-i-use-lotus-notes-for-sql-mail.html

Another option is to download xp_smtp_sendmail and setup jobs that monitor the server and email alerts using it.

Don't be afraid to speak your mind, Grant.:D

The one shortcoming, and it's fairly large, production represents a series of threads from various applications and/or application servers....

When I went to look into using information_schema I think I came up with a solution for you. Try this out:

[font="Courier New"]DECLARE @idoc INT

DECLARE @doc VARCHAR(1000)

SET @doc ='

<places>

<copy>

<statename34>new mexico</statename34>

<statedesc34>land...

Since the ID's are part of the tag I think you would have to do something in .NET or with XSL to parse the tags and create and add the...

Lookup OPENXML in Books On Line. This converts the XML to a table-like format and then you can do your insert.

I'd go with the dataflow task as well, but if you are only using 1 spreadsheet you don't need to use the For Each loop. You just need a...

I think the money data type unless you are working with the federal debt.

The main issue is using currency types in an application as I believe they will use the...

The answer is "it depends". In reality a cities table with postal codes would be a great thing and if your product only deals with industrialized nations like the...

Check out the links in my signature and if you follow the advice in those articles you should get some good help and going through the process may actually help...