pdanes (2/25/2014)

---

So if the query gives me what I need, I should ignore whatever the design view says? I'm kind of leery about ignoring warning messages - I always wonder...

Right-click on the view and select 'Script view as...', see if it's what you are execting.

Why would you want to convert this into a view?

Why does it have an ORDER...

This should help you on your way. Post back if you are unsure of how to convert it into an update.

SELECT

po.[user_id], po.gen_userlevel, po.gen_supervisor, po.gen_approvelimit, po.gen_email, po.company_id,

'#' '#', --...

mike 57299 (2/24/2014)

---

Other than...

Identify the simplest component of your problem and tackle it. Try running this:

CREATE TABLE #DBROLES

(

DBName SYSNAME NOT NULL ,

UserName SYSNAME NOT NULL ,

db_owner...

WITH cte AS (

SELECT userid, parentid

FROM user_detail

WHERE userid = '100002'

UNION ALL

SELECT t.userid, t.parentid

FROM user_detail t

INNER JOIN cte on cte.userid = t.parentid

)

SELECT

d.userid,

[DUE] =...

Posters are always encouraged to participate. Have you tried moving the variable declaration?

FETCH NEXT FROM DBName_Cursor INTO @dbname

.

.

.

.

declare @dbname varchar(200)

You're welcome - and it's great to hear that you are benefiting so much from visiting ssc 🙂

pharmkittie (2/24/2014)

---

Thanks for your answer Chris. I very much appreciate the time you took to read my examples and write up a solution.

No worries. No solution yet...

-- Please use table aliases so folks can tell which columns are from which tables.

-- why do you have brackets around some of the columns? e.g. ([1_1]),([1_2]),...

-- Are all those...

Could you be a little more specific e.g. how many rows? What's the client?

wendy elizabeth (2/23/2014)

---

I have a question about understanding nested case statements in sql server 2008:

The sql looks like the folloiwng:

select numberofcases

from inventory

where inventory_cnt >...

GilaMonster (2/21/2014)

---

ChrisM@Work (2/21/2014)

---

GilaMonster (2/20/2014)

---

PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked...

Try EXEC (@QUERY)