My source table looks like this Id StartDate 1 (null) 2 12/12/2009 3 10/10/2009 I want to create a select statement, that selects the above, …
sql sql-server-2005 case smalldatetimeI have query: SELECT name FROM ( SELECT name FROM Hist_answer WHERE id_city='34324' AND datetime >= DATE_…
sql sql-server-2008 keyword smalldatetimeI have a flat file which is imported into SQL Server via an existing SSIS package. I need to make …
sql-server date ssis smalldatetimeI have a table with 800+ records. In this table I have a column named 'Data' of varchar(10) datatype which contains …
sql-server sql-server-2005 varchar smalldatetimeI've read several articles about using data types that support dates in SQL Server but I'm still undecided about what …
sql-server datetime2 smalldatetimeI have a view that basically just returns all records from a table, and adds a column 'isodate' which is …
sql sql-server smalldatetimeIf I don't care about less than seconds, what should be the recommended type to store my datetime values in …
visual-studio sql-server-2005 datetime smalldatetime sql-typesI am trying to compare L.LoanDueDate (which is a smalldatetime) to the return value of ufnARCUGetLatestProcessDate() (which is an …
sql sql-server tsql casting smalldatetime