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,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...
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...
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...
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....
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...
Hi, I have a table with primary key constraint, whenever we try to violate it, say by adding duplicate data, it gives "Violation of PRIMARY KEY...
Hi, I could not understand 100% (fully) about the details displayed in query execution plan, server trace and client statistics. I am interested to...
Hi, I would like to use index tuning wizard effectively to identify the indexes to be used for a table. I don't know how to create work load file in...
Hi, I need your help in writing a hierarchical query, I have the following table structure, create table employee (empid char(2), empname...
Hi, I have a field with data type of numeric(10, 2), here some data contains only integer values and some contains fractional values also. Now, how...
Hi, I require your help in understanding the way data is maintained in sysindexes table, I have two doubts, 1) While creating a foreign key...
Separate names with a comma.
