Search Results | SQL Server Performance Forums

How to aggregate this table

Thread by: mita, Jan 21, 2007, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi guys I need to aggregate a table to three different levels but I need the results in a single table. Here is the sample data IndicatorName...

Outer join problem

Thread by: mita, Nov 7, 2006, 1 replies, in forum: General Developer Questions

guys I have got two tables which I need to join table 1 DHBName DHBService PU Budget Admission ABC...

how to prorate?

Thread by: mita, Sep 17, 2006, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi Guys I Have not been able to solve this problem from quiete a while now. I am using sql server 2005. I have got a table which contains these...

Multiple AND in having

Thread by: mita, Aug 21, 2006, 4 replies, in forum: General Developer Questions

Hi Guys I need to use 3 conditions using AND in my query. Its in the following format: SELECT Indicatorid, DHBName, PHOName, PracticeName,...

Bulk insert problem

Thread by: mita, Aug 1, 2006, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi guys I am using the Bulk insert command to import a flat file to the SQL server 2005. My flat file contains about 1 million rows. I have already...

Tough one

Thread by: mita, Jul 23, 2006, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi guys I have not been able to solve this problem from quiete a long time. I was not able to explain my problem clearly in my earlier post. My...

export/import problem

Thread by: mita, Jul 23, 2006, 2 replies, in forum: General Developer Questions

Hi guys I am trying to import a text file into sql server but sql doesnt let me do that. My flat file is in the txt format. Here is a part of my txt...

Complicated query help!!!

Thread by: mita, Jul 11, 2006, 18 replies, in forum: General Developer Questions

Hi I have got two tables and have one to many relationship on them. i ll show you the sample data Table 1 ID DoctorName Practice Full_Time...

Sql 2005 memory error

Thread by: mita, Jun 26, 2006, 4 replies, in forum: SQL Server 2005 General DBA Questions

I installed sql 2005 standard edition o windows 2000. sql server is running fine but having problems with the report server..when i try to do a query...

Report server configuration problem

Thread by: mita, Jun 19, 2006, 0 replies, in forum: SQL Server 2005 Reporting Services

I just installed ms sql 2005 standard edition.. everything went fine but whenever i run a report in BIS, an out of memory exception is thrown by the...

equal distribution of dates

Thread by: mita, Jun 17, 2006, 6 replies, in forum: SQL Server 2005 General Developer Questions

i have a table in which i have three columns- start dates,end dates and volume..the table has got about 90 000 rows ... i want to distribute the...

out of memory exception

Thread by: mita, Jun 14, 2006, 2 replies, in forum: SQL Server 2005 General Developer Questions

i have got a table as follows Y2002 funder fmis_code client_nhi Servcie_id year jan feb mar dec azx 1223 4444...

Grouping large data

Thread by: mita, Jun 11, 2006, 1 replies, in forum: Analysis Services/Data Warehousing

I have got 3 huge tables here is the sample data table 1 Companyname id year volume_for_jan vol_for_feb.....vol_dec abc 1 2000 34 333 ......555 2...

Grouping large data

Thread by: mita, Jun 6, 2006, 15 replies, in forum: General Developer Questions

I have got 3 huge tables here is the sample data table 1 Companyname id year volume_for_jan vol_for_feb.....vol_dec abc 1 2000 34...