In general, I think the preference is to avoid triggers when possible.

after that, it's not a preference, but rather which method, a standard insert trigger vs an instead of trigger...

ok not as hard as i thought: here you go:

SELECT StateName,stuff(( SELECT ',' + CONVERT(varchar,RW) + '.' + CityName

...

getting the cities as a list wasn't hard, but i'm having trouble numbering them inline; my row_number verisons not quite there yet, but here's the start of it:

SELECT StateName,stuff(( ...

i guess the question is how are you testing the public permissions then?

did you create a new database user , unconnected form any login like this?

are you using execute as?...

MyDoggieJessie (2/19/2013)

---

I don't believe this is possible unless you already have Change Data Capture running

There is nice app from ApexSQL which can be used as a trial and literally and...

I'm awful sure there is a solution to that; I know i've seen lots of SSRS topics like "don't send if no data is found", kind of threads.

this was just...

not a reporting services guru, but for regular scheduled jobs, i can create a job which does something, like send an email or update or whatever, that runs every...

homebrew i think this is equivilent to your first update query, but should theoretically perform better.

compare the SELECT to teh UPDATE , and tell me if it looks like it...

nikus thank you for the feedback! i really appreciate it!

awesome solution Cadavre!

only thing i would do is clean up the presentation with REPLICATE to get the zeros, and maybe just a simple not like '%[^0-9]%' ; what do you...

ohpenot (2/19/2013)

---

Hi Lowel,

Have the same problem "access denied" when trying to exec "xp_cmd". Except that i am on windows seven. The company isntalled sql express on my machine to start...

True but its only half of the puzzle,...

.net 2.0 is Required for both installation...

Stefan Krzywicki (2/15/2013)

---

Why do we still use ' as a text indicator in databases? Why haven't we (meaning people who design systems) created a unique symbol that we can...

prathibha_aviator (2/15/2013)

---

Lowell,

Thankyou for ur response.. It worked so well.. I just couldnt believe that my problem resolves in no tym... 🙂 Would you also help me Now if i want...