With that many rows now it will take time, but setting up XML indexes can make a HUGE difference. Without seeing how your XML is being stored I can't really...

syedshah (7/28/2013)

---

Hi,

I have created a trigger to audit changes to table rows from my web application. My web application is using a single db user to do updates to the...

dhananjay.nagarkar (7/27/2013)

---

Dear friends ,

Being new to sql, needed help on a urgent stuff-

The requirement is for field called "Final Approver"-

I nee to Show name of last approver in...

engstevo (7/28/2013)

---

can some give me hint i am trying to get a statement that will perform a daily sum aggregation on the field cost. It must only use costs...

The fatal flaw in your plan is the Pending Requistions table itself. Having the columns setup as you do now makes it not much more than an Excel-style flat file....

dubem1-878067 (7/26/2013)

---

I will try to explain the best I can the situation I am facing

I have a table with 12 'bit columns' each of them reprensent a potential specific...

sql server developer (7/26/2013)

---

Thanks for your help! one more question related to CONTAINS. If I search for lobby is it possible to make it search for lobbies also, which is...

sql server developer (7/26/2013)

---

I'm using CONTAINS to search for a string or word. If I search for Hobby is it possible to make it search for Hobbies also, which is...

I like it! I wonder if calculating the min and max values and passing them in as variables would adversely effect performance? That would (or could} keep the tally ...

Thanks for the feedback!

I haven't had a chance to try your version yet, but I'll run it through my test script when I get time and will post my results....

Ralf (7/25/2013)

---

Hi,

in a SELECT, I would like to have a function which returns the minimum of dynamic list of values, like this:

select GetMin(4,3) => returns 3

select GetMin(4,3,1)...

Perhaps this procedure will help.

Parse XML to Table[/url].

If not a direct help, the underlying methods may be useful in some other way.

You should be able to use your...

;WITH SampleData (ID,Fruit)

AS

(

SELECT 1,'Apple' UNION ALL

SELECT 2,'Orange' UNION ALL

SELECT 3,'Pear' UNION ALL

...

sqlfriends (7/24/2013)

---

I would like use case statement in select .for example, if rate =100, then 1, if it is null, then 1, and if it is <>100, it is 0,

how...

The parsing procedure I generally use (Parse XML to Table[/url]) does NOT preserve the spaces, so I made a slightly modified version that gives you the choice. I really don't...