Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Xerxes
Aged Yak Warrior
666 Posts |
 Posted - 2010-03-08 : 15:17:37
|
I've never seen this anywhere. Am wondering if anyone has some simple examples of this: loading an excel spreadsheet from SQL array variables. Thanks...Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL & VB obviously! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2010-05-25 : 14:00:42
|
| Anyone know anything about converting from SAS Proc SQL to T-SQL?I have an issue where a single variable in SAS (:dt) can contain several values as a range of variables.proc sql noprint; select max(upd_dt) into :dt from dash.tickets; create table current as select a.track ,b.event_date ,max(0,a.event_date - &dt.) as days from dash.events_main a ,dash.events b ,dash.tickets c where a.event_main_id = b.event_main_id and b.track = c.track and b.event_id = c.event_id where a.event_main_id = b.event_main_id and b.track = c.track group by 1, 2, 3, 4, 5, 6, 7 order by 1, 2, 3 ;quit;What I wish to do is convert this into T-SQL.How would I go about creating a dynamic array in T-SQL.BTW....I know I'm incredibly lucky if I can find an answer to this.Thanks...Semper fi, XERXES, USMC(Ret.)------------------------------------------------------The Marine Corps taught me everything but SQL & VB obviously! |
 |
|
|
|
|
|
|
|
Load Excel from SQL vars