with pleasure

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

After a very long time eventhough

Thanks for giving credits to me

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

Thank you gail.

humbly accept all your advice?

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

may i know where you need help in your query?

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]