Hi Lynn & Jeff,

I made a mistake there is no traingular join. I don't quite remember why i mentioned it, I guess I was thinking about not...

Hi,

If ':Entity' is common among all the values then

select left(columnname,len(substring(columnname,1,charindex(':',extra)-1))) from tablename

please try this

create table #chk(colm varchar(30))

insert into #chk

select 'pp_uniline_usd:Entity' union all

select 'dfsdafsdfsdaf:Entity' union all

select...

Hi,

Is this what you need?

create table #BuildingJob(Bldg int,Job varchar(50))

insert into #BuildingJob

select 100, 'Plumber' UNION ALL

select 202, 'Plumber' UNION ALL

select 301, 'Plumber' UNION ALL

select 521, 'Security' UNION ALL

select 523, 'Security'...

Hi there,

I have tried to solve your problem using row_number() and pivot function.

create table #tblItems(ItemName char(1),Date datetime)

insert into #tblItems

select 'a','2008-01-01 00:00:00.000' UNION ALL

select 'a','2008-01-01 00:00:00.000' UNION ALL

select 'b','2008-01-01...

Hi,

I think I got it right by changing the query.

select IssueNoteID,StockCategoryID,QtyIssued,Left(GRNNo,len(GRNNo)-1)

from (

Select IssueNoteID,StockCategoryID,Sum(IssuedItemQty) as QtyIssued,( SELECT G.GRNNo + ','

...

Hi Adi,

Thanks for correction I wasn't sure about clustered index on primary keys though.

May be you can point what anomalies could arise if however...

hi there,

I would love to know why do you need two primary keys in your table.

Although i think in relational database a primary key...

Hi there,

I think you should try this and tell me if I have understood your problem right. I would appreciate a response

create table #tblItem( dt datetime, ItemID int)

insert into...

Hi there,

I have tried to write a query for your problem with this sample table, tblPurchaseOrder - PurchaseOrderDate & GrandTotal

here it is-

select weekno,newdate,sum(grandtotal) as grandtotal...

Hi,

you might try this-

select ...(your query goes here)

except

select top 1 ..(your query goes here)

Hi Shantaram,

The given code logic i had posted earlier would work well for characters strings as well, if it is written in comma separated list.

As per the given code:

"

declare...

Hi Shantaram,

The given code logic i had posted earlier would work well for characters strings as well, if it is written in comma separated list.

As per the given code:

"

declare...

Hi shantaram,

You can use Tally table method as described in "Numbers or Tally Table"

article by Jeff Gordan on this site.There might also be other solutions by using loop.But for starters...

Hi there,

you can use replace function which has following syntax

-: replace(@stringvar,charactertoreplace,newcharacter)

for e.g.

DECLARE @HashText nvarchar(10)

set @HashText= '''1,2,3,4'''

declare @grate nvarchar(10)

set @grate=replace(@HashText,'''','')

select @grate

Hi,

you can try this

select EMP_CODE,DATE_OF_BIRTH ,DATEDIFF(DD,DATE_OF_BIRTH,getdate())/365 as years,(DATEDIFF(DD,DATE_OF_BIRTH,getdate())%365)/30 as months,

DATEDIFF(DD,DATE_OF_BIRTH,getdate())%365%30 as days

from EMP_MST where accountid=4

Hitendra