So obviously, you have to do it at the report side.

Even after many...

http://www.sqlservercentral.com/articles/SQL+Server+2008/67787/

It's fairly well explained, with examples. Check it out.

- arjun

Huh? Please check what you said. Do you want to do this (finding count of modalityID based on...

usharani.t (5/3/2011)

---

ScheduleDate,ModaltyID are the fields of my dataset

based on the month in scheduleDate, i want to count modalityID is it possible

i want to write expression in rdlc for this.. give...

ricer (5/2/2011)

---

Craig Farrell (5/2/2011)

---

You're correct, it's valid, but pointless. SQL doesn't stop you from doing it, but it has no effect.

Basically you're saying make sure my ID exists when...

Thanks Craig. That's very helpful.

- arjun

Ok, thanks buddy. I do not understand what you mean by the tree structure in this context though.

I guess this was just a theoretical question from my boss. I was...

No, even if it was related to a hierarchy, the FK will be on a different column.

Typically, something like this (just the column names for simplicity)

EmployeeID smallint --PK

--

--

--

SupervisorID smallint --FK...

To make text appear as quoted, enclose the text in '

' beginning tag and end tag.

Alternatively, select the text in the editor and click on quote IFCode shorcut. The selected...

Thanks Todd and Gianluca. I wanted the OP to know his options. Yes, ITVF, when it does the job, is the best option.

- arjun

dilipd006 (3/9/2011)

---

I have two tables

The date in the two fields are different, I want to insert the Date column along with all other entries into the temporary table #temp .I...

Shaikh, check this out. I added parentheses.

create PROC [dbo].[PTH_Overall_SecUpdate_Byfurcation_DPMA_PR1]

(@OUTXML xml output)

as

begin

set @OUTXML=

(

SELECT

M.CR ,

ISNULL([Critical],0) [Critical],

ISNULL([Low],0)[Low] ,

ISNULL([Moderate],0)[Moderate] ,

ISNULL([Important],0)[Important] ,

([Critical]+[Low]+[Moderate]+[Important])as totalpatch

FROM p1 M WITH(NOLOCK)

for xml auto,root('R')

)

end

- arjun

tfifield (3/4/2011)

---

Tony,

Please be advised that while this type of scalar UDF (accessing a table based on parameters) has its place in some applications, it can lead to very bad performance...

Cool 🙂

-arjun

It is more appropriate to use

select

c.query('.')

from

@var.nodes('//DaddyRoot/root') as tab(c)

as this looks precisely for 'root' child nodes of 'DaddyRoot'.

Reading this will help you - http://msdn.microsoft.com/en-us/library/ms188282.aspx

- arjun