You need to create a data set with the expression in the dataset designer. Then you use that dataset as the source for your Search Value parameter where id...

Check out the BOL entry for IsNumeric. "+", "-", ".", and currency symbols are all considered Numeric. Change your where clause to:

Where

Column NOT...

I think you are going to need to do custom code for this. This will work:

SELECT

CONVERT(CHAR(4), YEAR(GETDATE())) + '-' +

...

In my experience almost all applications like this experience performance problems. It's probably got problems...

I don't know of a way to do this, at least not how you are attempting. A work-around may be to only have 2 parameters, the Search By parameter...

Can you define how you determine which rows are rows 31-40? This will vary based on your order by.

This isn't totally related, but is this one of those applications designed to run on multiple database platforms?

K. Brian Kelley (1/23/2009)

---

Jack Corbett (1/23/2009)

---

K. Brian Kelley (1/23/2009)

---

And when you are coming through Named Pipes, it's dropping back to NTLM. Kerberos support for Named Pipes was introduced in SQL...

K. Brian Kelley (1/23/2009)

---

And when you are coming through Named Pipes, it's dropping back to NTLM. Kerberos support for Named Pipes was introduced in SQL Server 2008. It's not there...

The error is because you have Convert(Float(data)) which is missing a "," after float. Convert(Float, (Data)). It is in

this section of code:

Else Sum (CASE WHEN Transfertype = 'Termination'...

Please don't duplicate posts. Answers here

Check out this link: http://support.microsoft.com/kb/814398

Well, the first thing you need is Outlook installed on the server. Then you need to configure a mail profile on the server logged in as the SQL Service...

brainy (1/23/2009)

---

Hey .. I got an idea...

Try using

WAITFOR

{

DELAY 'time_to_pass'

| TIME 'time_to_execute'

| [ ( receive_statement ) | ( get_conversation_group_statement...

Are you using SQL Server Express edition or another edition of SQL Server?

If you are using a version other than express you can use the backup the command...