I have two non-clustered indexes on one of my dbs and their definition are:
CREATE NONCLUSTERED INDEX [NC_Index1] ON [dbo].[anyTable]
INCLUDE (A ,
CREATE NONCLUSTERED INDEX [NC_Index2] ON [dbo].[anyTable]
If my answer is accepted and then someone else adds an answer that isn't as good but has a few points that I didn't have should I add those points to my answer? Feels like I would be stealing their ideas/work.
anybody have a great way to convert a string formatted as 214000 into a DATETIME value 21:40:00 ? I can use SUBSTRING etc, but I'm hoping there is a nice canonical way for SQL Server to do the work for me. Much like CONVERT(DATETIME, '20141031', 112) returns a datetime of 2014-10-31 00:00:00
@mmarie i'm getting there early. sunday afternoon. my wife's coming with me and leaving thursday morning early. we've never been to seattle so we're trying to take a little time to get away from kids and such.