kk1173 (3/5/2013)

---

Yes, there is a stored procedure that build dynamic sql. This query above is just a PRINT of the sql that gets executed.

If you look at the query, there...

meadow0 (3/5/2013)

---

Hi Sean,

The query itself works fine, I'm having an issue converting this into a temp table. I'm not even quite sure how temp tables work in theory, but I'm...

I assume these queries must be being generated "on the fly".

In addition the scalar function you have year(adm_dt) which is also going to render that nonSARGable.

It is impossible to offer...

What is the issue you are having? The query you posted looks like it should work fine, assuming the base table exists.

Hi and welcome to the forums. The best chance you have of people helping is if you first post ddl and sample data in a consumable format. Most people won't...

This is commonly referred to as "Gaps and Islands". Do a site search on SSC and you will find lots of information about how to go about this type of...

That's funny. I am on the West side of the pond and I avoid...

SARGable means Search Argument-able. http://en.wikipedia.org/wiki/Sargable

That is why he said...

gary.p.heath (3/5/2013)

---

I have a program of my own, for my own use, written in Excel VBA that I want to rewrite in VB2010 Express using SQLCE.

It currently displays a Form...

From what you are describing the best approach would be to get rid of the cursor entirely. There are nowhere near enough details in your post to offer much detailed...

ajnubee (3/5/2013)

---

I'm trying to alter a column in a table that corresponds to UDDT, this column has a primary key and it reference to foriegn key in other tables. What...

iglinka (3/5/2013)

---

Dear geniuses at Microsoft: A NULL value does not equal the string "NULL" !!!!

Those are two completely different things. Making users to a find/replace post-paste is ridiculous. ...

Looks like Chris beat me this time. 😀

It was hard to see that the tables were different because the formatting was non-existent and the tables all have crazy long names...

You could do this in a single update statement instead of 3.

UPDATE dbo.DatasiteConfigBMPANConfiguration

SET EnergisationStatus = case when c.DataSiteConfigATableName = 'DataSiteConfigAEnergisationStatus' then b.EnergisationStatus else DatasiteConfigBMPANConfiguration.EnergisationStatus end

, MeasurementClassRef = case when c.DataSiteConfigATableName...

You might want to take a look at this series of articles about SSIS.

http://www.sqlservercentral.com/stairway/72494/%5B/url%5D