avdhut.k (8/31/2012)

---

Hi,

Select Lnno From Temp_Check

Where det_trantype = 'Opbal'

Group By Lnno

Having ...

Shadab Shah (8/30/2012)

---

Hi,

The question which i am going to ask will prove that i how newbie i am.

Basically indexes increases the performance will searching which is nullified while inserting ....

To new assignment

raghuldrag (8/28/2012)

---

alter procedure Goals_history

(

@stuid nvarchar(22),

@startyear nvarchar(22),

@endyear nvarchar(22),

)

as

begin

select name,class,noofsubject,rank,test from @tab1

union

select name,class,subject,rank,test from @tab2

where rank is not null

and studentname=@stuid

and accodomicyear>=@startyear

and accodomicyear<=@endyear

end

OUTPUT:

class noofsubject ...

raghuldrag (8/27/2012)

---

table-1

employee details

...

rhythmk (8/26/2012)

---

Done 🙂

However I don't think we...

Sorry but it is difficult without the sample...

asranantha (8/26/2012)

---

hi friends i have a small doubt in sql plz solve

i have a table that table contains some nullt values and some spaces.

how to seperate what ever...

niha.736 (8/26/2012)

---

Hi Rajesh, can u please mail me the doc.

Hey Guys,

For sharing personal information(emailid) you can send private messages.

That would secure your mailbox 🙂

boon

stephen mehl (8/23/2012)

---

Hello --

Can CASE be used as follows?

CASE

WHEN expression is TRUE THEN

SQLstatement#1

ELSE

SQLstatement#2

END

Thanks for any help,

Larry...

Hi Mohan,

Apart from your specific requirement.

I was thinking about the scenario where first record itself is having NULL.

You can validate that also in your logic.

rVadim (8/23/2012)

---

1. Replication has completly different meaning in SQL Server from what you mean.

2. Your 2 examples are not equivalent: in 1st it seems you want to take first not...

sandeep rawat (8/23/2012)

---

Lynn Pettis (8/23/2012)

---

Curious, this...

Hi Sumit,

It is the best practice to...