Don't see where do you expect to gain performance.

If you'll do what you want to do performance will only suffer.

What you need to do is to revise your "lots of...

kpi_desc = case dbo.tblCampaign.idMacroSegment

when 1

then

case dbo.tbl_kpi_sales.idKPI

when 2509 then 'Con Std'

when 2513 then 'Con...

Ouch!

30 minutes!

You must be kidding.

I thought my terribly long script generating complex XCBL was too slow - it took up to 3 seconds...

It's what BOL says.

Unfortunately it's not true.

DATETIME is not exactly FLOAT.

It's "FLOAT with constraints"

Who told you you need cursors for "XML EXPLICIT"?

And it takes less than 2 days to learn.

Change function GetFirstAndLastGiftInfo to a view and join it to table People on people_guid= people_guid

Are you running it against the same database or against the copy in DEV?

Hm, I would say it's a question for primary school pupils.

How to get number of seconds if you know number of millions of seconds?

Then if you'll use DATEADD function you'll...

Read about "FOR XML EXPLICIT" in BOL.

Probably everything you need is there.

In first post you mentioned only one column.

Which one?

What is datatype for that column?

RSingh,

probably your company needs to hire a professional to build your database and your queries.

Almost everything I see here is just inappropriate.

Everything.

This toy may work for dull databases with...

Angelindiego,

I posted it just several hours ago.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=388102

But I see the number of "programmers" not having any clue and (here is the problem) not bothering to RTFM is no that...

How many rows does your query update?

What is the size of each line (sum of DATALENGTH for all columns)?

Is there any chance of CROSS JOIN for those tables?

It typically happens...

The only case I can see when numbers after decimal point may be got truncated is when you use STR function without {length , decimal} specified.

Something like this: STR(12.45)

Check BOL...