Okay, I had a minor bug in the CountRows function. You either need to put in the dataset name or leave it like this CountRows().

I have a table and...

I have never tried to do what you are doing, but using any of the dataset fields in the expression will fail when there is no data returned. You...

Post the schema of all your tables involved and the trigger you have in place and exactly what you are modifying. Sounds like you have a unique constraint/index that...

It would be helpful if you posted the code, schema, and some sample data that combine to cause the issue. The only help you could get based on the...

Have you tried using Cast/Convert on the sql statement to force the query to return an INT? I don't know ORACLE but perhaps the Count function returns what in...

It sounds like you are getting an empty dataset returned. SSRS tables have a NoRows property that allows you to specify a message to display in place of the...

I wouldn't say "much". This happens to me all the time.

mbender (5/28/2008)

---

What I'm ultimately looking to do is if someone changes the AgreeId on ticket 177987 to 4126 I want to record in a separate table the following:

INSERT INTO TicketMasterHistory

(Ticket,...

Is there a special record combination you are looking for? Do you want 2 rows before and after or 1 row with before and after columns for specific columns?

You...

Great I am glad I could provide some helpful information

This solution uses a numbers or tally table, see this article http://www.sqlservercentral.com/articles/TSQL/62867/ to split the items and an update from this article, http://www.sqlservercentral.com/articles/Advanced+Querying/61716/ within a scalar function to get the...

I believe you could use a foreach loop container in SSIS to grab each Excel file and insert, as long as the "column" names match in each file.

Using the date datatype does not provide formatting like that. You can use convert(varchar(15),date,113) which I believe is the ddmmyyyy format. Check cast and convert in BOL.

I don't know of a way to this directly from SQL Server or SSRS unless you have some kind of add-in to your mail server that would allow you to...

Here are some links from the thread I mentioned earlier:

http://blogs.msdn.com/sqlprogrammability/archive/2007/04/30/will-64-bit-increase-the-performance-of-my-sql-server-application.aspx

http://support.microsoft.com/kb/918483

I saw another one on another thread on SSC, but I can't remember where.