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...

anush_tar (7/26/2012)

---

I'm importing like this http://www.sqlservercentral.com/articles/T-SQL/68927/%5B/quote%5D

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...

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...