Wouldn't that be like getting a contractor on-board? And I'm not sure...

Silverfox (8/17/2009)

---

Really, I havent see the value for money, as you describe, ever come to fruition for any organisation. and I would be intrigued to know the higher level you...

This behavior really threw me out in cold for a while! After going through this thread I broke the dynamic sql in multi-part and it worked fine. Yes, my dynamic...

Got it!! :w00t:

I had to modify my query to include the absolute path of the SQL Server database. Somehow the "Initial Catalog" thing in the connection string doesn't seem to...

Umm.. let me try to...

I assume you meant changing my OLEDB source type from Oracle to SQL Native Client. When I do that then the oracle query breaks with the following error:

[Alert values from...

It doesn't seem like you can use RAISERROR in a SELECT statement (though BOL doesn't say anything about it). Unless there is any constraint of doing it in one single...

I hope then that the code below is what you are looking for

create table #gi (statusCode varchar(6), statusDescription varchar(100), groupCode varchar(6))

create table #case (caseId int, statusCode varchar(6))

insert into #gi

select 'F',...

I think the way you want to export is explained here[/url].

Did you preview your...

I'm pretty new to this forum as...

Paul Morris (6/1/2009)

---

I am not a DBA but a hardware guy that got suckered into writing SSRS reports.... with that said... let me try to explain...

I am looking to...

I won't say this explains the entire situation to me, but lot better than the first post. 😉

Ok, here is what I understood, you have a "status code" table and...

Can you provide table layout to give an idea how it looks like?

Thanks for the explanation. I get it now.

Thank you for your patience and responses, John.

You guessed right that I expect to see G's first. And if I put Type 1 in the row_number() order by clause then...