Thanks Dave,

But when i remove select and execute that statement it is giving error

Syntax error converting the varchar value 'max(dat_Date) from tbl_Transaction where txt_statecode=' to a column of data...

sorry i posted in different area

Hi Chris,

i am really sorry i did not get your point, But one thing i would like to tell you is i am not an expert in...

Thanks Jack,

I have attached my table and structure details in as txt file. please find it.

As you told i have created tables structure, since i have 5 to 6...

Thanks for the reply,

i have limited knowledge in sql server,i can write quires , simple stored procedure and views, not much experience in sql. Unfortunately here no one...

Thanks jeff..

mean while i will also try my side, as the website performance is decreasing i need to tune my sql queries. please help me in this.

Thanks & Regards

Chandrashekar

Hi Jeff,

ALTER FUNCTION [dbo].[fnSplit](

@InputString varchar(8000)

,@Delimiter varchar(10)

)

RETURNS @TempTable table(

ID int identity(1,1)

,[VALUES] varchar(8000)

)

AS

BEGIN

...

Thanks jefff,

This article is very help full to me and thought me how to handle the performance during situation where we need to loop through each record, which is...

Thanks vikas it works for me .. thank you very much

sql server 2000 in my local but in server 2005

same codes which you sent to me, like creating function, creating table, inserting value into table and selecting from product table

SELECT * FROM products

WHERE catid in (select [values] from...

Thank you Vikas,

When i execute your function i got this error,May i know why this error i am getting

Server: Msg 155, Level 15, State 1, Line 15

'catid' is not a...

Thank u nabha,

no it will not work ,because

Create table #t(t varchar(10))

INSERT INTO #t VALUES ('1,2,3')

INSERT INTO #t VALUES ('3,4,5')

INSERT INTO #t VALUES ('11,4,5')

Select * from #t

Where charindex('1', t) >...

Thanks for the reply,

Even i tried with that query it is returning null records,because there is no single value like 1 in catid field, it is a combination of values...

Thanks for the reply,

When i run that procedure, i am getting error like below

Server: Msg 232, Level 16, State 3, Procedure DummyReport, Line 26

Arithmetic overflow error for type int,...