Search results for query: *

Your excel file has to include two columns, Unique_ID and Report_To. The Report_To column 'points back' to Unique_ID meaning that this column contains the ids from Unique_ID column. Those two column basically tells VISIO which box go under which box. Without the two columns, one box per page is...

When you are asked such question next time, just calmly answer that you have 3+ years of experience. Since SQL Server 2005 is SQL Server 2000 with a few improvements, you are telling the truth. A Ford with newly installed options is still a Ford. Right? And don't make the interviewers look bad...

Thank you for the reply. This chart is distributed on paper. I was trying to show race/ethnicity distribution in each of the departments. So a box(department) has 5 numbers in a single column under a department name, for example, 30, 5, 2, 1, 0. This is a great feature, except that I can't...

I was able to show data from Excel file in a organizational chart. But how do I show the data with the field name associated with it?. Showing a few numbers on a box without knowing what they are seems not useful. Alternative is to type in the field names in each of the 100+ departments, which I...

Attach this line at the end of your statement. having count(*) = 1 or without the subquery select count(clientid_c) as counter_n, clientid_c, from cd.enrollments where enddate_d is null and program_c = '900' and (ru_c = '' or ru_c is null) group by client_c having...

Try this. select id, 'Monday' from tb1 where m = 1 union select id, 'Tuesday' from tb1 where t = 1 union select id, 'Wednesday' from tb1 where w = 1 union select id, 'Thursday' from tb1 where th = 1 union select id, 'Friday' from tb1 where f = 1 union select id, 'Saturday' from tb1 where s = 1

JayKusch, Thank you very much. Your code did the job. Thanks. smin.

How do I revert the summary table grouped by a column to an ungrouped original table? For example; I have a table, TABLE1, with two columns: ID, Counts (both integers) 1 2 2 4 3 1 4 2 ..... The result table, TABLE2, should be just one column with each id repeated number of times...

dswitzer, Try this UDF. create function counting ( @id char(1), @startDate datetime, @parm3 char(1) ) returns int as begin declare @pending int declare @completed int declare @outvalue int -- count pending ids select @pending = count(id) from theTable where startDate < @startDate...

This can be done with a UDF with a table data type. Try this code and see if this works. create function getValue( @inputparm1 char(9), @inputparm2 int ) returns char(4) as begin declare @outvalue char(4) declare @table1 table( idn int IDENTITY(1,1), col1...

Should'nt the case statement be: case isdate([date of birth]) when 1 then convert (datetime,[date of birth]) else null end or case when isdate([date of birth]) = 1 then convert(datetime,[date of birth]) else null end The date '07/26/1978' should not give you any...

Would this work? select a.VolumeID, a.FileID, max(b.BaseFileID) from table1 a left join table2 b on a.VolumeID = b.VolumeID and a.FileID >= b.BaseFileID group by a.VolumeID, a.FileID Using the data you posted, The result of the above code was; VolumeID FileID BaseFileID 1 1234 1230 1...

I see. You have many different researches. Can I ask you a few questions then? 1. how many different researches are you dealing with? 2. Why would you have different research data on a same cube? Are they all related researches? 3. what is the range of the number of questions in different...

Here is one suggestion. Aarrange your fact table as follows. UserID, Q1, Q2, ... QN So the number of column is equal to the number of questions plus 1 for userID. Once you arrange your fact table this way, then the rest is easy. Each question becomes your dimension, so there is going to be N...

In the cube editor, - insert the two table. - link the two table, 'UserID' to 'UserID' - drag and drop 'UserID' from fact table to measure folder - drag and drop 'Question' and 'Answer' from fact table and 'Job' from dimension table to dimension folder.

Thanks! Jeremy getClass().GetResource() did the job. Smin.

No. I am not doing an applet. I have tried Fredrick's code above(thanks!) but result is the same. No error and no image. This puzzles me. I am using Sun One Studio CE. Would it have to do with this problem? Thanks for any help.

I had the same code and same problem. The code compiled fine without any errors but image did not show up in my case. Any hint appreciated.

It will leave source data intact.

Also try this. set oConn = DTSGlobalVariables.Parent.Connections.New(&quot;Microsoft.Jet.OLEDB.4.0&quot;)