right, but if you try SELECT convert(decimal(3,1),'333.14')

you get a conversion error;

that's what i'm thinking is the issue; other daata than the examples you posted are outside of the data...

i don't think that's correct;

you should be able to add just...

Minnu this looks a lot like homework, and we hate to do folks work on their behalf, because they don't learn the concepts they need later;

Oracle triggers are different than...

there must be more to the story;

this works without an issue at all:

With MyCTE (val)

AS

(

SELECT '.7' UNION ALL

SELECT '2' UNION ALL

SELECT '1.3'

)

SELECT *,convert(decimal(3,1),val) FROM MyCTE

could...

i have some old examples in my snippets, but this just goes back to the same comments all other posters have made:

bad idea. the posters so far on here all...

ok you are doing a server side trace, so you are good to go;

when i read commandline, i had assumed a call to profiler.exe with some parameters to a...

abitguru (3/25/2013)

---

Thanks Lynn!!!

Several post later I explain what I'm try to do. 😛

I understand what you say about bottleneck, but I have no option (in my knowleage :-P). Because...

you can use some index stats to find those kinds of totals since the last time the service was stopped and started;

it's not kept aywhere else unless you start capturing...

timotech (3/25/2013)

---

Hi All,

Please i need an answer to this question. I have two servers, one locally and one hosted, i normally upload data to the online one using data export...

other possibility?

SELECT T2.KWMENG,

T1.NETWR,

T1.NTGEW,

T1.MATNR,

...

this is only a guess, because you did not specify enough details. the desired results did not show where the values might have come from, and since BOTH queries report...

I do things the same as McSQL, but one more thing i add is a check against a minimum date that is logical for the data on hand ; for...

winmansoft (3/24/2013)

---

Hi Lowell

Thank you for replying. Your method of giving permissions to tables works fine.But if in server roles if i set sysadmin(I did it in SSMS) for that user...

are you familiar with the CASE statement yet? it's what you need to add to your query to do what you are asking.

Other suggestions: don't use the Old syntax Table1,Table2

1....

The big issue with this kind of search, is that it must involve a TABLE SCAN of every table in the database.

If you have any tables with millions of rows,...