Thanks Gail.

So, why does TaskManager display wrong info for sqlservr.exe? Is there a particular reason?

BTW, is there a reason why are you running SQLServer with SYSTEM user?

Corrections on my poor advice are welcome.

However, it seems to me that this thread is turning into arguing on each other's suggestions.

I'm not sure this will help the OP in...

GilaMonster (9/23/2011)

---

Can be, maybe, if the person designing the table understands the complexities. Usually however it's about the worst...

The evaluation edition expires after 180 days.

Use the express edition instead:

http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

Even better, buy developer edition. It's quite cheap (something like $100).

okbangas (9/23/2011)

---

Generally speaking, I'ld say this is not a good advice. I...

SQL Kiwi (9/23/2011)

---

It's a question of style. My personal preference is to start the transaction inside the TRY (option...

Read the article in the first link in my signature line.

To give a sensible answer we need:

1) Table script

2) Sample data

3) Expected results based on sample data

4) What you...

ashuthinks (9/23/2011)

---

hi

i have added dataset into my ssrs report SP but now..

problem is

only 'PreviousNAV' field is coming ...

because

my SP having select queries like this..

SELECT ISNULL(NAV,0) PreviousNAV...

Please stop crossposting!

You original question is here: http://www.sqlservercentral.com/Forums/FindPost1179871.aspx

If you don't get the answer you want probably it's because your question is unclear.

Try rephrasing or adding more detail.

asiaindian (9/23/2011)

---

Did you look up ISNUMERIC function. Please look up in BOL. As suggested by Gianluca, I would pass a valid value from the app, validating the value in app...

You can UNPIVOT and then PIVOT again:

DECLARE @sampleData TABLE (

dealer_codechar(5) PRIMARY KEY,

dealer_namevarchar(10),

region varchar(10),

month datetime

)

INSERT INTO @sampleData VALUES ('A1001','Asha','delhi','4/1/2011')

INSERT INTO @sampleData VALUES ('A1002','Boby','mumbai','5/1/2011')

INSERT INTO @sampleData VALUES ('A1003','Vijay','kolkata','6/1/2011')

INSERT INTO @sampleData VALUES ('A1004','Rathi','jodhpur','7/1/2011')

INSERT...

GilaMonster (9/23/2011)

---

Task manager is a terrible way to check SQL's memory. It's incorrect in many cases (yes, there is a reason, it's not a bug)

Performance monitor with the total server...

Thank you for the info, Gail.

How...

Which RDBMS is the Linked server?

I guess that looking at the task manager is not exactly what you want.

Do you want to do this programatically? From T-SQL or another language?