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 +...

wow just some wild guesses here, no idea if it is right:

i'm assuming ticks means what i found on my search internet search:

declare @ticks bigint = 624511296000000000;

--One Tick is 10...

i can find it on Amazon.com, and through them, lots of various retailers, but i think that implies a US purchase.

additionally, i'm not sure how many processors that includes for...

the trigger always fires every time, it's just it...

easiest way is to use bcp.exe to a CSV file, which by default opens in Excel on most peoples machines.

if you want a single document, with three worksheets, you'll...

basically, we are updating the current table from INSERTED, so...