Hey Raunak,

Thanks a lot for the valuable pointers ...

I had already installed the DW databases provided by MS as the same had been referred by the exercises in the book...

Hi Raunak ...

Thanks for the valuable guidance and pointers.

Surely I need to work more on the DW concepts and also on th OLAP.

Since the OLAP and DW concepts are implemented...

Hi Raunak ...

I have just started learning SSAS as I am working in SSIS, SSRS and SQL Server.

However I don't consider myself worthy enough to give any kind of rating...

Thanks a lot for your help.

Visited the site and downloaded the content.

Cant wait to see what there inside so that I can learn more and more.

Regards

Amartha

SELECT

tCOL1COL3.COL1 AS COL1,

tCOL2.COL2 AS COL2,

tCOL1COL3.COL3 AS COL3

FROM

(

SELECT

COL1,

COL3,

RANK () OVER(ORDER BY COL1 ASC) AS ROWNUMBER

FROM

SQLSerC /* YOUR TABLE HAVING COLUMNS COL1 (INT), COL2(INT), COL3(INT) */

)tCOL1COL3

INNER JOIN

(

SELECT

COL2,

RANK () OVER(ORDER BY COL2) AS...

Dear User,

I have happened to face similar kind of issue with subscriptions.

Why I say similar because I tried to generate files on the drive rather than sending them as mail...

Hi,

Its a application migration only. The database has already been migrated to SQL Server 2005.

We are only attempting to migrate the application wherein under the current configuration the structure of...

Thanks sql_lock for your marvellous support.

Hope I can give better touch to my presentation now.

Thanks a lot once again.

Thanks sql_lock for the quick reply. Quite a help in building the basics.

The article seems to be more on comparison with SSRS. Can you please guide me in having some...

Dear Markus,

Thanks a ton for your reply.

Actually this approach can't be used as this needs to hardcode the translation. But our approach needs to read the translation while generating the...

Hi....

One possible way to detect where it is going wrong is paste the SQL String in the Query Analyzer and click on the display estimated execution plan.

If you follow the...

Thanks a lot... Learnt a completely new stored procedure....

Use yourdbname

SELECT * FROM sysobjects WHERE xtype = 'TR'

To disable / enable selective triggers...

ALTER TABLE tableName DISABLE TRIGGER triggername

ALTER TABLE tableName ENABLE TRIGGER triggername

To disable / enable all triggers...

ALTER TABLE tableName DISABLE TRIGGER ALL

ALTER TABLE tableName ENABLE TRIGGER...

Dear Friend,

How about looking into manipulating the current system date & Time.

Use GetDate(), Remove the spaces and append with some other characters / digits of your choice (Based upon some...