dhananjay.nagarkar (7/25/2013)

---

Dear friends,

i have a task to write a business report that has 300 fields ( 200 from one table and 100 from another table) . Currently I'm creating a...

Eric M Russell (7/25/2013)

---

Sean Lange (7/25/2013)

---

Sounds like you guys have kind of painted yourselves into a corner. There is a way to do this but it is not exactly best...

armaandani (7/25/2013)

---

Hi,

i have table named PersonalData.In this table i have a column DateOfBirth.I want to get the person who is the youngest of all.

For this what condition i should put...

Sounds like you guys have kind of painted yourselves into a corner. There is a way to do this but it is not exactly best practice. Basically what you are...

Maybe this?

select NMDOS, case RowNum when 1 then ETOTALDEB else NULL end as ETOTALDEB, tpdesc, dataobra, NOME, OBRANO, nmdoc, FNO, etiliquido

from

(

SELECT distinct BO.NMDOS,bo.ETOTALDEB, bo.tpdesc ,bo.dataobra,BO.NOME ,BO.OBRANO,ft.nmdoc,FT.FNO,CASE

WHEN FT.NDOC<> 1

THEN 0

ELSE FT.ETTILIQ

END...

RedBirdOBX (7/25/2013)

---

Hey guys -

It's become my job to decipher dozens (prob close to 100) of SPs written by a dozen different developers. Of course nothing is documented and...

Check out Paul White's 2 part series...

The code that Luis posted will do exactly that. NULL <> a date.

Try the code he posted.

I have to admit that I really didn't look at the actual query you were running until ChrisM pointed it out to me. There seems to be a bit of...

erikd (7/25/2013)

---

That's interesting, Sean. I don't think about injection much since I'm the only person who uses most of the code I write, and none of it is really ending...

Hi and welcome to the forums. It is very unclear what you are trying to here. In order to help we will need a few things:

1. Sample DDL in the...

raghuldrag (7/25/2013)

---

now My requirement is:

================

1)when the same user_id is trying to insert date for already exist date means want to show error mesaage whe n i press the...

erikd (7/24/2013)

---

Also, when I run it like this, it works too. Now I'm very confused. I've run it on a whole mess of tables and received correct results.

USE [Utilities]

GO

SET...

There are a number of things that could be going on. The best way we can help is to look at the actual execution plan.

See this article for best practices...

SQL_Surfer (7/24/2013)

---

WITH CTE (col1, col2, col3) AS

(

SELECT '1' col1,'abc' col2, 'bbc' col3 UNION ALL

SELECT '2'col1,'nbc' col2, 'zhi' col3 UNION ALL

SELECT '3'col1, NULL col2, 'abc' col3 UNION ALL

SELECT '4'col1, 'gef' col2,...