Koen Verbeeck (5/1/2012)

---

Either you supply the password with package configurations (which I prefer), or you type them in into the connection manager and you set the Protection Level to one...

Thanks as always.

I wonder if there is a way to force sql server to restrict the ANSI conversion values between...

SQLKnowItAll (4/11/2012)

---

Lynn Pettis (4/11/2012)

---

Murphy'sLaw (4/11/2012)

---

SQLKnowItAll (4/11/2012)

---

Let me get this straight... Instead of meaningless ?'s, your client wants other meaningless characters? Clearly, the conversion is finding some conversion for the characters...

SQLKnowItAll (4/11/2012)

---

Let me get this straight... Instead of meaningless ?'s, your client wants other meaningless characters? Clearly, the conversion is finding some conversion for the characters in columns 7 and...

SGT_squeequal (4/11/2012)

---

What shold the question marks be do you know? should they be chinese characters? if so on the columns where the data is ? what is the datatype of...

Sean Lange (4/10/2012)

---

Seems that the bigger question is what are hoping to do with this information? I have a feeling that you want to see if the data right now...

bitbucket-25253 (4/9/2012)

---

Do you mean something like this?

CREATE TABLE [dbo].[Table_3](

[Col1] [nvarchar](50) NULL,

[Col2] [nvarchar](50) NULL,

[Col3] [nvarchar](50) NULL

) ON [PRIMARY]

INSERT INTO dbo.Table_3

SELECT NULL,NULL,'d' UNION ALL

SELECT 'X',NULL,NULL UNION ALL

SELECT NULL,NULL,NULL UNION ALL

SELECT NULL,'X','C' UNION...

Jack Corbett (4/4/2012)

---

Murphy'sLaw (4/4/2012)

---

Jack Corbett (4/4/2012)

---

The error is telling you that you have unicode characters in the source and you are losing them when converting to...

Jack Corbett (4/4/2012)

---

The error is telling you that you have unicode characters in the source and you are losing them when converting to non-unicode. It isn't really...

SQLKnowItAll (4/3/2012)

---

What Sean is saying here is that ANSI is not a results type, it is a standard. ASCII is a character...

Mark Fitzgerald-331224 (4/2/2012)

---

Please clarify your requirement with examples of the data held and the output required. The original post stated both ANSCI and ANSIC, neither of which I have...

My bad i din't do a good job in replicating the situation. that was simple update....

select prod_id,Order_id,

SUM(case when Saledate='1/10/2012' THEN Quantity else NULL END) as [10th Jan],

SUM(case when Saledate='1/11/2012' THEN Quantity else NULL END) as [11th Jan],

SUM(case when Saledate='1/12/2012' THEN Quantity else NULL...

preetpalkapoor (2/4/2012)

---

Hi All,

I have a question to be solved. Its a tricked one for me as i am not that much of experience.

prod_idsale_dateorder_idquantity

p1 ...

thanks.really helpful.