Use the standard port? 😉

Here is a recent Microsoft CSS blog about using non-standard ports, they don't recommend it: http://blogs.msdn.com/b/psssql/archive/2011/03/17/to-1433-or-not-to-1433-that-is-the-question.aspx

WasimAli (3/21/2011)

---

I appreciate your feedback.

1.) The Same query with the same user connection, works fine in SQL Query Analyzer.

2.) Also, to re-state again, the same query works fine from SSMS...

Since you are selecting on Table1 and getting an error...

I tested and it works with the sample table I created, but since you didn't provide DDL or an actual data sample I can't test with what you have.

For better,...

Interesting question, thanks, and a good reason you should always specify the data type for hardcoded items when using a Table Value Constructor or UNION since data type precedence comes...

Assuming that Jeffrey is correct and that the id field is a character field, and it only has numbers in it you could try this:

select max(cast(id as INTEGER)) from phys

You...

If everything you want to remove always ends with a comma you could use something like this:

SELECT

[Date],

LTRIM(SUBSTRING([Date], CHARINDEX(',', [Date]) + 1, DATALENGTH([Date]))) AS DateNoComma

FROM...

Did you notice that the division increased the scale leaving you with three trailing zeros?

If you look at the link in the explanation you will see that division uses a...

Marios Philippopoulos (3/19/2011)

---

Thank you, I tried that.

In the Disk Usage by Top Tables report I see a few tables named with application-specific names, such as "dbo.#CustomerData", whereas for the...

Did you figure this out?

If not here is a link that should get you going: http://www.oracle-base.com/articles/misc/UsingRefCursorsToReturnRecordsets.php

You gotta love Oracle... 😉

Lynn,

I think what you are looking for is the BEGIN ... EXCEPTION ... END; block in Oracle.

There is some good information and examples here: http://www.techonthenet.com/oracle/exceptions/when_others.php

And here is a link to...

The problem isn't your GROUP BY it is that you haven't referenced the MaximumLevels CTE in your UPDATE query.

Give this a try:

with CoursePrereqs (

CourseName,

...

Thanks for the question, it really does show why we need to pay close attention to the data types we use.

There are a couple ways to do what you are looking for, here is one:

UPDATE S

SET

Address1 = A.Address1,

Address2 = A.Address2

FROM Sales S

INNER JOIN Addresses...

If you are worried about having enough CPU power while keeping licensing costs down...