| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> anyone experienced with ODBC and excel? my work uses an ERP system based off of Syspro combined with an excel 'dashboard' that pulls information relating to sales orders from the database and displays them in excel
<0> i need to display that information differently
<1> Syspro baby!
<0> yeah our IS director was one of the original pair that made Syspro
<2> what do you mean odbc and excel?
<2> open up a connection in vba
<2> pull data
<2> rinse repeat.
<2> done.
<0> well im just playing around with this, i've never used this stuff
<0> i need my output in excel, so i have excel and microsoft query going
<0> ill play around a bit more before asking anything
<2> use the
<2> "record macros"
<2> option.
<2> best way to leran.
<2> learn
<0> not sure what you mean, what do macros have to do with anything
<0> gah i dont think i can do this, all the fields are named by someone else
<0> maybe you can tell me if what i want can even be done with sql queries alone
<2> yes it can.
<0> I have sales orders in the DB, say for a single sku. I'll have maybe 5 orders for SKU "A" spaced a week apart. I need to see a report that says You have a total qty of X of SKU A on order, with earliest due date being Y. But the earliest due date would be affected by what we have in inventory. So if the first order is due today for 100pcs, and we have 100pcs in stock, the report will not count that first order as part of the qty we need to prod
<0> nor will it count that order's due date as being the first due date we need to produce for
<0> so even though we have an order due today, since inventory covers that due date off, the report will say we need to produce by next week which is the next soonest due date
<2> sounds easy
<3> dave
<3> it sounds like you need a dba
<3> or sql developer
<0> probably
<0> im going to see what i can do with VBA and just manipulate the existing results from the db query
<4> if im doing a select and retrieving dates from a column do i use to_date to change the format?
<4> i used it when adding a value .
<4> men
<4> ok to_char
<4> thanks for the help
<4> :D
<4> is there anyway i can make the name of the column something different
<4> of the output
<5> yes
<4> got it
<4> took 10 minutes, but got it
<6> in mssql, can the defaults be set based on other columns? example, if i had col x, y and z, can i set the default for z = (x + y)
<6> ?
<6> ah never mind.. seems like my only options are computed columns or udf
<1> you can do so with a trigger
<4> ugh!
<1> ugh?
<4> anyone wanna do this for me
<7> no
<4> k
<4> just wondering
<7> :)
<3> i want to do it for you
<3> and i know you want to pay my bills
<7> :)
<7> Question. When im inserting or updating a record, is there a Now() function? (TSQL)
<7> I wanna try something like Update Content Set Date = Now() Where tid = @tid
<7> but that dont work... suggestions appreciated ;)
<4> i have a question- how do i use a subquery with the 'IN' keyword to show employee names who are working on project 1002.
<6> mssql: hmm do triggers get fired off when importing data via dts?
<6> JQ_man: getdate()
<7> ahh great tnx
<6> no-sweat: you gotta be a lot more clear than that
<6> whats your table structre
<7> SicWork: i have a TSQL book right besides me, let me see if i can get your answer
<4> EMPLOYEE_NAME | PROJECT_ID
<4> er
<4> no
<4> PROJECT_ID | EMPLOYEE_IN_CHARGE
<4> EMPLOYEE_NAME | EMPLOYEE|ID (PK FOR EMPLOYEE_IN_CHARGE)
<4> there we go
<4> :|
<7> SicWork: i think your answer is 'yes'.
<7> Soley because importing requires an insert, and you can get a trigger to execute during inserts..
<6> doing it right now and im not seeing the trigger run
<7> then the answer is no.
<7> LOL
<6> JQ_man: ur no help
<2> that was actually verh helpfull.
<6> no-sweat: ur an idiot
<6> ninjajax: not really... maybe theres some setting i gotta turn on that i dont know about
<7> Sorry man... i dont see any reference to DTS in my TSQL book. It does mention triggers on insert, thats the only way i see an improt actually putting data into a table... *shrug*
<2> cha
<2> what sql server u using agin?
<6> just because it doesnt automatically work doesnt mean it doesnt work
<6> 2000
<4> hah
<4> weeee
<6> JQ_man: theres also bulk inserts
<7> But its still an insert is it not?
<7> Are you not putting data INTO something?
<6> dont know how it internally does it
<6> if you are asking if im calling an "insert" statement then no
<6> im not.. does sql server internally call an insert statement when using dts? i dont know
<7> sql has to insert it Some how (im just using deduction...)
<6> JQ_man: dude your logic is wrong
<6> your ***umptions are wrong
<7> *shrug*
<6> "insert" isnt a single process
<6> theres many steps involved in inserting
<7> gotta put it in somehow... thats all i know..
<7> i know.
<6> one of hte steps being the trigger being called
<6> forget it
<7> Im just trying to get you to think man... truthfully, i did indeed look in my book though
<7> I see no reference to dts...
<6> thank you appreciate it
<6> but theres more than one way to skin a cat
<7> I may have gone overboard in the ridiculous comments about how it must 'insert'... but none-the-less ;)
<7> (it still HAS to insert, some how.. at some point... ) LOL
<6> you cant ***ume that a dts calls 10000 insert statements
<7> true
<6> ok now at what point does the trigger get called?
<7> *shrug*
<6> what is it that its monitoring?
<6> how is the trigger being called?
<6> exactly.. unless you have all that info, you cant make the ***umption that you are making
<7> truth be said, i can make any ***umption that I feel like making. Now whether it gives me correct information or not, that is truly a different question.
<6> you go ahead making ***umptions that dont give you correct information and you are in for some trouble
<7> Its safe to say, my ***umptions are probably wrong.... and that generally such generalized statements should not be made...
<7> *shrug* truth be said, im new to TSQL, so triggers are way beyond me.
<7> :D
<7> Good luck with that though.
<6> thanks
<8> y0 sic
<6> yo
<6> how u doing SBrick
<8> not bad
<8> WS is givin me trouble
<8> not quite kickin my ***, but sure as hell slowing me down :P
<8> how're you?
<6> not bad man
<6> WS?
<9> webservices
<9> hah
<6> ah
<6> ok stupid math question...
<6> for a percent increase.. what do you do if hte first number is negative and second is + ?
<6> so if hte first is -1 and second is 1
<6> its supposed to be (second - first )/first
<9> neagtive percent
<6> but this gives a negative %
<6> but thats nto right
<6> because it actually went up
<9> why isn't it right
<9> hmm
<6> because as we can see from the number, we actually increased
<9> i dont get it
<6> if anythin gits 200% increase
<6> is it supposed to be the abs value of the first?
<9> i dont get it
Return to
#sql
or
Go to some related
logs:
#unixhelp
#nhl
#nhl
dreamweaver umask
#hardware
#politics
#beginner
#politics
#windows
proxiesa
|
|