David.Mizelle (4/18/2008)

---

I'm trying to convert the following query from Oracle to SQL Server.

SELECT COUNT(1) NO_OF_ROWS FROM ADOPTION_PERSON WHERE (

CONTAINS(ADOPTION_PERSON.NM_UPR_CURR_LST, ' fuzzy({A}, 68, 6, weight) ', 1)...

John Mitchell (4/18/2008)

---

The thing about using temp tables is that it will materialise the whole of the "view". With a CTE, it will only take out what you need.

Consider...

DAVNovak (4/18/2008)

---

I have never been a fan of dynamic SQL when I do not have to. There is a solution to this as a SP that does not need...

Let's keep the formulae here, so that others can double-check me....

What about Future Value, you ask?

[font="Courier New"]DECLARE @APR FLOAT

SET @APR=.074;

DECLARE @months INT  --how to break up the annual percentage

    SET @months=12;

DECLARE @Period...

Ricotta join in on this so that we can have the more the merrier. In spain - you...

Steve -

Is the drop down list showing the LAST 8 days? If not - is there a pattern in to what is shown? I'm just curious if...

Create a subproject...put the other reports in there. The project seems to hold the publishing folder.

Adrian - I'd Brie Tilton towards agreeing with you....

I don't know why you say that - I thought it was pretty gouda. Edam if you got'em , I'd say...:)

Jeff Moden (4/17/2008)

---

Keep in mind what I said in the conclusion of the article on triangular joins...

Not all Triangular Joins are bad. With some restraint and the right criteria, Triangular...

I don't, and like it or not, I...

escaleraroyal (4/17/2008)

---

Jeff Moden (4/16/2008)

---

escaleraroyal (4/16/2008)

---

update.

Vendor says the same applicationX runs fast in another company1 which has a higher volumne of data. He thinks it's our clustering server that is causing...

jmasson (4/17/2008)

---

When I use:

update order_header set shipname1 = N '??'

where orderno = '13153461'

I get the following error message:

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near...

hmm - interesting.

If you just add the nvarchar notation (e.g.

update order_header set shipname1 =N'??') Notice the N in front of the values.

then although the characters themselves come across as...

you have to set the seeding BEFORE you insert stuff into the table. Seeding only affect NEW identities being set up. If the table was empty when you...