Viewing 15 posts - 31 through 45 (of 130 total)
Are you talking about converting the values in a sql script or actually changing the data type of the field in the table?
Let us know what you've tried already. ...
August 15, 2013 at 9:13 am
Did this with Win2003/SQL2000/SQL2005 cluster to Win2008R2/SQL2005/2008 cluster...
You can't really move # of databases at a time since they'll be on specific instances. You'd have to move an...
August 15, 2013 at 8:59 am
Try looking at recursive CTE or adjacency model to start. There's plenty of good articles on SSC on what you want to do.
[Edit]
Oops yeah that works. Didn't read...
April 19, 2013 at 8:13 am
Nevermind... can't do it the ActiveX COM object is 32bit and SSRS is 64bit...
my IDE is 32bit... oh well...
If anyone know's magic to get it to work let me know...
March 6, 2013 at 2:47 pm
If you're just looking for a single SP to access the same data I'd just setup a 3rd SP to call one or the other...
if your looking for just 1...
February 21, 2013 at 10:23 pm
Please read the link below in my signature about good ways of asking for help. You're question is hard to understand and incomplete from what I can tell. ...
February 18, 2013 at 11:27 pm
Raghavender (2/18/2013)
Windows 2008
64 or 32 bit (OS, SQL)? Just upgrading SQL Server or hardware/OS upgrades as well?
Personally I'd upgrade 1 instance at a time side by side (Generally)...
1. Setup...
February 18, 2013 at 10:51 pm
Superdoc (2/18/2013)
February 18, 2013 at 10:34 pm
Sounds like the data in the file isn't completely loaded into table1 before you start the insert into table2, maybe getting dirty reads... what isolation level? I'm going to assume...
February 18, 2013 at 10:26 pm
Write it and test it. Tweak it and test it. Tweak some more and test it. test test test.
February 11, 2013 at 10:31 pm
Similar to the one above... you can run this entire script and see the results...
The one above was missing the Vulerability ID field...
--================Setting up sample data========
declare @master as...
February 8, 2013 at 10:57 am
Lynn Pettis (2/8/2013)
mehta.saurabhj (2/8/2013)
No i said similar have a look you idiot!!!This is a professional site and this is totally uncalled for.
I completely agree. If he's here to get...
February 8, 2013 at 9:35 am
mehta.saurabhj (2/8/2013)
what is the difference between assertion and the check constraint as both of them do the same function?Please give an example
Maybe there's something that I'm missing but Assertions and...
February 8, 2013 at 9:06 am
SceloM (2/8/2013)
I want to present to management about moving our reports into SSRS and need assistance in answering this question.
When an SSRS report is deployed does the database travel with...
February 8, 2013 at 8:55 am
Not sure if it'll work but it's something to try...
Try the Conditional Split Task.
Capture the file name and parse out the file type in the loop and store in variables.
Then...
February 8, 2013 at 7:33 am
Viewing 15 posts - 31 through 45 (of 130 total)