Hi,

Try this,

creat the function like this

CREATE FUNCTION TR_FA (@mr_RelationshipIdentifier varchar(10),@ReferrerIdentifier varchar(10))

RETURNS varchar(10)

begin

if @mr_RelationshipIdentifier not in (

select cc.CardIdentifier

from CardCollection cc,

EntityRelationship er,

EntityRelationship er2

where cc.CardIdentifier = er.RelationshipIdentifier

and er.Relationship...

Hi,

try this

step 01)

/*this statement ensures that daily records backup in the internal_table*/

insert into internal_table

select * from Main_table

where date = DATEADD(day,DATEDIFF(day, 0, GETDATE()),0)

step 02)

/*this statement ensures only current date record in...

Hi,

try this trigger

CREATE TRIGGER Main_TABLE_TRG

ON MAIN_TABLE

FOR INSERT

AS

BEGIN

declare

@date datetime,

@proj varchar(100)

select @date1 = date,@proj = project

FROM INSERTED

If not exists (select 1 from second_table

where proj = @proj

and getdate()/*or @date1*/ between valid_from...

hi,

try this

create table #temp

(

week1 decimal(16,8),

week2 decimal(16,8),

week3 decimal(16,8),

gross decimal(38,30)

)

insert into #temp

select -9.12000000,-11.03000000,5.61690000,0

declare @a1 decimal(16,8),@a2 decimal(16,8),@a3 decimal(16,8)

select @a1 = (1.0+(week1/100.000)),

@a2 = (1.0+(week2/100.000)),

@a3 = (1.0+(week3/100.000)) from #temp

update #temp

set gross = ((@a1 * @a2...

Hi,

In your target excel, save the first row in BOLD,

And then run the bcp command. This is the only way.

Also see

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

ARUN SAS

Hi,

Your condition (ie the certain date to upload the project) with in the table column or in the separate table or thro parameters.

ARUN SAS

hi,

also try this

create table #temp

(

slno int identity(1,1),

name1 varchar(100)

)

declare @abc varchar(1000)/*Alwayes should be in max value*/

select @abc = 'a.ID, a.Name, a.Type'

select @abc = 'select ''' + replace (@ABC,',',''' union...

Hi,

use the DBCC DBREINDEX

ARUN SAS

Hi,

declare @abc table

(

name1 varchar(10)

)

insert into @abc values ('GOOD')

--for lower

select lower(name1) from @abc

RESULT

good

--for UPPER

select upper(name1) from @abc

RESULT

GOOD

--for BOLD

How we make it?

ARUN SAS

Hi,

fine

like upper(),lower()

there is any to show in BOLD

ARUN SAS

viswa (5/4/2009)

---

Thanks for reply ...

I am not asking the books.. I need some basic ideas

Why we are going this performance and when we need this performance tools...

When i getting this...

Hi,

try this statments

1) EXEC xp_cmdshell 'bcp "SELECT * FROM sysfiles" queryout "D:\FE\XP_CMD.CSV" -T -c -t,'

2) declare @sql varchar(100),

@SQL1 varchar(1000)

select @sql = 'bcp "SELECT * FROM sysfiles" queryout "D:\FE\XP_CMD.CSV" -T -c...

Hi,

try this

use DB

GO

IF (OBJECTPROPERTY (object_id('/*Trigger name*/'),'ExecIsTriggerDisabled')...

Hi Gail,

In 2000, how can we handle?

Doing this is better way,

Declare @abc TABLE

(

Id int,

groupid int,

days_remaining int

)

insert into @abc values (1,89,11)

insert into @abc values (2,96,6)

insert into @abc values (3,89,11)

insert into @abc...

Hi Mahesh,

Show your select statement.

ARUN SAS