Viewing 5 posts - 16 through 20 (of 20 total)
select * from sys.tables
Buzz
March 26, 2009 at 5:24 am
#966529
From the expected results, it looks like you want to retain status changes and not delete duplicates
March 25, 2009 at 7:19 am
#965963
March 25, 2009 at 7:18 am
#965961
select right('00' + cast(month(getdate()) as varchar), 2)
is a little shorter
MRB
March 11, 2009 at 7:25 am
#957459
For a once only export use SQL Server Import and Export Wizard:
Right Click on the Database then:
Tasks->
Export Data->
Next->
Data Source = PRINCE ->
Destination = Microsoft Excel; Excel File Path =...
February 20, 2009 at 3:37 am
#947395