Do you have any groups in the Report? What is the data type of the column?

Check out this article[/url] and the follow-up[/url] on Pivoting. I believe the first article will address your situation.

Unfortunately because the way that SQL Server tracks dependencies sp_depends and the sysdepends table are not always accurate. Mainly because of situations like you describe, and also because SQL...

This is possibly not the best solution, but it will work:

1. Get the necessary information (Name, email address) of the people who have birthday that day.

2. Loop through...

You have a couple of options:

1. Use a staging table in SQL Server and after loading the staging use T-SQL to do an Update Where Exists and an Insert...

Jaime,

As John said, triggers in SQL Server fire once per batch, so if your batch updates 1 row or 1 million rows the trigger fires only once. Try reading...

In SQL Server you need to explicitly insert new rows. So in your case I'd do it like this:

UPDATE Pastforecast

SET PastForecast.Noun = pastforecast_Append1.noun,

PastForecast.dDate = pastforecast_append1.fcstdate,

PastForecast.Fcst =...

Jacob Sebastian wrote an excellent series on XML for SSC and later articles discuss generating an RSS Feed. I would start with his XML Workshop

Are there any errors in the SQL Error Log? Any other errors in the Windows event log right around this error?

Bruce W Cassidy (4/27/2009)

---

Jack Corbett (4/27/2009)

---

It depends on what the stored procedure is doing. In instances like this I have read the vendor code and if possible, write my own...

DC (4/27/2009)

---

I will say, one Cursor I haven't quite figured out how to eliminate, is when a vendor requires that something be done via a Stored Proc, and you want...

Thanks Lynn. That at least explains why the code is mixed.

twdavis,

Okay, I'm trying to understand your issue. I'm not sure what you are trying to gain from...

You can' get a seek without any criteria (Where clause). It has nothing to seek on, it has to scan each row.

If I understand you correctly, which I'm not sure I do, I think this query will work:

SELECT DISTINCT

A.BUSINESS_UNIT,

A.LOAD_ID,

A.TMS_EXT_REF_ID,

...

Peter,

Try this:

UPDATE s

SET s.ProdTableSuffix = ISNULL((SELECT

...