Its a Document management product which supports SQL and Oracle both. Table structure is kinda flat not relationship based. My client has installed on SQL now they want to move...

lol..the method seems painless ..let me try and revert back but more suggestions are welcome 🙂

Chris...hats off to yaaaaaaaaaaaaaaaaa 🙂 so awesome and superb fast...I simply praised you for the awesome query 🙂 Wish I could learn SQL like ya 🙂

ChrisM@Work (3/7/2013)

---

DECLARE @ItemCod VARCHAR(8000) =...

i have solved my own question like this.

CREATE PROCEDURE [dbo].[Proc_GenerateDocNo]

@BGroup varchar(3),

@DocType varchar(3),

@DocNumber varchar(15) OUTPUT

AS

BEGIN

DECLARE @curr_Seq varchar(50)

SELECT @curr_Seq = ISNULL(MAX(right(All_Documents.DocNo,4)),'0000')+1 FROM All_Documents

WHERE LEFT(All_Documents.DocNo,3) =...

This is the procedure i already have which is showing day wise sum of a given month and i want to convert this into week wise. To cross check the...

ColdCofee,

I've executed your stored procedure. The results are not correct for some reason. For example if you run the following query and check the outcome for "Accounts Closed" these figures...

Jeff,

I do need it in stored procedure but in ASP.NET report builder ask for a stored procedure and then it fetches the name of colums return by the procedure and...

ColdCofee,

Thanks for the lovely query. Actually I am developing a application in ASP.NET where datasets for reporting doesnt populate through dynamic query which has EXEC(@SQL) statement and tmp tables. it...

ColdCofee you are right I am embarrassed so please accept my apology. I want to come up with a stored procedure where i will just pass month number and year...

Jason awesome...:-) guess what? I just kicked myself...gosh it was so easy ..thank you so much for your guidance 🙂 I have oracle background and learning sqlserver is kinda steep...

sturner you are bad at guessing things and i guess its kinda rude to pass such comments on your presumptions. Anyway its indeed a financial industry related problem (if you...

Lutz and Jeff,

I have only date datatype not time as I dont need time stored in table. Although i always find a problem regarding date formats. I want to keep...

this is what i did. the WHERE condition was the problem which was filtering right after grouping so removed where thats it:)

DECLARE @startDate varchar(20)

DECLARE @endDate varchar(20)

...

ive solved my problem 🙂

is there any other way ?