anthony.green (7/26/2012)

---

Yes indeed I am Andy.

Going to Shell Island from Sat to Tues, as my birthday get away. Should of done it last weekend but couldnt get the time...

marek_polko (7/26/2012)

---

Sorry for the confusion guys. The view had a join on the Request_ID field to an another table where this field was a varchar type. I did not convert...

Ok. Please post the sample data.

However having the field type nvarchar is not enough for unicode characters.

You must precede all unicode string with capital N.

e.g.

DECLARE...

anthony.green (7/26/2012)

---

Yeah it is a pain that, but mm is minutes, MM is month.

So if we take the a usual standard date format in SQL it would look like...

marek_polko (7/26/2012)

---

So I have this table where I have a bigint column being the primary key with autoincrement on. I also have a view which has all the columns from...

How are you importing the data...

Daniel Bowlin (7/25/2012)

---

L' Eomot Inversé (7/24/2012)

---

I though that was in laymans terms - after all, I was a mathematician, not...

Correct Lynn,have provided the wrong input.:unsure:

The requirement is still not finalized and will post that if have any doubt.

However thanks all.

PeterR-1037872 (7/22/2012)

---

I am populating a temp table with data drawn from a text defined field in a data table.

I can get the first 8000 characters using : set tm.cntct_notes =...

weird

An illusion

Good to know 🙂

deepzzzz (7/17/2012)

---

The given example is working fine. But using contains in full text its not giving me the right answer

I have changed the query as below.

SELECT * FROM table_name WHERE...

deepzzzz (7/17/2012)

---

Just suppose I have table columns like this

1 Application

2 Application's

3 Foreign Application

4 Application's effect

So, if I am running query SELECT * FROM table_name WHERE CONTAINS(*, ' "Application''s" ')

I am...

ravisamigo (7/17/2012)

---

Thanks for your prompt reply.

Both jobs are running in the same db server.

JOB 1 - > DB Backups are locating in L:\ --> it's connected from different storage server...