Phil,

I have done so, but have same results.

Jeff Moden (8/30/2012)

---

It's been several years since I've had to work with OPENQUERY but I believe the following will work...

select <stuff ...>

from OPENQUERY(Banner_Prod, 'SELECT a.Major

,a.FIRSTNAME AS NameFirst

,a.MIDDLENAME AS NameMiddle

,a.LASTNAME AS...

not a secrete 🙂

I have product related data in database. one of the ex.dev wrote query to fetch results in 3 with top1 as I mentioned. Now I have got...

yes, but I have to add some other conditions and they worked with your logic 🙂

I would thank you both for valuable suggestions

Thank you Sean Lange, it worked 🙂

Thank you Sean.

tried case

SELECT NAME ,

CASE WHEN id = 4

...

I got the answer

Beginning with SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10-6, of a second) and the amount of CPU...

I have completed the profiling and now have all the data in table 🙂

I am using following query to extract results. I have observed that for statements data is saying...

thank you very much SSCrazy. These queries are really great to have. Can I modify these queries to extract queries executed by specific user?

I want to use profiler too, as...

thank you. 🙂

this is what I have implemented

thank you SSCrazy

it worked 🙂

Lowell (10/15/2012)

---

it's fairly easy.

first, doa SELECT * FROM sys.traces; you'll probably see traceid = 1(the default trace) plus any other traces you have created (2,3,4 etc)

select the trace id...

not sure about your exact problem.

can't you use "AS" in your select statement ?

select column as Date from ...

thank you all.

problem resolved by adding Local to cursor declaration. I assume that by default cursor declaration is locl.

DECLARE Color CURSOR Local FOR

SELECT cc.colorid

FROM dbo.tblColor cc