More over I don't think u can use Xaction log backup from SQL Server and apply it on another SQL Server(Unless u are using Log Shipping). Xaction log restore will...

Try this:

Select UserID,FName,LName,

 isnull(Case  when FName is Null then LName

  when LName is Null then FName

  Else FName + ':' + LName End,'None')

from Test_Name

Pankaj,

Tell ur manager that if you want that files to be used by other process then you need to have it delimited.

If you really want it the way he wants....

Two options.

1.As the vendow to pull "Blank or Null data" when the columns does not have values that way ur file definition is same.

2.Load it into temp table that have...

Is this what u want:

declare @dt datetime

set @dt ='10/20/2006 12:00:00 AM'

select @dt, Convert(Char(10),@dt,101),Convert(Char(10),@dt,1)

Thanks

Sreejith

I want ur question in Plain English (No Not IN...)

what column are u checking in NOT IN Clause?

I don't think I understand your question. Are u trying to create unique number(indentity) on an existing table(that has non unique keys)? Please explain us what u have and what...

Jono,

Trigger is not the kind of solution that you should be looking. DTS or SQL Replication is what u want otherwise ur data might be lost (due to non availability...

Tell me what u wanted to do. There is syntax error.

substring(Col001,17,2)='DH'not in (@per) is incorrect. what are u trying to do.

Thanks

Sreejith

Try this:

select  DCC.DCC_ID,DCC.[Description],

 TYPECOUNT.LOGON_TYPE_COUNT,

 sum(case when QUERY.TYPE = 'JPJ' then 1 else 0 end) as JPJ_Count, 

 sum(case when QUERY.TYPE = 'JPN' then 1 else 0 end) as JPN_Count,

 sum(case when QUERY.TYPE = 'JIM' then...

Here is an example:

Create procedure ssp_findData

 @i_UserID int = 0,

 @i_DeptID int = 0

as

Begin

 set nocount on

 Declare @s_SQL varchar(512)

 select @s_SQL = 'select * from UserDept where 1 = 1' 

 If @i_UserID <> 0

 Begin

  select @s_SQL...

I've been a DBA for 6 years I don't have certification. The reason being I don't believe in Certification. I've seen tons of people who have MCSE,MCSD,MCDBA (all three) and...

Do u have index on Order_Status column? Looks like u need one.

when u say "I comment out all the IF statements but one it runs in 2 secs" what gets run....

Slightly modified version of Greg's post.

Create a view with the same logic as Greg's post, then u can use the view in any of your query.

Create view VW_Rate_Effectivity

as

 select rate,EffDate,CurrencyCode,

 /* Get...

why do u need to use trigger to call an exe?

what happens when exe fails.(your DB is not updated as trigger failed)

If your exe queries the same table that it...