Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE #temptable ( [Description] varchar(50), [Price] int, [Date] date )
- INSERT INTO #temptable
- VALUES
- ( 'Active', 799900, N'2019-02-27T00:00:00' ),
- ( 'Unknown', 629900, N'2014-09-24T00:00:00' ),
- ( 'Unknown', 629900, N'2014-09-12T00:00:00' ),
- ( 'Sold', 625900, N'2014-09-08T00:00:00' ),
- ( 'Unknown', 629900, N'2014-08-10T00:00:00' ),
- ( 'Active', 629900, N'2014-07-27T00:00:00' ),
- ( 'Pending', 629900, N'2014-07-25T00:00:00' ),
- ( 'Pending', 629900, N'2014-07-24T00:00:00' ),
- ( 'Unknown', 629900, N'2014-07-20T00:00:00' ),
- ( 'Active', 629900, N'2014-07-16T00:00:00' ),
- ( 'Active', 629900, N'2014-07-15T00:00:00' ),
- ( 'Taking Backup Offers', 629900, N'2014-07-11T00:00:00' ),
- ( 'Active', 629900, N'2014-06-28T00:00:00' ),
- ( 'Active', 629900, N'2014-06-27T00:00:00' ),
- ( 'Taking Backup Offers', 629900, N'2014-06-27T00:00:00' ),
- ( 'Active', 629900, N'2014-06-23T00:00:00' ),
- ( 'Active', 629900, N'2014-06-11T00:00:00' ),
- ( 'Active', 629900, N'2014-06-10T00:00:00' ),
- ( 'Sold', 570000, N'2010-01-22T00:00:00' ),
- ( 'Sold', 288000, N'2000-09-01T00:00:00' )
- DROP TABLE #temptable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement