with pleasure

After a very long time eventhough

Thanks for giving credits to me

it seems if there is a circular dependency in your Database then this script is not working to avoid the circular dependency

use the following condition with the inner join of...

Thank you gail.

humbly accept all your advice?

Next time, i will try to do it in a better way.

Hi jeff;

Thanks, for the info, but switching my career is not possible, I think i know little bit of the clustered index and non...

seems there is no problem in query it is purely on management studio settings

change the variable type to xml, i think that will give you the entire result

simple because all the transaction table records have these words "HANDLING CHARGE "

with cte as(

SELECTa.* , b.*, Row_number() over(partition by a.Look_Search_Operator_Into order by b.Search_Operator desc ) as X...

this is my contribution

declare @string varchar(500) = 'Carborator Break Engine Oil';

with split as (

SELECT itemnumber, item, COUNT(*) OVER () AS cnt

from dbo.DelimitedSplit8K(@string,' ')

),Recursive_cte AS(

SELECT itemnumber, item FROM [split]

UNION ALL

SELECT...

sorry for the delay, quite busy

we are creating data driven dynamic reports, for that we need to store the field name and table names, when ever a user...

I am out of my system once I get I will explain the rest of the thing and check the result

may i know where you need help in your query?

Hi Every body,

After a long war, Eventually I manage a win, i think it will be a hack, no bother, might be a lower performance,

any how i get the answer

DECLARE...

thanks a lot i am waiting for it, take a deep sleep and have a good health we need you very much dear

Mainid is not directly related with Referenceid but it is used to group the referenceid, if i give the parameter values as 2 i need the following result set

11

12

13

21

23

33

32

43

44

51

53

94

99

910

912

...

Thank's jeff I got mad about this problem, I just want some hint from any one angle, that's why I posted like it, you are right it is a many...