That's part of the reason why people still use cross-tabs on the server side... "Respect the pipe!" 😛

Brandie Tarvin (12/5/2008)

---

Yeah, Jeff'll never hire me. @=)

Actually, I must point out that I've run into one...

Click on my name to the left of this post near my avatar... send me an email.

I'll be happy to look at it through email before you post...

rog pike (12/4/2008)

---

Exec Rac

@transform='(Room) as Room',

@rows='[Floor]',

@pvtcol='Room',

@from='Rooms',

@defaults1='y',@rank='Room',@racheck='y',@shell='n'

Floor Room1 Room2 Room3 Room4 Room5 Room6

------- ----- ----- ----- ----- ----- -----

Floor 1 101 102 103 ...

Heh... that code never get's past the first 10000... keeps updating the first 10000 over and over and over.

Lemme build a test table, write a bit of code, and I'll...

Pickle juice or formaldehyde? With or without pork chops? 😛

Sorry... I missed the fact that you were doing a count on the table... not returning rows... Got a PK or any decent indexes on the table?

I never import directly into the final target table... I always use a staging table. That way, I can do validity checks before the new data actually get's added.

If...

SELECT RIGHT(GETDATE(),7)

No chance of using indexes... it's gonna return the whole table. How many rows are in the table? Also, are you sure it's a table and not a...

I tried sending server health reports to developers, once. The response was, "I already get enough email... would you stop sending these to me?" 😉

fausto usme (12/4/2008)

---

>>What about column names? With an indeterminate number of rooms, figuring out what to name the columns dynamically becomes an issue.

Exactly, the rooms in this hospital are...

Heh... No matter where it's done, I'll still like to know why the BA thinks that listing an unknown number hospital rooms horizontally is the right thing to do on...

Does that mean you're using the cross-tab tool in...

The question is still important because it will determine how the columns in the table are named and a couple of other things like whether to use A VARCHAR(8000) or...