Your problem is that your provided string value contains a comma in stead of a decimal !

This causes your convert statement to fail !

DECLARE @str NVARCHAR(MAX)

DECLARE @amount DECIMAL(18, 2)

SELECT ...

also keep in mind a "drop column xyz" is only a catalog operation !

That columns space will only get reclaimed after maintenance or reindex.

and you'll need to convert your date to month-name-part ...

Apparently it returns the data in the same order as the in-list

Select *

from (

Select P.name, TH.Quantity, convert(char(3), TransactionDate, 100) as TrxMonth...

That is a mail server issue .... contact your mail admins.

They may help you figure...

You are correct !!

Apparently it doesn't store the UserName, but the its internal identifier 'S-1-9-3-3482764364-1226597329-2493949361-1082924894'.

I wonder why they would do that !!

They should have documented this behaviour.

In my test...

Is it always object ID 7:1086626914:0 that suffers this issue ?

declare @ObjectRef varchar(128)

Set @ObjectRef = '7:1086626914:0'

Declare @DbId varchar(128)

Declare @ObjectId varchar(128)

Select @DbId = substring(@ObjectRef, 1, charindex(':',@ObjectRef)-1)

, @ObjectId = substring(@ObjectRef,...

parthi-1705 (1/27/2010)

This Time my problem is bit different

I am having a database with daily Full backup i did not put Translog backup for...

As you have seen I prefer these kind of "lookup" values in table rows.

If you really need the "original" parsed value, on top of the actual individual value, just extend...

I have the vast impression it must be something with this sqlinstance... the box should be able to cope with the threads without a problem.

Another thing is we are having...

any progress ?

Keep in mind HOW a between works with string values !!

Here's another way to get started ...

-- TEST IT -- TEST IT -- AND SEE WHAT IT DOES !!!

Declare @InputTable...

As always it depends ...

Partitioning only uses a single column to work on ...

If you aim to partition on one of the columns that currently composes your primary key ......

- removed because of stupidity - to early in the morning :hehe:

[Second Edit]

... after the furst cup of coffee :w00t:

Did you try this ?

/*

dd 20100128

http://www.sqlservercentral.com/Forums/Topic699260-1291-1.aspx

How can I create a temporary...

Good feedback.

OT : Keep in mind you should avoid running in lower edition db-level ! So switch to your engines dblevel whenever you can !

Well .... altough I cannot get the point of using a "don't know what status it is in, but it is not a known status" ....

This may be what you...