viswa (4/29/2009)

---

I need a scalar valued function like

If i giving the values like 10.25 i need a output as 10.00

My logic is

...

Solution was posted here many times, and Jeff Moden even made an article out of his...

Bob Griffin (4/29/2009)

---

I'd also try using coalesce instead of isnull. I've seen some posts about performance being better with coalesce.

Select e_ina11,E_Create_Date,e_Org_FileName From Element

Where coalesce(e_Ina11,1) = 1

AND...

The idea is simple.

For each user you build a report string using one of "concatenation functions" posted on this forum.

It would be a...

Kaushik Majumder (4/29/2009)

---

Hi,

Facing some issues with the following query....

Select e_ina11,E_Create_Date,e_Org_FileName From Element

Where e_Ina11 Is Null

AND E_Create_Date > '2007-12-31'

And e_Org_FileName Like '%].xls%'

The reslutset,however, includes non null values for column...

Why you need #YTD at all?

I believe Jeff Moden was trying to teach you how to do cross tab queries...

is250sp (4/28/2009)

---

I have 3 tables. First table contains employee information called Employees. Second table contains the earning codes called Erncd. Third table has the actual earnings called...

I believe this is the method that doesn't suck so much.

:hehe:

Jeff Moden (4/27/2009)

---

As is usually...

Lowell,

Second LEFT JOIN leave a possibility for the query to return all Backup History records with different Backup_Size. As a result you'll have multiple records for the same DATABASE_NAME.

You need...

If one of the statements fails your procedure leave the transaction open.

Completing of procedure code does not complete transaction.

it should be like this:

if @ierror=0

begin

commit transaction

end

ELSE

begin

rollback transaction

end

Did you ever try it on 40+ mil tables?

Not to...

Set up a linked server to text file and load from the file like from remore table.

Or use OPENQUERY.

See BOL for details. Topic "Linked Servers".

Example from there:

--Create a linked server.

EXEC...

Why QUOTED_IDENTIFIER is OFF?

What we want to do for example is get a list of all HBA1c's and display them as a decimal value. But as in this example one is ABC...