wow!

Tally tables are doing a wonderful job.

Thanks Jeff Moden and Brandie Tarvin

-Regards,

Ami

Many Thanks,

Ami

Thanks

actually it saves lot of typing effort.

As I said in the first post. I have lot of columns, I gave example of such scenario as I can't give the...

thanks for the response. here is the code

CREATE TABLE #TMP (ID INT PRIMARY KEY IDENTITY (1,1), V1 VARCHAR(100))

CREATE TABLE #TMP1 (ID INT , D2 DATETIME)

INSERT INTO #TMP SELECT 'VALUE1'

INSERT INTO...

Thanks for the information.

I'm using sql server 2005. So I'm taking DATETIME data type. It further helps me to do some calculations on that column.

Regards

Ami

Hi all,

Got the remedy.

Either you can do the following

1. Locate the folder that contains the files for the problematic full-text catalog.

2. Run the ALTER...

Hi All,

First thanks for a quicker response.

the left outer join solves my purpose.

thanks a lot

Regards,

Ami

Hi,

Thanks for the inputs. both are working fine

thanks,

regards,

Ami

Elliott,

Thanks for an immediate reply. But I would like to know how best we can make use of ADO.NET schema row set enumerator

regards

ami

There are a number of alternatives, with examples and code, here:

http://consultingblogs.emc.com/christianwade/archive/2004/11/09/234.aspx

The link was highly useful.

Thanks for sharing,

Ami

when i query for ID 1

in the first level it has got 2 and 3

then in the next level 4 and 5 - are children of 2 and 3

then...

Hi All,

Thanks for the great support.

Now, how do I set memory for sql server and OS?

the max option in sql says 2147483647 (in MBs)

but the physical memory in the server...

ooch!

sorry ignore the previous message.

i found out in the attached .txt file

thanks,

regards

ami

Hi Sanket Ahir,

Can you give me a hint on counters should be attached on perfmon?

Your message says

2ndly run the perfmon in peak hrs with the foll counters(attached, Change the...

Wow!!

fabulous pieces of information all at one place.

i thank everyone individually who is participating in this thread.

I'm on the process. will send you the perfmon o/p soon.

Muthu: I already...