On 2000 I recommend using SCOPE_IDENTITY pretty much exclusively. Could someone else create a trigger in the DB without your knowledge? What happens if you leave and someone...

As Simon mentioned the parameter is passed as a comma-delimited list by default so I would just split the list in the stored procedure into a table and join on...

Glad you could do that. I'd recommend using SCOPE_IDENTITY() instead of @@Identity though. @@Identity returns the last Identity value created in the session so if there are any...

Yes there is an IsDate function as well.

Are you only querying the single table? What's the rest of the criteria? Without seeing the whole query it's hard to say what is causing the issue. ...

You are getting an implicit conversion from char to nchar in your IN clause. Try this:

AND dbo.BO_ProjectIDAllPrompt.ProjectFilter IN (N'2711',N'2634')

Which specifies that the constants are NCHAR.

Also...

You can do it 2 ways. The first way is 1 I'm sure you have considered:

(sum(EmpExp)/Count(emp)) + sum(MiscExp)

Or you can use the ReportItems collection like this:

ReportItems!TextBox1.Value +...

From the BOL entry on C2 Auditing:

If the audit directory fills up, the instance of SQL Server will be stopped. You can restart the instance of SQL Server if auditing...

You can concatenate like this:

Fields!FieldName.Value + ", " + Fields!FieldName2.Value

Yes.

Do you want to do it as an expression in the report itself or as a calculated column in the dataset?

How about this:

SELECT

*

FROM

TABLE

WHERE

LEN(column) - CHARINDEX('_', 'column') = 2

Or

SELECT

*

FROM

TABLE

WHERE

...

I don't think any of the Identity Functions work across linked servers. If I were doing this and had access to the 2000 server, I'd create a stored procedure...

GilaMonster (4/20/2009)

---

Jack Corbett (4/20/2009)

---

Another note for the non-Twitterer's is that there have been 358 sessions submitted to PASS so far, deadline is Friday at Midnight, for about 80-90 slots available....

Alvin Ramard (4/20/2009)

---

Steve,

Your comment in the Interview Questions thread about being interviewed by Gail reminded me of comments made in here earlier about interview sessions at the PASS conference.

Has...

Only for a short time I am sure.

Another note for the non-Twitterer's is that there...