The index you created above would be used if you had a statement like this:

SELECT contactId

FROM campaignContacts

WHERE campaignId ...

EamonSQL (8/1/2013)

---

Thanks for this.

The reason I know is that this is an old app which the vendor isn't supporting anymore.

Sometimes a data issue occurs and we've been told that a...

dzoll (8/1/2013)

---

Here is the message I get when I manually run the SP:

Msg 14624, Level 16, State 1, Procedure sp_send_dbmail, Line 260

At least one of the following parameters must be...

prakashr.r7 (8/1/2013)

---

Hi Lowell,

The Texas A& M is superb. This site has an option of Batch processing. It just made me curious, how many addresses...

Ed Wagner (7/31/2013)

---

Lowell - Thank you! Having address validation is a very good tool to have. I can't tell you how many times we do it and the...

Jared i tried it on my 2012/2008 and 2005 instances,a nd all three returned an error referencing the column sJob.Originating_Server

Msg 207, Level 16, State 1, Line 3

Invalid column name 'Originating_Server'.

do...

Sanity Checks are always a good thing! glad i could help!

you are correct; you are testing for five specific values in your CASE, and there's no explicit ELSE in it to handle other values, and the built in logic...

a basic example:

Create LOGIN [ClarkKent] WITH PASSWORD='NotTheRealPassword'

USE [WHATEVER]

Create USER [ClarkKent] FOR LOGIN [ClarkKent]

CREATE ROLE [ReadOnlyRole]

EXEC sp_addrolemember N'db_datareader', N'ReadOnlyRole'

--can the users EXECUTE procedures? comment out if false

GRANT EXECUTE TO...

prakashr.r7 (7/31/2013)

---

Lowell (7/31/2013)

---

i've used the free portion of this web service, which does a best-lookup of an address and converts it into the official standardized address pieces...if it's an invalid...

prakashr.r7 (7/31/2013)

---

Hi Lowell,

I can not use this web page as you say it would do only about 1000 addresses . i have more than 30000...

not sure if that's an issue or not. on my test server, i did exactly this code, and see the command text for both;

regardless of whether the command text is...

i've used the free portion of this web service, which does a best-lookup of an address and converts it into the official standardized address pieces...if it's an invalid address, it...

clas (7/30/2013)

---

I want to run a section of sql queries with a specific type. Some types can use the same sql queries and the idea was to have the type...

well, i think you've abstracted the problem out to where we can't tell what you want.

why can't you do everything, in a single step, with SELECT ID, Type, Value +...