Roy Ernest (3/11/2011)

---

Hey Threadizens, I have a question that will be very simple for all of you but pretty hard for me since I am very weak with T-SQL. Please...

SELECT LEFT(ipaddress, CHARINDEX('.', ipaddress, CHARINDEX('.', ipaddress)+1)-1), COUNT(*)

FROM #tempIPTable

GROUP BY LEFT(ipaddress, CHARINDEX('.', ipaddress, CHARINDEX('.', ipaddress)+1)-1);

First, you need a Begin and End for the If, otherwise it just controls the next command.

Second, use Raiserror instead of Print.

Third, why not do this in the insert proc,...

I'd do what I could to find table and data differences between the two datasets, summarize them, and present that.

Are there column differences? (Like, you have first and last...

Lionel E. Nzenze (3/11/2011)

---

Bad Idea..

So not send mail from a trigger.

Get the Trigger to write Whatever you want into some table.

Create a SQL Server Job to poll the said table...

And here I thought the usual insult on it was "Database A**hole".

Brandie Tarvin (3/11/2011)

---

hor_netuk (3/11/2011)

---

My experience. - At interview, the technical interviewer expressed dislike of acronym use. The non-technical interviewer replied, "funnily enough, I didn't know what DBA stood for...

I haven't run into that issue, but it seems you could test it pretty easily by logging the values.

Tom.Thomson (3/10/2011)

---

Chad Crawford (3/10/2011)

---

jcrawf02 (3/10/2011)

---

We actually have annual contests to see who can guess the most acronyms, and we pass out a list to new hires so they're not...

CELKO (3/10/2011)

---

Jeff, GSquare, et al

I am doing the second edition of TREES & HIERARCHIES this year. If you have stuff that ought to be in the book, plese send it...

sean-495500 (3/10/2011)

---

Using HierarchyID Datatype with this solution

If added a new column into the table called OrganisationLevel with a HierarchyID datatype, then updated this column with the Hierarchy data that you...

Brandie Tarvin (3/10/2011)

---

It's the Attack of the Acronyms!

Two years ago, we implemented a new process that uses the acronym "RI". I've been working on that process ever since. I've gotten...

It looks like your database files are missing. You may need to restart the SQL service to get SQL Server to realize that the database isn't there.

I would certainly hope the DBA verifies the values and connection before deploying!

The easiest way to do this kind of thing is build a "DateTimes" table and join to that.

create table dbo.DateTimes (

DTVal datetime primary key,

constraint CK_DTVal_Hourly check (datepart(minute, DTVal) = 0...