Hi,

can you be a bit more specific? what do you mean when to insert data?

if you receive (or have) a boo that belongs to a category, then you insert the...

Bledu,

the story goes like this. I i was requested to present the following report.

Imagine that you have a table with users and their door entries / exits. I wanted...

Thank you bledu for your time and help. I believe the internal sql error is caused from performance limitations. I have enough hard drive space, its probably the 1 gig...

OK bledu listen to this

DROP TABLE TBL

CREATE TABLE Tbl (EMPLOYEE   NVARchar(50),   ENTLOG Nvarchar(50));

INSERT Tbl VALUES('A'            , 'Smith');

INSERT Tbl VALUES('A'            , 'Jones');

INSERT Tbl VALUES('B'            , 'Green');

INSERT Tbl VALUES('B'            , 'West');

INSERT Tbl...

i am not able to do that.. i have wasted one day. 🙁 if i give you the records and the table code can you try for me pls??

OK mate i ll try and keep you informed! 🙂

thank you for your time, ill post soon

Thank you for your help the problem is this

I want a SINGLE and ONLY row for each employee that contains ALL its entries in a SINGLE row.

Look at the...

The problem with matrix is that it does not concatenate values. I do not want a seperate column each time an employee enters or exits the building.  Reporting services does...

YES! CAN I DO THIS THROUGH REPORTING SERVICES????

Sugesh, thank you for your answer.

Please be more a bit more specific (i am a business analyst, not a dba! ). Firstly,...

I liked more the one previous the last you send! thank you very much! 🙂

Thank you very much mate, let me check them, and get back with info! 🙂

A sincere thanks both for your answers. Sometimes you (I :crying do stupid things. Indeed, i did not need the select top 1, but...

Sam,

thank you for your suggestion. However, this works in everything else except when the data source is OLAP Cubes.  I think the obly possible solution is through mdx.

Any other...

to help you further the log created YESTERDAY (when the job failed to run) it said, Step name that failed was  DTSStep_DTSExecuteSQL_Task_20.

But we have changed the step names, not...