I think it does it always, otherwise "running total update" method wouldn't work.

Can you specify what your expected results should look like? Do you want to calculate how many hours employee did work each day or what?

DDL with table setup and some...

cengland0 (8/1/2011)

---

Eugene Elutin (8/1/2011)

---

Can someone guess without executing what the following SQL will return on Canada like server setup (I have the UK one) 😀

DECLARE @var varchar(max);

SET @var =...

mahalaxmi.k62 (8/1/2011)

---

Hi,

In my query I have to compare two fields, one uniqueidentifier and the other nvarchar.

Uniqueidentifier Field value is :

the query in Where clause is:

wpmp.grew_workproductmoduleprofilesid in

(select grew_includemodules from...

Can someone guess without executing what the following SQL will return on Canada like server setup (I have the UK one) 😀

DECLARE @var varchar(max);

SET @var = 'Hello World';

SELECT...

The query looks like the reporting one...

Map the drive or use full path :

\\machinename\c$ ...

But, why are you using SQL for this? PowerShell or old dos-batch are designed exactly fo the purpose you have.

C.K.Shaiju (7/29/2011)

---

Hi All,

...

There is a procedure which is returning 2 separate record sets (Refer 2nd Part).

I need to get both the record sets from the SP and make to...

If you determined to use LEN function and want it to return 3 in your case you can do the following:

select len('1 ' + 'a') - 1

:w00t::w00t::w00t:

Ninja's_RGR'us (7/30/2011)

---

Attopeu (7/29/2011)

---

I can confirm there is no parameter sniffings because I do not change paramters when calling the proc but I call proc with same parameters multiple times. Also,...

If you don't have a value for this new column in your existing source file, you can use some default value for that column.

If you don't want to change...

Would help if you provide DDL and data setup scripts...

Please follow the link in my signature where you will find details.

Otherwise, you will need to wait for someone who has...

Shamshad Ali (7/28/2011)

---

yes, its working now. Thanks

1- What are the pros & cons of this change?

2- Should I remove the stopList which is StopWith as mentioned above? or...

You shouldn't have this word in the list! It works other way arround!

Try

ALTER FULLTEXT INDEX ON table_name SET STOPLIST OFF

then rebuild the index.

Why not create...