Hi

I have resolved the issue and doesn't need your comment or answer. Your comment is too late.

Hi Allan,

I tried your suggestion and I have it working. I will appreciate if anyone can look over my query below for me.

WITH CTE AS (

SELECT s.* , ROW_NUMBER() OVER...

Hi  Bob,

Your query gives me an empty results.

Hi

Thanks for your response.

Doing below as per your suggestion give me error

View or function 't' is not updatable because the modification affects multiple base tables.

DELETE t

FROM (

SELECT s.* , COUNT(*)...

Thanks. A lot

Hi ScottPletcher,

I was worried about fragmentation but I just read I can use DBCC SHRINKFILE with TRUNCATEONLY and it will not cause fragmentation. Am I on the right track with...

Yes, I have Implemented Foreign Keys with on delete cascade but getting error unable to delete on multiple keys

Hi Alan

Thanks very much and happy to know from an authoritative source that I am doing the right thing with Data Warehouse. I appreciated your input.

Eb

I have the attached screen a my cube model. Now I am finding it difficult getting all the relationship to work well using the DSV. But I can write...

Hi

Thanks very much. I have managed to get it working the way I want

Thanks a lot

Yes, all the users name added have sysadmin rights. Ok. I will change the password for sa and see. Thanks a lot

Thanks got it resolved. I left out OUTPUT INSERTED clause I was using

Nothing happens. Below is my vb.net code

Protected Sub btnSaves_Click(sender As Object, e As System.EventArgs) Handles btnSaves.Click

Dim SubmitQueryStringSuggID As String = Request.QueryString("SuggID").ToString()

...