That is the problem the character set you must have gotten it out of was symbol so if on a web page you display it it might look like this

[font="arial"]TRANSCOPYâ[/font]

when...

As well the font can sometimes give you other than intended results.

It all depends on your output method and what character sets they support.

Not that I can recall but there have been several scripts posted to use the system tables or schema views in the past to do this or you could build...

Can you please expand the code for this back to the function with any sensitive info altered?

addNewOrder = New SqlCommand("InsertNewOrder",tr.Connection)

session("NewOrderID") = AddNewOrder.ExecuteScalar()

I want to understand your path thru

When you say junk characters exactly what do you mean?

As for design NVARCHAR whill accept any valid character unless you have constrained to a limited list.

Are you trying to...

I agree most people tend to have someone whose job it is specifically. Although in small houses it depends on who has the best knowledge the DBA or an App...

allen davidson (11/28/2007)

---

From what I understand if nulls are allowed the on disk data adds a supporting column consisting of a bit map that identifies which columns in a particular...

Hey bittucket your code doen't cycle to the next column. But based on that here is a simpler method commonly used

DECLARE @TableName AS VARCHAR(64)

DECLARE @sql AS VARCHAR(4000)

SET @TableName = 'LocDetail'

SELECT...

Don't fully understand, you saw if Wed you want Thur, Fri, and Sat, what about Sun, Mon and Tues. All in all however look at DATEPART with the wk parameter,...

Take a look here and see if helps.

Megha Yadav (11/13/2007)

---

Hi Guys,

I have come across a DB where there are no Foreign key relationship's ...

Is this a wise thing to do? ... Since the data is being...

Loads of ways to do, here is what I was talking about.

DECLARE @MyDate NVARCHAR(6)

SET @MyDate = '112807'

SELECT CAST(STUFF(STUFF(@MyDate,5,0,'/'),3,0,'/') as DATETIME)

It changes, India and China have been the biggest but inflation may drive people away in the near future. Phillipines are the next big target from what I have seen....

Normally I would do something like this

Invoices

Invoice_ID indentity(1,1) int or bigint primary key,

Customer_ID (fk to purchasers information)

and a table for items

Invoice_Details

Item_ID (FK to purchased item where decription comes from),

Quatity,

Price_Per_Item,

Discount_Applied

Then...