i have written a code in powershell that uploads documents inside a file to the page i want

Hulicat wrote: How do I generate the GUIDS (unique identifers) from a DTSX package? ExecuteSql task with a call to NEWID() Script Task with a call to new Guid() take your pick.

Maybe... I did it with SQL2005 before posting... don't have SQL2008 here... I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

;with cte as(select t1.*, t2.* from table1 t1 cross join table2 t2) select * from cte OR ;with cte as(select t1.*, t2.* from table1 t1 ,table2 t2) select * from cte :) Niladri Biswas

Thanks! Regards, Hulicat

Hello Niladri_Biswas, thanks for your help. Actually I know what the problem is I am just can't figure out the query. Example of data a problem. Fromcode Spend.spend rev.gross ABC 10 70 ABC 20 50 ABC 10 20 Results look like the following: rev.gross sum'd + spend.spend Fromcode spend.spend rev.gross abc 140 (expected 90) abc 160 (expected 100) abc etc I want the total for each column based on the fromcode but not joined sums if that makes sense. Thanks and Regards Regards, Hulicat

Thanks for that!!! You made it crystal clear and I have it working now!! Omce again thanks for taking the time to teach and give an example of perspective... That will really help me moving forward. Thanks and Regards, Dennis Regards, Hulicat

Coool... I Love T-SQL "Don't torture yourself,let the life to do it for you."

hi just use the process class and pass the args Cheers,Earn and Enjoy RRave MCTS,MCPD http://ravesoft.blogspot.com

Pete O`Hanlon wrote: The 3 key has the £ sign It's not a sign, it's a symbol. How picky am I? ;P Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

I got it thanks Regards, Hulicat

Bingo!!! muchos gracias Regards, Hulicat

Well - part of your problem is that you only identify the total at start, difference and total at end once. These have no relation to the rest of your query. I would suggest that you put the logic for the creation of these values into the main query. Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.

Got it...Thanks Srinivas! select count(*) as 'Total closed for range', Priority_type_name 'Priority', location_name 'Cient', email 'Engineer' , AVG(datediff(d,report_date,last_status_update_time )) AS [Avaerage time open] from job_ticket j inner join priority_type p on p.priority_type_id = j.priority_type_id inner join tech t on t.client_id = j.assigned_tech_id inner join location l on l.location_id = j.location_id where (last_status_update_time between @startdate and @enddate) and status_type_id ='3' group by l.location_name, t.email, p.Priority_type_name Regards, Hulicat

Thanks for the tips, they are greatly appreciated. Regards, Hulicat

Right I know that would seem obvious, however; if I group by client_id. Then I get the same error for "problem_type.PROBLEM_TYPE_NAME" I did not know you could group by more than one column; I have not seen that I threw it in and it worked. ~Thanks~ -- modified at 20:14 Friday 11th May, 2007 Regards, Hulicat