Hi Dev,

Thanks for your response. Am I right in assuming that this "Fact Less Fact" table is a bridge table? If not can you please tell me if bridge table...

Hi Dev,

Thanks for your response. Each vacancy in my database is linked to more than one industry and role. In such case how do I design my fact table?

Cheers

Hi Vladan,

Thanks for the response mate. After wasting nearly 1 day on this problem, I also came to the same conclusion.

Phani

Hi Jesper,

I am in need of your help mate. Last time I asked for 2 seperate outputs for company & office. Now the client is asking for an output like...

Jesper,

Thats the exact output I want. Smashing stuff mate. Thank you very much.

Phani

Hi Jesper,

This is super stuff. Thanks a lot. Can you tell me how I can get the following output (without using any cursors)...

Your Solution

select off_name, usr_name,

sum(case when status = 'waiting'...

Add the WHERE Clause before Order By Clause. something like this....

SELECT DATE, ClassRoom, Status FROM first_table INNER JOIN class_table ON class_table.class_id=first_table.class_id WHERE ID>1 Order By ClassRoom

Hi Raj,

You can get the output in the following way......

SELECT DATE, ClassRoom, Status FROM first_table INNER JOIN class_table ON class_table.class_id=first_table.class_id Order By ClassRoom

Phani

Hi Jagan, you can either take Grasshopper's route or implement the following code to resolve the issue....

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

Declare @strSQL as varchar(100)

 Set @strSQL='Declare @Out as Integer Select @Out = Count(*)  from '...

Hi Marc,

You can use DataLength function to get the length of data stored in text fields.

Cheers...

Phani

SELECT without_a_column INTO xxx FROM Original_table;

DROP TABLE Original_table;

RENAME xxx TO Original_table;

Cheers......

Answer1.

If you are thinking of creating temp table in a stored proc, the best way is to create memory tables rather than temp tables. This is because,  memtables give better performance...

Hi Frank,

Thanks very much for the information. Though it is a tedious task I have to do it at some point.

Cheers....

Phani

Hi David,

It worked and I am using xp_file now.

Thank you very much for your help.

Cheers....

Phani

Hi David,

I am using SQLServer2000 and therefore bit confused about the location of include files you mentioned.

Could you please give some more information?

Ta,

Phani