Viewing 15 posts - 91 through 105 (of 236 total)
So, here's what I'm going to do. Every table has a space or new line before each record. So I'll generate a list of tables and then run a replace...
January 14, 2015 at 5:42 pm
Jeff Moden (1/14/2015)
JoshDBGuy (1/14/2015)
krypto69 (1/14/2015)
I have a query that will go into an ssis package (eventually). The package will run every night at 3am. I need to capture the last...
January 14, 2015 at 3:56 pm
krypto69 (1/14/2015)
I have a query that will go into an ssis package (eventually). The package will run every night at 3am. I need to capture the last 24 hours of...
January 14, 2015 at 3:25 pm
JeremyE (1/14/2015)
right click the database>Tasks>Generate Scripts.
Select the 100 stored procs you need to modify and save it to a file.
Then use a text editor to...
January 14, 2015 at 3:04 pm
Sounds a bit funky but I guess it could work. I'd almost rather manually change them though.
January 14, 2015 at 2:57 pm
I just wanted to fill you guys in on what I discovered during my research. Unfortunately, there's not a lot of data around on DTC issues with clustering and SQL...
January 12, 2015 at 3:16 pm
Sorry about that. We have licenses for all instances but currently we are using the single 2008 instance for SSRS and we have data sources to all of the other...
December 29, 2014 at 4:27 pm
Unfortunately because I don't have server 2012, I can't. I did find through a Microsoft technet page that when it switches over, the replicated server should become the primary. So...
December 18, 2014 at 10:33 am
Allan Brooks (12/17/2014)
The Oracle DBA I work with was quick to point out that he can do it on his DB’s . . .
Haha, I'm sure he did.
December 17, 2014 at 10:12 am
Just a question, what's the reason?
You can always script out a restore to a new DB, script out the table migration (can use generate scripts to do this), and then...
December 16, 2014 at 10:39 am
Yes definitely a query issue. Make sure the query is updated. Unless the excel spreadsheet is shared, everybody's queries will have to be updated.
December 11, 2014 at 4:47 pm
Sorry if I'm not understanding but what logic do you want if the dates are exactly the same?
December 11, 2014 at 12:48 pm
There's also this
declare @uservariable datetime
set @uservariable = '2014-12-03'
select prod
, cost
, MarketDate
, row_number( ) over (order...
December 11, 2014 at 12:37 pm
Is this what you're looking for?
set @uservariable = '2014-12-03'
select marketdate
, cost
from #TestTable
where MarketDate<=@uservariable
December 11, 2014 at 12:04 pm
Have you checked the event viewer to see what the error is?
December 11, 2014 at 12:03 pm
Viewing 15 posts - 91 through 105 (of 236 total)