I do not, but if you've set up your Progress DB as a linked server, you should not need to use OPENQUERY. Instead, use the linked server reference to...

Right on Chris. I'll give my vote for the first option as well. We have a SP here that relies heavily on using a table valued function (along...

I'm a bit skeptical that you'll find a way to read the "meta" responses as QA or SSMS does via SSIS. This type of stuff is usually best represented...

1. Create the following in SSIS:

a. User::FileName of type string

b. ForEach Loop Container

c. Any task you need done...

Keep in mind also that the buffer cache hit rate is cummulative from the last restart of the SQL service. PLE consistantly less than 300 is a sign of...

You're looking for an upsert. Here's a good thread on the topic. I'm in favor of the UPDATE....if @@rowcount = 0 INSERT method.

http://www.sqlservercentral.com/Forums/Topic638136-65-1.aspx

Lynn Pettis (1/16/2009)

---

I'd still use the datetime data type in my date dimension in my data warehouse. I'd just be sure the time portion was 00:00:00.000. If using...

True. Looking back at the static dates table in this example, I see that this would be the case. What we do (for our DW) is use the...

Jeffrey Williams (1/16/2009)

---

We need to see the execution plan to verify, but here are a couple of things:

1) cDate in StaticDates should be stored as a datetime instead of char(8).

2)...

DECLARE @SomeDate datetime,

@Today datetime

SELECT @Today = GETDATE(),

@SomeDate = DATEADD(dd,-30,@Today)

--example with AsofDate 30 days ago

IF MONTH(@SomeDate) =...

You posted this in the SSIS forum, are you trying to do this in SSIS? If so, is this in a ExecuteSQL task or where have you done this?...

COALESCE() works as well.

Why the CROSS JOIN on your dates table? How many rows are in each of the tables?

OK, now try to write this in T-SQL and post your first stab. We'll take it from there and help you out. Hint...a calendar or dates table would...

Funny. I didn't see Eric's post for the same refresh reason. I did see Michael's but I just wanted to second the Conditional Split transform.