Can you provide the below function code..

dbo.GetTimeZoneDiff(@timeZone)..??

I hope this may help you..

*******************************************************************

Set Nocount On

Declare @InTableName Varchar(200)

Set @InTableName = 'Ac_LedgerMaster'

Declare @AllTables Table(Tid Int Identity(1,1),TableName Varchar(200), ObjectId Varchar(50))

Insert Into @AllTables(TableName, ObjectId)

Select NAME, OBJECT_ID From Sys.Objects Where Type =...

http://www.microsoft.com/learning/en/us/exam.aspx

This too may help you..

Wish you all the best..

Thnx Sleitch..for the code provided..

wht i have observed so far is:(by...

bteraberry (8/5/2010)

If you don't want to do any work I would suggest you hire a consultant.

You haven't provided the base data or table structures. You've merely provided the results...

Thank you all the members for their replies/suggestions who participated in my topic..

especially for Fritchey..

If any other reasons for "Reasons for difference in execution plans"..

Please dont forget to post here..

what...

??

Hi Fritchey..

happy to see your post for my topic..

Nice to meet you in this way..

And you said that Different Parameters also leads to...

Apart from all the above,

is there any chances because of change in the service packs releases of sql server..

Hi..

Any one can optimize(physically/logically) my code..

if possible please post the re-written code..

Eugene Elutin (8/3/2010)

I've looked through the posts and have not found the one where you have mentioned that data you have is result of pivoting it just looks like it...

Eugene Elutin (8/2/2010)

I wonder, does original data comes in a such "pivoted" way? I would think that you might have the same data somewhere in a bit different layout eg....

Even though introducing the tables(for the range values) is not working in decreasing the length of the code....

and i agree with you for introducing the UDF..bcoz it is going to...

Can you explain little bit clearly please....

if possible, can you rewrite the code ..

if any one asks me to write the same above code,

i will prefer the following way..

SELECT REPLICATE(0,LEN(DATEPART(M,GETDATE())))+CONVERT(CHAR(2),DATEPART(M,GETDATE()))

Can any one say which will be the optimized way to follow...??