My clustering knowledge is a bit out of date, since it used to be called MSCS, but I believe you can manually add non-cluster aware services to the cluster so...

Any drawbacks to detach, move and reattach DB?

This might work if you can arbitrarily pick the matching sets... what happens when the other 4 comes in for the 10 amount? Do you show 2 10 Descr...

So how do we know that the 10 amount with a 4 is the end of which of the 2 10 transaction with a 3?

I don't think there's enough info,...

Adding a DNS entry for the IP address should do it.. there should already be an entry for it based on the computer name... assuming a windows environment.

I believe the query to text file saves as an ANSI but for Russian(Cyrillic) you need to have it encode the text as Unicode(UTF-8).

I'm not sure how to do that...

Agreed with Jack... for Cyrillic you need to use unicode or you'll get garbage that looks like a bunch of question marks.

I like using parsename... as long as is no more than 4 parts.. 😛

DECLARE @x TABLE (yourvalue varchar(20));

INSERT @x VALUES ('72187-1'),('72187-2'),('72187-12'),('555666-99999');

select yourvalue

,Parsename(REPLACE(yourvalue,'-','.'),1)

from @x

Nevermind I found what I needed. Page Setup is for printing only :crazy:.

http://technet.microsoft.com/en-us/library/dd283105.aspx#Pagination

Page Sizing

When the report is rendered, the Word page height and width are set by the following...

GilaMonster (10/15/2013)

---

It's perfectly capable of doing an implicit or explicit...

The reason I brought this up was I have a giant text blob that is parsed and it returns all the values as varchar.

But for some reason it's trying to...

I understand that integers don't have decimals but we can convert a decimal to an integer.

Does this mean that SQL can't do...

You seem to have a a few basic questions that sound a lot like test/homework questions. I think this is your 2nd question on CAST/CONVERT issue, If you need...

Shaun2012 (8/15/2013)

---

Hello,

I am receiving this error type always, when i move my package from test server to production server any idea abt it and wht to do..

Error1Error loading package1.dtsx:...

You can do a search and replace in the XML. As long as you don't mess with the schema and it's valid. In VS you can do a...