Hi,

In Microsoft SQL Server, transactions are explicit by definition. This implies that an individual SQL statement is not part of a logical...

Adi Cohn (5/28/2009)

Yes there is. If you have user that his/her...

Hi Adi,

The scan is good,

but is any difference while putting the %2% instead of '%,2%' or '%,2,%'

ARUN SAS

HI Ashok,

suppose your table (Tblgroup)column intUserId having the datatype of char or varchar

then use this like select intGroupId from tblGroups where intUserId= '%2%'

to get the Result of

intGroupId

1

3

ARUN SAS

Real things comes late but latest.

Fine!!!

ARUN SAS

Paul White (5/26/2009)

A country where the...

hi Lynn,

CAST(ABC AS DECIMAL(4,2)) AS 'VAT'is better,

but the orignal datatype is Decimal(38,20),

if the value like 99999.00000000, then again the Arithmetic overflow...

Hi,

Why from the parameter of the week,

because its need to another parameter of...

Hi,

Try this

select ('update '+Table_Name+char(13)+' SET COMPANY_code = '+''''+'New Value'+''''+' Go' ) col1 into #temp

from INFORMATION_SCHEMA.COLUMNS

where Column_name like 'COMPANY_code'--COMPANY_NO,COMPANY

--select * from #temp

declare @sql varchar(8000)

set @sql = ''

select @sql = @sql +...

ningaraju.n (5/22/2009)

If my serach text is like 'Mandir+Excel Soft'

then i want the UserId 2 and 7

If my serach text is like 'Mandir+Excel Soft + kumar'

i should get UserId 2

like...

Hi,

this is simple PivotTable statement

try this

create table #temp

(

nboothcode int,

[KANDRU KAMALA] int,

[DURU VIJAY KUMAR] int,

[DONTHIREDDY SRINIVASA KUMARI] int,

[MUNAGAPATI VENKATESWARA RAO] int,

[MUPPALLA NAGESWARARAO] int

)

insert into #temp

select 1,...

hi,

Also try this option,

create this as your own sp and kept it in shortcut key to execute

CREATE...

hi,

try this,

create table #temp

(

amount decimal(15,6)

)

insert into #temp

select 1245.658797

union

select 123597.599945

union

select 798754.589785

union

select 787561.124657

select substring((cast(amount as char)),0,(charindex('.',(cast(amount as char)))+3)) amount from #temp

amount

1245.65

123597.59

787561.12

798754.58

ARUN SAS

Hi,

try this

1)

select name, count(name)row,

(select count(name)from #temp)as total_row

from #temp

group by name

2)

select a.name, count(a.name)row,

b.total_row

from #temp as a,(select count(name)as total_row from #temp)as b

group by a.name,b.total_row

ARUN SAS

hi,

try this

select *,

(select name from syscolumns

where id in (select id from sysobjects

where name = View_name)) ALIAS_NAME

from information_schema.view_column_usage

where view_name = 'test_view'

ARUN SAS