Or this?

; WITH CTE AS

(

SELECT a.id,a.title,uao.userid ,

CountOfRows = COUNT(*) OVER(PARTITION BY uao.userid)

FROM user_artist_owned uao

INNER JOIN artists a

on...

When I need to create a ‘View’ from the columns of different tables in a Database,

Is it necessary that the tables involving in that view should be related...

Why do u want to do that? a function can be executed for each row, so why not use that directly ? Actually, can u elaborate on what u are...

Whooo.. i really don't understand the requirement.. if u would be precise in what u want, i think i can help you out..

Can u give us what ur original UPDATE...

How about this?

SET NOCOUNT ON

GO

DECLARE @RefNo VARCHAR(10)

SELECT @RefNo = 'GB_HQ1768'

;WITH CTE AS

(

SELECT RefNo,Version , ColName, Vals

...

Or rather, this ?

WITH CTE_HIER AS

(

SELECT [Id],[Name] , [ParentId], CAST('' AS VARCHAR(50)) AS ParentName

FROM [ReportCodeDim]

WHERE [ParentId] IS NULL

UNION ALL

SELECT SRC.[Id],SRC.[Name] , SRC.[ParentId], REC.[Name] As ParentName

FROM [ReportCodeDim]...

Something like this?

WITH CTE_HIER AS

(

SELECT [Id],[Name] , [ParentId], CAST('' AS VARCHAR(50)) AS ParentName

FROM [ReportCodeDim]

WHERE [ParentId] IS NULL

UNION ALL

SELECT SRC.[Id],SRC.[Name] , SRC.[ParentId], REC.[Name] As ParentName

FROM [ReportCodeDim] SRC

JOIN...

barsuk (2/9/2011)

---

Maybe that could help. That worked with non-IT personel before.

It is like apartment (Database) in the apartment building (Server).

Each Apartment Building (Server) has multiple apartments (Databases).

So in order to...

Sharath, if u will have more than RefNo, just remove the WHERE clause in my query ; it will bring out the changed columns for all the RefNos..

GSquared (2/9/2011)

---

The original request didn't include the version number in the results. I try to match...

Gus, i think, you have missed adding Version column to your inner select.

How about this?

SET NOCOUNT ON

DECLARE @RefNo VARCHAR(10)

SELECT @RefNo = 'GB_HQ1768'

;WITH CTE AS

(

SELECT RefNo , ColName, Vals

FROM

(

SELECT CAST(RefNo AS VARCHAR(200)) AS RefNo,

...

Will you be supplying only one reference number at a time ? and will there be only 2 rows per reference number?

Am totally confused on the requirement.. can you please elaborate on the requirement pls..

Lynn Pettis (2/8/2011)

---

ColdCoffee (2/8/2011)

---

mtassin (2/8/2011)

---

Heck I didn't understand what he was doing with...