Not exactly sure what you are trying to do here but I will take a stab at it.

Your insert stored proc needs to have 2 insert statements.

insert Profiles

insert [Role]

I have...

You have been around here long enough to know we need more details to work with here.

To do this I would suspect you need to first split those values using...

It looks like you are trying to create a comma separated list of values? Check out this article. http://www.sqlservercentral.com/articles/71700/%5B/url%5D

Thanks Jeff that is awesome!!!!

Pretty sparse on details but I am pretty sure something like this will work.

select top 1 max(ID), max(FID), HC, vc, Max(sN), MAX(updateddate)

from SomeTable

group by hc, vc

If that doesn't work, please...

Eliezer Pimentel (11/25/2013)

---

I am the follow error: exception of type 'system.outofmemoryexception' was thrown in sql server 2008, this ocurs when i try Copy of Headers of the Results. What is...

Jeff Moden (11/25/2013)

---

Sean Lange (11/25/2013)

---

Kurt W. Zimmerman (11/25/2013)

---

Jeff Moden (11/24/2013)

---

Neither. I use dynamic SQL with two TOPs in dynamic SQL and get returns in less than 500 ms ...

user defined...

Nice easy question to start the week. I am rather shocked that 16% (101 people) at the time of this posting missed this one.

I don't see anything wrong with what you...

You can easily use a computed column for this.

create table #Something

(

CIDADE varchar(50),

VALOR int,

RJ_MES_JANEIRO as case when CIDADE = 'RIO DE JANEIRO' then Valor else 0 end

)

insert #Something

select 'RIO DE JANEIRO',...

Excellent job posting ddl. What I don't quite understand is where the issue is. I would recommend going away from the type of storage you are using with countryid. You...

KcV (11/25/2013)

---

Hi,

Now a days i am converting my .net code in SP as much as possible. i am converting all sql queries to SPs to save data. all most all...

Kurt W. Zimmerman (11/25/2013)

---

Jeff Moden (11/24/2013)

---

Neither. I use dynamic SQL with two TOPs in dynamic SQL and get returns in less than 500 ms from a million row...

There is nowhere near enough information for much more than a wild guess. You need to provide a lot more details about the source file, the target tables and the...