Something strange.

Your fast option is slower in another clause.

AND(I.LogDate <= @DateTo OR @DateTo = 'Jan 01 1900') -- Faster

AND(CASE WHEN I.LogDate <= @DateTo OR @DateTo = 'Jan 01 1900' THEN...

Thanks Brian,

The article answered some of my questions.

Thought: Could you not delve into SQL and add a trigger to sysObjects, SysColumns(?) so that when a table was created it...

hmmm, What is the difference?

Speed?

Your solution gives about a 30ms decrease in time taken.

AND(I.ErrorID >= @ErrNumStart OR @ErrNumStart = 0) -- Slow option

AND(CASE WHEN I.ErrorID >= @ErrNumStart OR @ErrNumStart...

Thanks.

I have pritty musch got there.

You can use GRANT (SP3 Only) to grant the access to tables etc.

Only "funny" thing is though when you add as user they have access...

I sort of answered my own question. Permissions per role.

Looking at EM, you specify permissions per table, proc etc.

Any way of applying read / write to all objects?

Cheers,

Crispin

Why don't you...

Thanks but what I can't figure out is how do I add a user to the role with Read / Write access or are the permissions per role?

This is driving...

Maybe I'm missing the point but...

Select COUNT(ColName) From Table

Where

Event = 'x'

If you want the number of each event then

Select COUNT(ColName), EventName From Table

Where

Event = 'x'

Group By EventName

Cheers,

Crispin

To alter the field to Varchar use:

Alter Table TableName Alter Column ColumnName Varchar(200)

Cheers,

Crispin

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

The reason this is happening is because you have nulls in the URL field.

What you need to do is add a where caluse into your select and filter out the...

quote:

---

NVarchars were used to let all languages and symbols to be used..

---

Question: Would email addresses...

Greetings.

You would use the same code with the exception of:

Insert Into #tmpLinks(LinkID, URL) 

Select LinkID, URL From Links

You would use:

Insert Into #tmpLinks(LinkID,...

Here you go.

The contents of you <link> table are dumped into a temp table so we can loop through it.

If a response code is not in the IF, that link...

Here's the same code with a bit of error trapping in it. I'll post the example you want in a sec. Will become to much...

DECLARE 

--...

hmmm. Will have a look at it and compare. Thanks!

Cheers,

Crispin

Why don't you try practicing random acts of intelligence and senseless acts of self-control?

Something else...

You can use sp_OAGetErrorInfo after each method or property change to catch any errors.