Glad you...

SQL Pizza (4/19/2013)

---

Oh man...if it wouldn't take me so long to obfuscate it. It's a normal query using cte to gather some values of 3 joined tables and the results...

a_ud (4/19/2013)

---

Hi Sean,

In Access the primary key is VolunteerID, just as in SQL-S. It's just a table linked from SQL-S into Access.

The situation is:

-I can delete records directly in SQL-S.

-I...

That is a might big topic. I would not rely too heavily on DTA or the missing indexes views. In fact, I would probably not even look at them. The...

SQL Pizza (4/19/2013)

---

At one of my servers i got the funny problem, that sometimes one of my queries take 300 ms and at some times 8000 ms allthough the server...

What column is defined as the primary key in Access? It is possible that you have setup the linked table using a different column than the primary key.

I don't think you want or need a pivot for this. However to be able to answer your question you first need to help us understand the actual issue. We...

Even though that is the best approach for this situation you should still look at replacing your split function with the one I pointed you too. Post back if you...

kapil_kk (4/19/2013)

---

kapil_kk (4/19/2013)

---

Sean Lange (4/19/2013)

---

kapil_kk (4/19/2013)

---

Sean Lange (4/19/2013)

---

You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think...

a20213 (4/19/2013)

---

Yes, the example is very simplified, what i want to do is to find results that match all words of the search.

If i have the text "i have lunched...

a20213 (4/19/2013)

---

this is the Split function

FUNCTION [dbo].[Split](@String nvarchar(4000), @Delimiter char(1)) returns @Results TABLE (Items nvarchar(4000))

as

begin

declare @index int

declare @slice nvarchar(4000)

select @index = 1

if @String is null return

while @index != 0

begin

select @index...

You are welcome, glad that worked for you. Make sure you understand how that thing works.

kapil_kk (4/19/2013)

---

Sean Lange (4/19/2013)

---

kapil_kk (4/19/2013)

---

Sean Lange (4/19/2013)

---

You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you...

spam reported

a20213 (4/19/2013)

---

hello, i am trying to make a procedure that returns values if and only the query matches all words .. EX:

declare @Names TABLE

(

name varchar(100)

)

DECLARE @Searchs TABLE

(

...