hi,

Use the stuff function to replace.....

if the occurence is the end of string only.........

SELECT STUFF(Column_Name, CHAINDEX('P',Column_Name), LEN(Column_Name), 'PT');

otherwise....

U should write some logic using SQL String functions ....

🙂

hi,

try to reduce the RDL in designing mode.....

Drag corner to insdie & set the width & height properties corectly....correctly

U can export in BIDS and test there itself.....

Reduce based on ur...

hi,

I think its not possible to do......

Try to do the following one...

For this U should add another column in TableC.

Key_IDa is foreign key and references to Table A PK.

Key_IDb is...

hi,

I think no such statement is availed....

The alternative approach expecting is.....

For Ur requirement u have to write a function which converts all special charectes to Ur required charecters.....

Functuion: which takes...

hi,

Write a select query with replace function for that particular column and remaining as it is....

hi,

Could you please give full Info.....

Take the data of TableA [Oracle] into excel....and import the data into SQL DB..

or

if the both tables have record ids.....then update the each column...

Padmaja.

Create a tabular function

which takes input VACHAR(1000)

Returns Table (id identity(1,1),FindNo int)

Write a code to insert the comma seperated string into the table

SELECT * FROM fn_gettblOrder('5,1,3,8,2')

id ...

hi,

Right click on the Database. Go to "Tasks".Select Import data option.

SQL Server Import Export wizrd screen will welcomes you.

1.Click Next

2.Choose Datasource to "Microsoft Excel" and specify path where it existed.

3.Choose...

the article will gives u more info...CTEs and Trees

http://www.sqlservercentral.com/articles/Common+Table+Expression+(CTE)/61510/

🙂

If u have backups then restore that dB.

one good link which solves this suspect mode is

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx

🙂

Cheers!

Sasidhar P

hi Vaibhav,

U are right...

I tried the following two Queries

SELECT COUNT(*) tbl_object

tbl_object

1

SELECT COUNT(*) dbo.tbl_object

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '.'.

SELECT COUNT(0) A2z

A2z

...

DBNAme UserName dbo dbREad dbWrite............

MDEL sa yes yes yes

TEST...

http://www.sqlservercentral.com/articles/Administration/listofdatabaseuserswithdatabaseroles/1545/

It helped me ......

http://www.sqlservercentral.com/articles/Administration/listofdatabaseuserswithdatabaseroles/1545/

it helped me..........

if U want to use if statement in the query go for case...

Case

when ( drverri.despmce = space

...