I've never heard of sp_SQLSMTPMail. Is it an add on you installed on SQL Server? What version of SQL Server are you using? If you are using...

How about:

IIf(Fields!Phone1.Value="", Fields!Phone2.Value.Substring(2), Fields!Phone1.Value.Substring(2))

The parameter passed to substring is a 0 based postion in the array to start at. Thus Substring(2) returns everything starting with the 3rd character....

Sounds like you do not have the Excel OLE DB Driver available on the active node.

Bob Hovious (2/19/2009)

---

Question: Do you want to ignore a row unless ALL columns have values?

If so, you are probably going to have to list all the columns. ...

Here are a couple of scripts in the SSC script library that either do what you want or will point you in the right direction:

http://www.sqlservercentral.com/scripts/64793/

http://www.sqlservercentral.com/scripts/Permissions/64309/

Scheduled reports work by creating a SQL Server Agent job on the Report Server. You can schedule a report so the job gets created, but never runs because the...

I don't think you do this. I could be wrong. I think you could hack it together by writing the value out to a table or file and...

You may want to check out this blog post, http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/02/19/sql-tip-keep-your-presentation-logic-in-your-presentation-layer.aspx about formatting using SQL Server.

Wait, I'm right here. I'm not...

it is web-based & each user doesn't have separate connections. they use a shared connection string but each user would be given a separate username (application specific & not sql...

Another reason for using Identity() in SQL Server is that it automatically handles set based inserts like:

Insert Into customer

Select

...

You should look up SQL Trace in BOL. There are also a set of videos about SQL Server Profiler at JumpStartTV (free registration required).

If you can be more specific...

I would typically include the updatedby and updateddate in the update statement, whether it is by ad-hoc sql from the application or in a stored procedure (my preferred and recommended...

Roy Ernest (2/19/2009)

---

He used to work in the white house? :crazy:

"I used to work at the White house in Washington DC, but I decide to change my career after a...

GSquared (2/19/2009)

---

Roy, at least with me, you don't have to worry about being martial-arted, or outrun. I'm 40 pounds overweight, have a bum knee and arthritis in my hips....