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...
guys I have got two tables which I need to join table 1 DHBName DHBService PU Budget Admission ABC...
I apologise for not being able to explain my problem to you properly. Volume is the one which is under the column no of units. I tried to cut and...
Thats what I want If the month and year of service start equals that of service end, then no of units remain same . But if the month and year of...
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...
Hi Guys I need to use 3 conditions using AND in my query. Its in the following format: SELECT Indicatorid, DHBName, PHOName, PracticeName,...
Thanks Haywood...I just did what you suggested..I have solved my problem.. Cheers
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...
Really sorry for my above post aefager. I thought all these things which u said were meant for me.. in fact it was for somebody else... Really...
Hi aefager Thanks for your reply. Well things which u said were quiete rude.. its ok if i wasnt able to make u understand what the problem was and i...
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...
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...
hey guys..<br />just clarifying.. is it the answer to my post or has karthikm just added his post below mine??[}<img...
Thanks for your help Karl.. I ll definately try this out..but i need to clarify onething with you, does this above query take care of any number of...
Hi Karl Thanks for replying.. well sorry if i didnt tell you that i created relationships only to make the problem simpler..but i could not go any...
Hi joe Thanks for your help..it does give me some direction but can i guess i was not successful in explaining you the problem clearly.. i ll do it...
Hi Thanks for the help.. Well i am sorry if i did not make myself clear.. This query was sent to us from our clients as i am working in a health...
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...
well i guess the problem is not with the backend because the same query runs correctly in management studio.. i think its the size of the memory(may...
i have got a 64 bit system only. I need to generate the reports for our clients We have got huge tables on which we perform some sort of aggregation....
Separate names with a comma.