Data extrapolation on the fly

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mohit Nayyar » Data extrapolation on the fly

Data extrapolation on the fly

Rate Topic

Display Mode

Topic Options

Author

Message

Mohit Nayyar

Posted Friday, September 26, 2008 7:16 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 7:36 PM
Points: 148, Visits: 69

Comments posted to this topic are about the item Data extrapolation on the fly

Thanks
Mohit Nayyar
http://mohitnayyar.blogspot.com/
"If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

Post #577229

jcrawf02

Posted Friday, November 14, 2008 6:00 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:46 PM
Points: 2,561, Visits: 18,910

I think you lost me here:

Here I am trying to achieve the same without storing data in temp./staging tables.

First I am creating a temp. table wih 2 rows

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Post #602656

Mohit Nayyar

Posted Friday, November 14, 2008 8:57 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 7:36 PM
Points: 148, Visits: 69

I am creating the temp. table to DEMO the functionality. But in real world case you will use the actual table. So not temp. table required for extrapolation.

Please let me know if there is anything else I can help with.

Thanks
Mohit Nayyar
http://mohitnayyar.blogspot.com/
"If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

Post #602856

RC Davis

Posted Friday, November 14, 2008 11:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 20, 2010 3:42 PM
Points: 1, Visits: 15

FYI this does not work for SQL Server 2000.

Post #602958

Mohit Nayyar

Posted Friday, November 14, 2008 11:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 7:36 PM
Points: 148, Visits: 69

Yes, this is very much clear for everyone who understands CTE.

Thanks
Mohit Nayyar
http://mohitnayyar.blogspot.com/
"If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

Post #602963

« Prev Topic | Next Topic »

Permissions