Rather I would suggest you to keep three different customer tables each for Residential, Commercial, and Educational types

with primary keys as

 ResCUtomerID  int identity(1,1) for Residential,

 ComCustomerID  int identity(1,1) for...

It will not compile at all as sp_executesql expects 'N' in Parameter

Please read earlier reply (extract from BOL)

Prefixing N is necessary in our problem

From BOL

Unicode string constants that appear in code executed on the server, such as in stored procedures and triggers, must be preceded by the...

what is the problem you are trying to ask?

ramses2nd, just for curiosity

how can you relate the customer , who is having different types

i.e, what happens If One  customer belongs to...

try this

SELECT

t.ticket_id,

t

.created_date

FROM ticket t

LEFT JOIN (

If you post your table def it will be helpful

try this query, it will give desired output for all possible inputs

here I used Sreejith's table def

Declare @dt_ProcessBeginTime datetime,@dt_ProcessEndTime datetime,

@dt_MinSlot Datetime,

@dt_MaxSlot Datetime

Set @dt_ProcessBeginTime ='1/1/2000 09:10:00'

Set @dt_ProcessEndTime ='1/1/2000 09:35:00'

select...

Jeff,

Just now I tried again with same query, I got it ..here in example anID should be of character type, if it is of integer type query is not compiling at all

Thanks 

Use the following query in a dynamic way

Declare

@Rflag char(1)

select

@Rflag='B'

Declare

sorry, not working

CharIndex will give you the starting position of the specified expression in a character string

In order by clause if you specify an integer value (returned by CharIndex funtion),...

If you are not specifying order by clause in your select statement data will not sorted in any order, it will fetch as it was inserted into the table

There is no...

John,

The easiest thing is save your result to a file, result will be same as user entered in free format text (including line feeds)

Char(13) is not a visible character

I assumed that both the tables are in linked server only.

ok try this.. this has to be run with the connection to the MOMTRX_Pull's  Database

update

openquery

I guess the syntax itself is wrong in your tries.. try this

update

openquery(LS01,'SELECT A.RECORD_PROCESSED FROM OPR..T_ERP_MOM_TRANS_OUTGOING A

INNER JOIN...