I Have Been running this Query

DBCC SHRINKFILE (GTM_log , 10)

Regards

Giri

I Have Been running this Query

DBCC SHRINKFILE (GTM_log , 10)

Regards

Giri

Hi

Jeff

i placed query including output And how i need an output everything on my question u just look in to my first question ...

Regards

Prakash

hi Jeff

i donot know why it is not working i wrote the query as u mention in the link but i could not get the result

thanks &...

hi buddy

i have already tried this one but its not working please provide some other solutions ..

thanks & regards

Prakash

hello carines

i have searched in google but i couldnot get any such kind of query with datewise so u please kindly write a query and send me .

thanks &...

hello chriss

its no were use for me iam getting all wrong data with ur query so please change my query as per my requirement

regards

Prakash

Hi

this is my query

SELECT T2.[U_CHAP] 'ChapterId',

(SELECT [U_Quantity] FROM [dbo].[@RGINPUT] WHERE [Name]= T2.[U_CHAP])'Opening Bale Qty',

(SELECT [U_Bale] FROM [dbo].[@RGINPUT] WHERE [Name]= T2.[U_CHAP])'Bale',

CONVERT(VARCHAR(10),T0.[DocDate],103) AS PcsDate ,SUM( T1.[Quantity]) as...