Help querying for a specific date
in [Programming SQL]
|
Prev: Query Help.
Next: Clustered and Keys
From: Tom Cooper on 6 Aug 2010 23:56 "Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message news:Xns9DCCF2DFEFE3CYazorman(a)127.0.0.1... <snip> > You would have to post the CREATE TABLE for all 100 columns. But you > could have posted the CREATE TABLE with the pertinent columns and > also INSERT statements with sample data, and the expected results > given the sample. <snip> I'm pretty sure Erland meant to say You would <NOT> have to post the CREATE TABLE for all 100 columns... Tom
From: Erland Sommarskog on 7 Aug 2010 04:44
Tom Cooper (tomcooper(a)comcast.net) writes: > "Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message > news:Xns9DCCF2DFEFE3CYazorman(a)127.0.0.1... ><snip> >> You would have to post the CREATE TABLE for all 100 columns. But you >> could have posted the CREATE TABLE with the pertinent columns and >> also INSERT statements with sample data, and the expected results >> given the sample. ><snip> > > I'm pretty sure Erland meant to say > > You would <NOT> have to post the CREATE TABLE for all 100 columns... Yes, I am very glad if I don't have to work with 100-column tables, on the newsgroups or elsewhere. Thanks, Tom! -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |