Just replicated it!.

I am using SQLSERVER Management Studio for both the queries.

1. select * from dbo.mytable

VS

Expand the Instance --> Databases --> tables --> Right click the table and select "Edit...

No rowcount!.

I wrote the web app. It is straight select with some wherepart.

Is there some SQL server level caching or similar that is not visible to developers ?

I will...

There are only 2 SQLSERVERS that I can connect to and I verified the instance I was connecting.

I am not sure how many people write new classic ASPs these days. Portability is the key here. I can deploy this SP in several SQL instances, and give developers...

There is a PK and everything is RIGHT. Thanks for your rude free advise: Celko. Hope

somebody out there will find your books useful.

I know my job and *never* expect others...

The problem I have is:

descr

Amt

Cnt

are variables and can go upto 15 also. I do not have control on these fields as these are configurable by users.

sample data:

Create table view1(

id bigint

id2 int

iddesc char(25)

);

Create table table1(

id bigint,

id2 int,

amount money,

count int,

date date

);...

You are welcome.

I am trying to replace a cursor in a function that converts rows to cols also. Based on the data I am not expecting more than 6 IDs for a...

Thanks Jeff. I l am learning something new: tally tables. For now, I prefer the simple ASCII add solution suggested by Weasley: I will not have ABBC type...

The 4 values was just an example. The strings could be of varying length. I would not expect this to go in double digits.

I have not worked with tally tables....

Thanks - GSquared,

I get the result. I'll work with this. I need to parse out a few 100s of such XMLs and will this add overheads to the servers.We are...

Hi,

I just ran the SQL and do not get anything!