Gullimeel (7/9/2012)

---

Try something like this.

--change the id with ordno and cd with product code

select * from

(

select id,

max(case when cd = 'A' then 1 else 0 end) +

max(case when...

SQL* (7/9/2012)

---

Hi All,

When we upload a report (.rdl file) to reportserver using reportmanager, where this file will be stored will it store in IIS or Database (Which database)?

if it is...

mpdillon (7/8/2012)

---

I a typical Customer order scenario, there is a header record and one or more lines records per header. (If you would like sample files to create a table...

Sorry,...

Easy one to start the week.:-)

Nice workaround Rafael for 7 points 😉

Great !! But could you please...

herladygeekedness (7/6/2012)

---

I use parent pkg configs for several things - server, database, local file path, toggle in-pkg validation on/off...

It also passes in a parent pkg key to children...

Meditation

Now Andy Murray can freely breathe after lossing the Wimbledon Final to great Roger Fedrer 😉

Thanks Phil.

Chi Chi Cabron (7/5/2012)

---

I have a very simple SQL Server 2008 R2 SSIS package that imports 4 .csv files into a table.

If I deploy the SSIS package to the remote...

anuj12paritosh (7/5/2012)

---

HI ALL

I HAVE A STRING WITH DELIMETER

STRING IS 1^2~3^4~5^6

TREAT ^ AS COLUMN SEPARATOR AND ~ AS ROW SEPARATOR

HOW TO HANDLE THIS TYPE OF STRING AND DATA INSERT...

Jeff Moden (7/5/2012)

---

rhythmk (7/5/2012)

---

Javier-157657 (7/5/2012)

---

Each 3 rows in original table go to one row in the new view.

E.g:

Row1,Row2 and Row3 from original table go to Column1, Column2 and Column3...

crookj (7/5/2012)

---

1 step further - why...