Okay, so you have no idea if there is ever a value passed down to the procedure, do you.

My guess, untested, is that the value being passed in is null...

Or this:

eclare @SQLCmd varchar(max);

select

@SQLCmd = (select 'UPDATE STATISTICS ' + object_name(object_id) + ' with fullscan;' + char(13) + char(10)

...

a deslandes (9/14/2012)

---

Under ideal conditions I pass a parameter @PackageName.

If I use @subject = @PackageName, no mail is received

If I use SET @P = @PackageName

and then use @subject =...

How is @P getting its value when you aren't getting the email?

martinetymic (9/14/2012)

---

and sorry for the format : it's my first time asking questions in a forum!:-)

some details:

d_an = first year with a specific medical condition

before this date : d_YEAR=0

after this...

We still have a problem here. You haven't given us enough to actually answer your question. We just can't see from here what you see there. Step...

Those are the...

martinetymic (9/14/2012)

---

Hi,

I have a problem in sql server 2005 to submit :

My table 1 is as follows : 1 column with refid and one with a year (d_an)

Table 1

REFIDd_an

11998

22001

31999

42012

I would...

Nothing like having two people obviously in over their heads this week.

No, it isn't just you.

Look?

Two, one from SSC and one from TDWI. Now, soccer/ref related, I have quite a few.

Any triggers on the destination table?

GSquared (9/14/2012)

---

Gazareth (9/14/2012)

---

They are equivalent, but I don't think you can mix the two types of join in the same query.

It's the where clause that's causing the difference in the...

Have you tried joining the INVOICE_LINE into your second query and add the sum(..) tot he select?