Hi,

try this,

SELECT a.blah, b.de, case when isnull(b.blah,0)> 0 then 1 else 0 end /*CASE b.blah WHEN NULL THEN 0 ELSE 1 END*/ as blah,

FROM tableA a

LEFT OUTER JOIN tableB b

ON...

Hi,

Try this code

declare @abc table (

slno int,

No1 int

)

insert into @abc values(1,4)

insert into @abc values(2,2)

insert into @abc values(3,2)

select AVG(No1) from @abc

RESULT

2

select AVG(No2) from (select convert(float,No1)No2 from @abc) as X

RESULT

2.6666666666666665

ARUN SAS

Hi Pols,

Similar issue you post in the SQL Server 7,2000 » General » select to 2 resords for each record

Link : http://www.sqlservercentral.com/Forums/Topic699943-9-1.aspx

Same coding for this also, try that one…..

ARUN SAS

😀

Hi Pols,

Try this code

create table #ABC

(

id1 int,

count1 int

)

insert into #ABC values (1,10)

insert into #ABC values (1,20)

insert into #ABC values (1,30)

insert into #ABC values (1,40)

insert into #ABC values (2,10)

insert into #ABC...

Hi,

Please refer the article written by jeff - Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Link : http://www.sqlservercentral.com/articles/T-SQL/63681/

ARUN SAS

Hi,

One of the way

Declare @abc TABLE

(

SLNO int,

UTC Datetime,

CON_DATE as (dateadd(hh,-8,UTC))

)

insert into @abc(slno,UTC) values(1,Getdate())

select * from @abc

ARUN SAS

Hi,

For this table you maintain any audit trial ie maintains any audit table?

ARUN SAS

Hi,

Try this codes

declare @aFrom int set @aFrom = 30

declare @aRatio int set @aRatio = 20

declare @aCount int set @aCount = 50 -- 0 , 30, 31, 49, 50

declare...

Hi,

Also Try this simple codes

declare @sample table ( id int, Dept varchar(30))

insert into @sample

select 1,'10' union all

select 2,'20' union all

select 3,'30' union all

select 4,'40' union all

select 5,'50' union all

select 6,'60'

select...

Hi,

A CAL is not software,

it is a legal document granting a device

or user access to server software.

You can't add from program,

but thro reinstall the software with required CAL.

ARUN...

Hi Pedro,

You need to create the permanent VIEW Table?

Or

The data retrieved thro dynamical tables?

ARUN SAS

Hi,

CAL measns?

ARUN SAS

saravananr (4/14/2009)

---

Hi All,

I need to get the records from a table within a particular FROM and TO date. For example in a...

jchandramouli (4/14/2009)

---

In addition to fraggle's solution, in case if you need the latest date inserted with respect to name considering the dates could be random instead of descending then the...

hayzer (4/14/2009)

---

hayzer (4/14/2009)

---

try this code...

suppose you have the table 'tblNames' with a column 'name'

select left(name,charindex('-', name)-1)

from tblNames union all

select left(name,charindex('/', name)-1)

from tblNames

havent tried it... i'll try this code...