Based on the brief description it sounds like parameter sniffing. You might want to check Gails blog series[/url] for details and solutions.

If FREEPROCCACHE solves the issue and there are just...

You might have a different point of view then:

8000 is a round number....

What is your expected result? Are you looking for the min amount or max or sum or avg?

In case you're looking for the "first" amount, we'd need to know what...

MS seems to start evaluating...

I'd export the data using bcp and import it into the target db using bcp again.

Make sure the target db is set to bulk-logged recovery or Simple recovery.

The current approach...

If you decide to go for the "split string solution", at least use the "fast lane"[/url] and not the "pedestrian walk" 😉

sanmon_11 (3/5/2012)

---

Hi Lutz,

In the Query:

SELECT CAST(CAST(MotorEns_NoSerie AS NUMERIC(13,0)) AS VARCHAR(13)) FROM tbl_MotorEns

I got this Error:

Msg 8115, Level 16, State 6, Line 1

Arithmetic overflow error converting float to data type numeric.

any...

Wouldn't a simple DISTINCT do the job?

You could use an auxiliary table with username and Location (having three rows for user 'Ram' and three separate rows for user 'Krishna'.

Then query this table using the CROSS APPLY...

You have different column names in GROUP BY. Would it be possible to have some sample data in a ready to use format (see the first link in my signature...

Hence my point. When KNAPP does it it seems legal. when others do it it seems we are touching on infringement

If it is OK for Knapp to pass every pickers...

We're currently in a similar discussion and decided to go a slightly different route:

We asked MS to provide us with a legal ("bullet-proof") definition of a "device", since it can't...

You could try CAST(CAST(YourColumn AS NUMERIC(x,0)) AS VARCHAR(x)), where X is the number of digits you need to store. This under the assumption that you don't have serial numbers with...

There are several questions:

The most important one: why do you need to change a numeric value to a character value? What changed in the business case?

Why is the data type...

Step 1 would be to use datetime column instead of separate columns for year and moth.

Then you'd be able to use PIVOT. Not just for PIVOT but as a better...