Yes I want to count each item in each order and assign serial number to each item.

Create table Script is as under:

Create table OrdersDetails(OrderNo varchar(30),ItemNo Varchar(20),ItemName Varchar(50))

insert script is as under:

Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('12231','1','sdfasfasd')

Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('12231','2','sdfasfasdas2')

Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('12231','1','sdfasfasd')

Insert into OrdersDetails (OrderNo,ItemNo,ItemName)...

The enterd data i.e. posted is in Hindi language i.e. local language in India.

I got the solution

Use Replicate function

SELECT '200000'

SELECT REPLICATE('0',7)+'200000'

Because it effects the execution of other applications

this is working for Amita and Ankita but not working for Amita and Anita

i have checked in my System and server hindi font support has been install. Can you suggest me some thing else for phonetic search. How can I make search on...

Write function as

CREATE FUNCTION InitCap (

@string varchar(255)

)

RETURNS varchar(255) AS

BEGIN

RETURN upper(left(@string, 1)) + right(@string, len(@string) - 1)

END

and then write query as

SELECT

InitCap(Left(Status, CHARINDEX('.', user_name,...

hello

This query is work's for me but only the case where number of result set in both select statement are same but in my case issue is that number...

Hi,

Thank you for your help.. and I am littele bit Close to result.

I needed all records from left table

so my query is like:

SELECT

BI.*,

S.uid,

S.eid,

S.name_local,S.addr_careof_local

FROM

bilaspur_ssp..bilaspurssp BI

left JOIN

EIDMAP S

ON

BI.ApplicantName like N'%'+S.name_local+'%'

AND

S.addr_careof_local like N'%'+rtrim(ltrim(isnull(BI.HusbandsName,'')+ISNULL(BI.FathersName,'')))+'%'

and...

Thanx to every on Problem has been resolve by database file srinking.

will you please explain it

Try this

Select convert(varchar(20),Column1)+' '+ Column2 [ColumnName]

I don't have access of customer's pc I have to hand over CD of the software to the client.

I got Solution

Select

Case when datename (dw, getdate())='Monday' then Monday else

case when datename (dw, getdate())='Tuesday' then Tuesday else

case when datename (dw, getdate())='Wednesday' then Wednesday else

case when...