Grant,

I'm reading it as 600 million rows (627,966,462) from the Full Text Engine.

I'd also be interested in the execution plan from the Coalesce function query.

You might also get better...

Can you post the table DDL and some test data as recommended in the first link in my signature?

When you create your dataset, you select Command Type - Stored Procedure. This will get the parameters for you and use the correct ADO.NET command type with parameters.

Forgive my ignorance, but what is DSV?

If you are using the OLEDB Provider you need to replace the "@" with "?".

What is the user being used to connect using the VB app? Does the user have permissions to execute sp_SQLSMTPMail?

I typically recommend against sending email from a trigger, unless...

Read/Write permissions to what?

Does the person executing the procedure have permissions to manage security on the database (dbo, db_securityadmin)? If not you need to look at managing...

It sounds like the array is only being populated by the selected items, so if only 1 item is selected you only have 1 value in the array. Try...

I just wish I had a door that someone could close. I'd keep mine closed. You'd have to see our space, but we have a hall with 4...

Lynn Pettis (3/30/2009)

---

Jack Corbett (3/30/2009)

---

Lynn Pettis (3/30/2009)

---

Jan Van der Eecken (3/30/2009)

---

Geez, you are quick to pull out the rule book. Admitted, the pic is about the red card in the...

Lynn Pettis (3/30/2009)

---

Jan Van der Eecken (3/30/2009)

---

Geez, you are quick to pull out the rule book. Admitted, the pic is about the red card in the finals of a prof...

If you do a sp_helptext on sys.server_principals or sys.database_principals you can see that MS is only showing roles and default logins/users and the logged in user intentionally. I would...

I'll chime in, can you connect to the database server from another application like SSMS?

It looks like a similar issue with a resolution can be found here

I found the link...

I think you just want a LEFT OUTER JOIN. Something like this:

DECLARE @funds TABLE (fund VARCHAR(10), isopen BIT)

DECLARE @trans TABLE (fund VARCHAR(10), createDate DATETIME, ticketAmt DECIMAL(10, 2))

INSERT INTO @funds...

You can use an expression in the ToolTip property and if you set it to Nothing then you will not have a tooltip. Something like this:

IIF(Fields.ColumnName.Value = "A", "Show...