kishore.sqlbi (4/26/2012)

---

yes, i am using enterprise only, can give me query to get particular person data, main problem with sending email to particular person, can you provide detail query to...

Please do not cross-post as this fragments the feedback.

http://www.sqlservercentral.com/Forums/Topic1290412-1633-1.aspx

Fitz

kishore.sqlbi (4/25/2012)

---

I have table like this.

Name email product...

4th or 5th OP post that has been "solved". The rest were coding errors so probably the join as was pointed out in the suggestions.:-)

Table1...

Which product or technique are you using for the trace? What do you want out of it?...

shashidar (4/25/2012)

---

Hi ,

I am facing problem when i try to pass parameter [DATE].[Year Month] to a subreport it passes an Id [Date].[Year Month].&[33] instead of [Date].[Year Month].&[201201].

Can somebody help...

Seems to be a known reported error with SQL...

vinu512 (4/25/2012)

---

I thought the OP wants the previous date for the "Latest" test date. The latest test date not only in this case but in all cases will be the...

riya_dave (4/24/2012)

---

my select statement

insert into #temp7

select a.shortname , a.portfoliobaseid , a.account ,a.InceptionDate,

a.DTDTWR,

MTDTWR = case when (a.MTDTWR is null) then

(exp(sum(LOG(CASE WHEN b.monthirr = 0.0 THEN 1 WHEN b.monthirr IS NULL...

This would return the second last test date. The OP wanted...

rajn.knit07 (4/25/2012)

---

Hi, Let say we have given some dates in our table.

the structure is as below

CREATE TABLE [dbo].[datetest](

[test_date] [datetime] NULL

)

insert into datetest

select '2012-04-25'

union

select '2011-12-31'

union

select '2011-12-27'

union

select '2011-12-23'

union

select '2011-12-23'

union

select '2011-12-20'

Now here...

riya_dave (4/24/2012)

---

if(@qtd is null)

begin

---------------------------------------------------------

------quatertodate---------------

declare @qtd1 float

declare @maxdate1...

keymoo (4/24/2012)

---

Thanks that does provide the correct result but my hunch is that it can be solved in one statement using RANK and OVER statements. There you...

polkadot (4/22/2012)

---

Thanks. I was missing a right parenthesis and alias for the inner. 😛 I was modeling it this way because in real life the WorkItems table has many more...

maryamzolfaghar (4/22/2012)

---

I need to have the messages shown in "Messages" tab when running a query in a file

Can anyone help?

The quesry is sth like this:

SET STATISTICS TIME ON

select *

from [a...