Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

convert vb code to t-sql (pdf automation) Expand / Collapse
Author
Message
Posted Wednesday, August 14, 2013 9:07 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
Sean Lange (8/14/2013)
Why do you want to do this in t-sql? It is the wrong tool for the job. A CLR proc, SSIS or even an application would be a much better choice here.


If you have someone that can write a CLR, use SSIS, or write an application to do it, maybe.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1484566
Posted Wednesday, August 14, 2013 9:09 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
Sean Lange (8/14/2013)
Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us what you are actually trying to do.

(http://www.sqlservercentral.com/Forums/Topic383628-131-1.aspx)


I just have to ask... what in the world made you look for a previous thread on this?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1484567
Posted Thursday, August 15, 2013 7:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:05 PM
Points: 13,327, Visits: 12,820
Jeff Moden (8/14/2013)
Sean Lange (8/14/2013)
Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us what you are actually trying to do.

(http://www.sqlservercentral.com/Forums/Topic383628-131-1.aspx)


I just have to ask... what in the world made you look for a previous thread on this?


Didn't go searching for it. It popped up on the Active Threads and I noticed the most recent post was the same person. They were right next to each other on the list.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1484752
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse