Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456»»

insert into temp table Expand / Collapse
Author
Message
Posted Monday, June 21, 2010 11:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, February 14, 2013 7:48 AM
Points: 2,647, Visits: 135
AHHHHH... yes! Why did I miss that?!

Thanks!
Post #940527
Posted Monday, June 21, 2010 12:13 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Nice question, thanks!
Post #940545
Posted Monday, June 21, 2010 12:44 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 24, 2014 4:29 PM
Points: 872, Visits: 954
Good question, I learned something new. Thanks!
Post #940565
Posted Tuesday, June 22, 2010 12:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 23, 2014 10:51 PM
Points: 20, Visits: 107
Can you beifly Explain this with an example I didn't the reason ?
Post #940775
Posted Tuesday, June 22, 2010 12:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 23, 2014 10:51 PM
Points: 20, Visits: 107
I totally agree with the Example. I have scenrio where I am creating Temo table using Select into #temp and later on using same table to insert data using Insert into Select from table.
Post #940776
Posted Tuesday, June 22, 2010 1:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 11:00 AM
Points: 1,142, Visits: 2,693
da-zero (6/18/2010)
Good question.
Lose one point but learn a useful fact. A good trade-off

Yep...This is what happended to me too. I don't mind loosing a point if I learn something.


---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #941310
Posted Tuesday, June 22, 2010 1:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Trey Staker (6/22/2010)Yep...This is what happended to me too. I don't mind loosing a point if I learn something.


I think it is interesting that people say they are losing the point(s), as if they are supposed to be automatic. (You never had the point to lose it; you just failed to earn the point.)

I agree in the cases that I failed to earn the point(s) I usually learned something, which is good. (Even if it was as simple as I needed to actually read the question instead of making an assumption.)
Post #941320
Posted Tuesday, June 22, 2010 11:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 7:12 AM
Points: 366, Visits: 455
Good question, learnt something new, thanks.
Post #941498
Posted Wednesday, June 30, 2010 10:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:50 PM
Points: 7,923, Visits: 9,649
UMG Developer (6/22/2010)

I think it is interesting that people say they are losing the point(s), as if they are supposed to be automatic. (You never had the point to lose it; you just failed to earn the point.)

Remember: English is a world language now. So your dialect may be different from someone else's dialect.

We talk about teams losing games, we talk about teams in leagues losing points, and we use "lose" for many more things which were never possessed by theose doing the losing, so according to you they could not be lost. So there are cases where it is normal to talk about "losing" something you never had, at least in all the versions of English I'm acquainted with. Also there are things for which one can't use "lose" that way, and which things those are varies from dialect to dialect (maybe even from idolect to idiolect). In my version of English points in an SQL trivia quizz are things you can lose even though you haven't got them (and indeed they can't be lost once you do have them). I guess the same applies to the people you were commenting about.



Tom
Post #945634
Posted Monday, August 16, 2010 4:48 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 1:02 PM
Points: 16, Visits: 71
Hugo's explanation had more about this question.. Thank you both..

__________________________________________________________
Yuvaraj
Post #969674
« Prev Topic | Next Topic »

Add to briefcase «««23456»»

Permissions Expand / Collapse