I think this will work:

[font="Courier New"]DECLARE @x TABLE (id CHAR(3), name CHAR(2), value CHAR(2))

DECLARE @y TABLE (name CHAR(2), value CHAR(2))

INSERT INTO @x

   SELECT

       'AXN', 'E1', 'N1'

   UNION ALL

   SELECT

       'AXN',...

Where are you creating and assigning the value ('M' or 'P') to a variable?

Could you post some sample data so I can really understand what you are asking?

Based on what I understand your question to be I think you could something like this:

IF...

Adi has provided the only solution I am aware of.

What do you mean by completely dynamic? Do you mean you want to be able specify the value each time? For example I may run the job today with...

I have noticed that people have mentioned googling a problem or asking someone else at the office for help on an issue as cheating. I don't consider either cheating....

1. Create a report

2. Drag the Image item from the Toolbox onto the report

3. Choose Embedded as the Image Source

4. Click Next

5. Click New Image

6....

You can't have this line in your second EXEC in the WHILE:

- isnull((select sum(OriPPh) from PPh where InvoicePajak = '''+@InvoicePajak+''' and Period between '''+@StartPrd+''' and '''+@EndPrd+'''),0)

That is is aggregate in...

What control are you using to display the data? If you are using a table you can use set the grouping to the Server and in that level take...

If you know the queries that are timing out you should run them in SSMS and check the execution plans to see where you can tune them. You can...

Just a guess since I don't know what your error is, but if your columns can be NULL and you are handling that for display purposes you also need to...

When you do a Data Conversion transform you get a new column and then you need to map the new column to the destination. I'm guessing you are still...

Interesting editorial and I'd guess it had some basis in this forum thread about embellishing resumes: http://www.sqlservercentral.com/Forums/FindPost557642.aspx.

In my opinion is comes down to the prevalence of situational ethics, it's right...

In this case you have 2 options:

1. Storing student_id in the student addresses table will allow for multiple addresses per student.

2. Have a Students table, and Addresses table...

Jeffrey Williams (8/23/2008)

---

Jeff Moden (8/23/2008)

---

So far as any type of formatting goes, yeah... I thought I stressed that final formatting should probably be done at the GUI level... maybe I...