Database

DECLARE @TableVar1 table(
    Col1 int NOT NULL,
    Col2 varchar(100),
    Col3 datetime
)

INSERT INTO @TableVar1 (Col1, Col2, Col3) VALUES (10, 'Hello', GETDATE())

Select something From tableThis Where ID In (Select somethingelse From tableThat Where condition );

select t1.* 
From tbladussentry t1
join tbladusentry t2
    on t1.SID = t2.Id
join tbladuset t3
    on t2.SID = t3.ID
    and t3.CID in(108,367)

Select Data = CAST(ltrim(rtrim(CAST(@RowData AS nvarchar(max))) AS ntext)

current1999 wrote:

After processing your ETL package which loads data into the cube, how do you
ensure that your cube has been processed?

   try
    {
        //--------------------------------------------------------------------------------
        // For each database on the server, we'll display its name and other objects names.
        //--------------------------------------------------------------------------------
        foreach (Database db in server.Databases)
        {
            Console.WriteLine("{0}", db.Name);

            // Display Dimensions
            Console.WriteLine("\tDimensions:");
            foreach (Dimension dimension in db.Dimensions)
                Console.WriteLine("\t\t{0}", dimension.Name);

            // Display Cubes
            Console.WriteLine("\tCubes:");
            foreach (Cube cube in db.Cubes)
            {
                Console.WriteLine("\t\t{0}", cube.Name);

                // Display Measure Groups
                Console.WriteLine("\t\tMeasure Groups:");
                foreach (MeasureGroup group in cube.MeasureGroups)
                {/**/
                    Console.WriteLine("\t\t\tGroup Name: \t{0}", group.Name);
                    Console.WriteLine("\t\t\t\tSource: \t{0}", group.Source);
                    Console.WriteLine("\t\t\t\tCreated: \t{0}", group.CreatedTimestamp);
                    Console.WriteLine("\t\t\t\tLast Proc: \t{0} ", group.LastProcessed);
                    Console.WriteLine("\t\t\t\tEstimatedSize: \t{0} ", group.EstimatedSize);
                    Console.WriteLine("\t\t\t\tStorageLocation: \t{0} ", group.StorageLocation);
                    string sState = "None";
                    switch (group.State)
                    {
                        case AnalysisState.Processed:
                            sState = "Processed";
                            break;
                        case AnalysisState.PartiallyProcessed:
                            sState = "PartiallyProcessed";
                            break;
                        case AnalysisState.Unprocessed:
                            sState = "Unprocessed";
                            break;
                    }
                    Console.WriteLine("\t\t\t State: \t{0}", sState);
                    Console.WriteLine("\t\t\t\t Type: \t{0}", group.Type);

                    foreach (Measure meas in group.Measures)
                    {
                        Console.WriteLine("\t\t\t\t\t Name: \t{0}", meas.Name);
                        Console.WriteLine("\t\t\t\t\t\t Expression: \t{0}", meas.MeasureExpression);
                        Console.WriteLine("\t\t\t\t\t\t Aggregate: \t{0}", meas.AggregateFunction);
                        Console.WriteLine("\t\t\t\t\t\t DisplayFolder: \t{0}", meas.DisplayFolder);
                        Console.WriteLine("\t\t\t\t\t\t Source: \t{0}", meas.Source);
                        Console.WriteLine("\t\t\t\t\t\t DisplayFolder: \t{0} ", meas.DisplayFolder);
                        //Console.WriteLine("\t\t\t\t\t{0}", meas.);
                    }
                   foreach (MdxScript mdx in cube.MdxScripts)
                   {

                            string MeasureName = mdx.Name.Replace("[MEASURES].[", "");
                            MeasureName = MeasureName.Replace("]", "");

                            Console.WriteLine("\t\t\t\t\t Name: \t{0}", MeasureName);
                            Console.WriteLine("\t\t\t\t\t\t DisplayFolder: \t{0} ", mdx.Annotations);

                    }
                }


            }

            // Display Mining Structures
            Console.WriteLine("\tMining Structures:");
            foreach (MiningStructure miningStructure in db.MiningStructures)
                Console.WriteLine("\t\t{0}", miningStructure.Name);
        }
    }
    finally
    {
        server.Disconnect();
        server.Dispose();
    }
}
catch (AmoException e)
{
    Console.WriteLine(e.ToString());
}