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 12»»

Table Variables Expand / Collapse
Author
Message
Posted Wednesday, November 26, 2008 8:39 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 1:53 AM
Points: 1,569, Visits: 57
Comments posted to this topic are about the item Table Variables
Post #609536
Posted Wednesday, November 26, 2008 8:42 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 9, 2013 8:07 AM
Points: 1,220, Visits: 2,614
I was expecting at least a 10 point Turkey question on Thanksgiving. :D

Ken Simmons
http://twitter.com/KenSimmons
Post #609538
Posted Thursday, November 27, 2008 2:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:45 AM
Points: 16, Visits: 115
Is there any option (work around) by which we can edit the table variables ?
Post #609619
Posted Thursday, November 27, 2008 2:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 5:50 AM
Points: 1,234, Visits: 1,435

Steve only does 10-pointers for Pagan festivals, Like Halloween and Yuletide :D

Post #609623
Posted Thursday, November 27, 2008 2:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 5:50 AM
Points: 1,234, Visits: 1,435
Narasimha Pradeep (11/27/2008)
Is there any option (work around) by which we can edit the table variables ?


You could SELECT the contents to another local table variable, and modify that. But you cant make a table variable an OUTPUT parameter - there's no point really as they're READONLY
Post #609624
Posted Thursday, November 27, 2008 5:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:10 AM
Points: 1,274, Visits: 1,987
Tom Brown (11/27/2008)

Steve only does 10-pointers for Pagan festivals, Like Halloween and Yuletide :D


... And Thanksgiving is a Political holiday? :D


Derek
Post #609709
Posted Thursday, November 27, 2008 5:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 5:50 AM
Points: 1,234, Visits: 1,435

Ermm .. you caught me out there - as a Brit I have no idea what Thanksgiving is - did it ever have a Christian church trying to ban it or rename it or take it over - if so then it probably was pagan originally.

Post #609733
Posted Saturday, November 29, 2008 10:01 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:15 AM
Points: 5,471, Visits: 1,402
I also thought atleast a 5 pointer is comming to have a great thanksgiving holiday.. ;)


Post #610735
Posted Monday, December 1, 2008 11:28 AM


SSC Eights!

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

Group: General Forum Members
Last Login: Monday, November 2, 2009 8:46 AM
Points: 875, Visits: 313
Tom Brown (11/27/2008)

Ermm .. you caught me out there - as a Brit I have no idea what Thanksgiving is - did it ever have a Christian church trying to ban it or rename it or take it over - if so then it probably was pagan originally.



Think Pilgrims - Mayflower - looking for a place to practice their religion (but not allowing others to practice theirs!) - and giving thanks to God for getting through the first brutal winter in a foreign land (only 5 adult women survived the first winter).
Post #611543
Posted Monday, December 1, 2008 11:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 10:36 AM
Points: 31,362, Visits: 15,823
Sorry, was in a scheduling mode and missed this was a holiday. I know, I know, I should pay more attention. Between PASS and Thanksgiving (plus vacation) wasn't keeping track of dates.

We'll add in a good one for Xmas, maybe even one for Christmas Eve and New Year's.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #611556
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse