Hi, I want to concatenate data from Field2 by grouping against Field1 data. I have provided below the sample data, from this I want to get output...
Hi, I would like to know the Command-line utilities available in SQL Server 2008, something similar to SQL*Plus, which is available in Oracle. Also,...
Hi, I want to upload the CSV File data into a table. It can be done using SSIS. I would like to know the other options available to do the same. In...
Hi, I would like to maintain the Current and Archival (few months old data) data separately. While maintaining Archival data, I could think of the...
Hi Anand, Thank you, when the dimension is created, data is retrieved from the underlying table and can be viewed. But, I am unable to process the...
Hi,In Analysis Services 2000, we are using "Oracle Provider for OLE DB" as the provider then, in the Connection tab, we are providing Data Source...
Hi, We are using Pivot Table object in MS-Excel 2003 to display the reports using OLAP objects like Cubes. It connects to an OLAP Server and database...
Hi,We are using SQL Server 2005. In SSAS, we created a dimension with 10 columns from a view and it returns 3000 rows in it. We created a cube using...
Thank you Adriaan, it is helpful. Regards, Deva
Hi, I am facing a problem in using convert/cast functions. If I simply give varchar as my datatype in the function, it returns only the first 30...
Thanks a lot Madhi <img src='/community/emoticons/emotion-1.gif' alt=':)' />, do we have any other alternative method?<br /><br />Regards,<br />Deva
Hi, We would like to transfer data from Excel sheet to a table. In the source excel, a column contains integer data for the first 10 rows and it...
Thanks a lot Madhi and FrankKalis. Regards, Deva
Hi, Our database is keep growing and we would like to reclaim the unused space. It has come to 5 GB, but the actual data should be in 500 MB or so....
Thank You Satya. Regards, Devendran R
Hi, I have a requirement, where, I want to generate a serial number within a date value. I cannot use identity field for this. I have provided...
Hi, Is it possible to do any programming in the View object, for example, in the code snippet given below, I would like to find out the date...
Hi, I am trying to upload data from a database table to excel application using SSIS. Here, one of my fields contain nvarchar 2000 characters. By...
Hi, We are developing a multilingual application, here, we can use data types like nChar, nVarchar and nText to store other language characters and...
Thank you Adriaan and Madhi. Regards, Deva
Separate names with a comma.
