IRC Chat Logs - An Archive of EFnet IRC Channels

Session Start: Fri Dec 28 00:00:00 2007
Session Ident: #sql
[00:50] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[01:50] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[03:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[04:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[05:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[06:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[07:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[08:08] <The_DeaD> Hi Guys - I have a question. I am using MYSQL and have a table with a ID
[08:08] <The_DeaD> i looked up JOIN, but I dont really understand it
[08:11] <Halo_Four> #mysql
[08:11] <The_DeaD> ok thanks
[08:38] <thunkjump> I'm using MSSQL Server Dev 2005 - I try to INSERT to a smalldatetime colu
[08:38] <AMF3> Hi everyone
[08:38] <purl> Howdy, AMF3, you fantastic person you.
[08:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[08:38] <thunkjump> hi
[08:39] <AMF3> purl :)
[08:39] <purl> AMF3: Unbalanced parentheses (too many ')')
[08:39] <AMF3> purl: amazing, I didn't even ask a question :)
[08:39] <purl> AMF3: sorry...
[08:39] <AMF3> I don't use smilies in queries so its ok
[08:41] <AMF3> is it okay to ask a fairly complex (in my opinion) question when i'm not so ho
[08:41] <AMF3> Or is this channel only for people who know pretty much what they're talking a
[08:41] <thunkjump> just ask
[08:41] <AMF3> thx
[08:41] <thunkjump> :)
[08:42] <thunkjump> the answer is: Gamma Ray Bursts
[08:42] <AMF3> well I think I need to create views (which i've never done) but i'd like a sec
[08:42] <thunkjump> jk
[08:42] <AMF3> :D
[08:43] <AMF3> http://www.pastebin.ca/index.php
[08:43] <AMF3> woops hang on
[08:43] <AMF3> http://www.pastebin.ca/834970
[08:44] <AMF3> in my app (im using delphi) im trying to make a grid view with three buttons (
[08:44] <AMF3> all of the data is stored in one table.
[08:45] <AMF3> Numbers 200, 300, 400 etc (going up in hundreds) are summary rows and the amou
[08:45] <AMF3> the actual items with real money values go up in 1s... ie 211, 212, 213 etc
[08:45] <AMF3> have I lost you all already?
[08:46] <thunkjump> give me a moment, trying to read the paste, deal w/ wife and phone
[08:46] <AMF3> oh sure :)
[08:47] <Halo_Four> I suggest learning relational design.
[08:48] <Halo_Four> Instead of this silly partial ID, use category and subcategory tables
[08:48] <AMF3> Halo: well it is relational yes, but all the DIN codes (including the calculat
[08:48] <Halo_Four> That is not relational
[08:48] <Halo_Four> You're trying to create a hierarchical model using these partial IDs
[08:48] <AMF3> Halo yes thats right
[08:48] <AMF3> a tree
[08:49] <Halo_Four> Which is completely unnecessary
[08:49] <Halo_Four> Not to mention hobbles the design as you can only have 9 items per level
[08:50] <AMF3> well infact there is provision in the app for extending the code ie, 312.002T
[08:50] <Halo_Four> Still a horrifically poor design
[08:50] <AMF3> well it isn't designed yet.. im still pondering - never done this before
[08:52] <Halo_Four> If there are three levels of categories I would use three tables.
[08:52] <Halo_Four> Categories, Subcategories and Items
[08:53] <AMF3> aha...
[08:53] <Halo_Four> Items would contain the Subcategory ID and Subcategories would contain th
[08:56] <AMF3> so in each table i'd have a field called "parent_Category" or something like t
[08:57] <mattman> underscores are gay
[08:57] <AMF3> mattman :P ok ok
[09:16] <Purple-> somebody missed halo's point entirely
[09:16] <AMF3> purple?
[09:16] <purl> purple is Book => n. The `System V Interface Definition'. The covers of
[09:18] * DaveJ-UK is now known as DaveJ|UK
[09:19] <Purple-> haha
[09:20] <Purple-> amf3: you are doomed, but I might as well ask...explain this "parent_subcat
[09:20] <AMF3> well halo said that items would contain a subcategoryID and subcategories woul
[09:21] <AMF3> which translates in each table to a field called "parentID" - simple, isn't it
[09:21] <AMF3> and never say doomed... just rather stuck
[09:21] <Purple-> doomed
[09:21] <AMF3> alright go on then... why doomed?
[09:22] <Purple-> it's just my opinion
[09:22] <AMF3> you need more prozac..
[09:24] <QWERTQ> hello
[09:24] <QWERTQ> good evening
[09:24] <purl> Velcome to my castle!
[09:24] <QWERTQ> i have a question
[09:24] <QWERTQ> how can i read .sql ?
[09:24] <Purple-> uh. notepad
[09:24] <QWERTQ> ops
[09:24] <QWERTQ> unreadable data
[09:25] <QWERTQ> i tried it by using notepad
[09:25] <Purple-> then either something wrote something and just called it .sql, it's encrypt
[09:25] <QWERTQ> if i want to open it in readable form, what kind of sqlsoftware i have to us
[09:25] <Purple-> where did you get it?
[09:25] <QWERTQ> ok
[09:25] <QWERTQ> school computer
[09:25] <Purple-> what created it?
[09:25] <AMF3> how big is the file?
[09:26] <QWERTQ> i surfed almost all computers in school lan and get it from school office
[09:26] <QWERTQ> 3606kb
[09:26] <Purple-> then ask your teacher and stop stealing stuff
[09:26] <QWERTQ> no
[09:26] <AMF3> 3.6megs? ...
[09:26] <QWERTQ> yes
[09:26] <QWERTQ> 3.6mb
[09:26] <AMF3> dont use notepad :) wordpad might open something that big
[09:26] <QWERTQ> i tried
[09:26] <QWERTQ> but nothing i can read
[09:26] <POWER2112> i doubt it's actually SQL script
[09:26] <AMF3> that as purp says its probably a binary or encrypted file renamed to .sql
[09:27] <QWERTQ> i found one of the sql
[09:27] <QWERTQ> writes
[09:27] <QWERTQ> -- phpMyAdmin SQL Dump
[09:27] <QWERTQ> -- version 2.8.1
[09:27] <QWERTQ> -- http://www.phpmyadmin.net
[09:27] <Purple-> AMF3: notepad can easily handle 3 megs
[09:27] <AMF3> purple but its sllooooww
[09:27] <QWERTQ> --
[09:27] <purl> i heard -- was a switch that terminates switch processing.
[09:27] <QWERTQ> -- Dumping data for table `qna`
[09:27] <QWERTQ> --
[09:27] <purl> i heard -- was a switch that terminates switch processing.
[09:27] <QWERTQ> hey guys
[09:27] <QWERTQ> how can i open the file ?
[09:27] <Purple-> ask your teacher
[09:27] <AMF3> qwerto what are the first few letters at the top of the file when you open it?
[09:27] <QWERTQ> ar ?
[09:27] <QWERTQ> i stole it
[09:28] <QWERTQ> ask teacher ? no
[09:28] <Purple-> then go fuck yourself
[09:28] <QWERTQ> aish
[09:28] <AMF3> its purple's time of the month...
[09:28] <QWERTQ> share the data....if you can open and read it
[09:28] <Purple-> I hate thieves
[09:28] <Purple-> and idiots
[09:29] <POWER2112> I agree with Purple - this channel is to help with database/scripting rel
[09:29] <AMF3> Power2112 aha but all database/scripting problems are doomed...
[09:30] <Purple-> no, just yours
[09:30] <AMF3> ok :)
[09:37] * _MadScrib is now known as MadScribe
[09:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[09:57] <roast> hrm, can anyone tell me if there are dangers to xporting/importing from a .ix
[10:17] <POWER2112> My uncle tried that once...and now he's in the hospital. So yeah, I'd sa
[10:18] <POWER2112> gah, that was lame.
[10:29] <RJaway> ShrikeX know you were talking about db2 select usrs being able to select for
[10:29] <RJaway> http://tinyurl.com/2h27ej
[10:29] * RJaway is now known as rjarett
[10:29] <Halo_Four> True of any DB that I know of
[10:30] <Halo_Four> Using pure ANSI syntax, too
[10:30] <Halo_Four> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN TRANSACTION; SELECT
[10:30] <Halo_Four> As long as that connection is open, that table is locked
[10:31] <Halo_Four> To writes, anyway
[10:31] <Halo_Four> Is there an ANSI syntax for locking hints?
[10:32] <mattman> WITH LOCK :(
[10:33] <rjarett> yeah but if you dont want that user to have update righhts and dont gran
[10:35] * rjarett is now known as rjaway
[10:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[10:39] <Halo_Four> Yes, but hopefully that user doesn't have access to execute arbitrary SQL
[10:46] <ShrikeX> rjaway I didnt know that
[10:46] <ShrikeX> I think by default oracle performed dirty reads
[10:47] <ShrikeX> oh
[10:47] <_yuni2> halo other than a really small timeout
[10:47] <ShrikeX> I gotcha
[10:47] <Halo_Four> ANSI default is not dirty reads
[10:47] <ShrikeX> oracle by default dirty reads
[10:47] <_yuni2> is there anyway for userb to instantly get notification a table is locked be
[10:47] <ShrikeX> but if you have select on a table in oracle
[10:47] <_yuni2> if you want to lock it from reads etc
[10:47] <ShrikeX> you can perform a full table lock
[10:48] <ShrikeX> with the lock command
[10:48] <_yuni2> but is there anyway for an external app that uses the db to instantly know
[10:49] <_yuni2> if you put a low timeout than regular locks might not wait 4s to find out th
[10:49] <Halo_Four> Some DBs permit lock timeouts
[10:49] <_yuni2> sot hen what you need code in your DAL to change the DB
[10:49] <_yuni2> timeout value dpeneding on the access?
[10:49] <_yuni2> like im doing a VFP app that calls into SQL and some forms instantly know if
[10:49] <_yuni2> wondering how it does that
[10:50] <Halo_Four> It's written into the app
[10:50] <rjaway> you can hackishltrigger a check for locks
[10:50] <rjaway> or use aq'ing
[10:50] <_yuni2> written into the app?
[10:50] <_yuni2> isnt the only way to know its locked or cant get access via a tiemout
[10:50] <ShrikeX> thats kinda nuts
[10:50] <_yuni2> *timeout
[10:50] <rjaway> ive seen cases where its done.
[10:50] <Halo_Four> As in it uses it's own table to track logical locks and doesn't rely on t
[10:51] <_yuni2> i dont think its that fancy
[10:51] <Halo_Four> Probably is
[10:51] <_yuni2> and then you run into issues of clearing out that table on crashes
[10:51] <_yuni2> etc
[10:51] <Halo_Four> yep
[10:51] <Halo_Four> As a lot of software does
[10:51] <_yuni2> so outside of that
[10:51] <_yuni2> the only other way is having a miniscule timeout
[10:51] <_yuni2> and catching the errorcode
[10:51] <Halo_Four> That won't tell you who
[10:52] <_yuni2> yeah i dont care who
[10:52] <_yuni2> thats fucking ghetto
[10:52] <_yuni2> so you need to know on which requests the timeout should be made small
[10:52] <_yuni2> so that you can handle this
[10:52] <_yuni2> and instantly tell a user to try again later
[10:53] <_yuni2> what about accessing the informationscheema or dblocks or whatever it
[10:53] <_yuni2> is
[10:53] <rjaway> queue all sql dont submit it directly
[10:53] <_yuni2> to see if that dbobject is locked
[10:54] <_yuni2> more ghetto?
[10:54] <rjaway> let the queue handle running it once locks clear
[10:54] <_yuni2> not practical in web environment
[10:54] <_yuni2> no way to push back some results or updates to the user once its done
[10:54] <rjaway> yeah it is
[10:54] <_yuni2> or allow them access to the page
[10:55] <rjaway> what would limit page access?
[10:55] <_yuni2> and im not doing some meta refresh of 10s
[10:55] <rjaway> like logging hits?
[10:55] <_yuni2> sometimes theirs long running tasks
[10:55] <_yuni2> data processing
[10:55] <_yuni2> and if a user say looks at a maintenance page
[10:55] <roast> POWER2112: on a score of 1 - 10, 10 being the highest, your joke scored 0/10
[10:55] <_yuni2> dont want them maintaining the table
[10:56] <rjaway> use async commits
[10:56] <rjaway> let them drop their crap on the stack
[10:56] <rjaway> dont worry when its done
[10:56] <_yuni2> asynch commits?
[10:57] <_yuni2> i can submit their maintenace sql for execution later?
[10:57] <rjaway> when ever the db is ready it will clear its buffer and commit
[10:57] <rjaway> but the app sees it logically committed it
[10:58] <rjaway> so no wait time
[10:58] <rjaway> google for oracle batch nowait commit
[10:58] <_yuni2> im using optimistic offline locking
[10:58] <_yuni2> mssql has that capabiliity?
[10:58] <rjaway> lol sxrew mssql. use a real db
[10:59] <rjaway> :)
[10:59] <_yuni2> haha not my choice
[10:59] <_yuni2> fuck this apps giving me an ulcer
[10:59] <rjaway> i couldnt habdle the wait time to commit in some of my apps without it
[10:59] <rjaway> since its realtime market data
[11:00] <rjaway> heliobacter pylori gives ulcers
[11:00] <Halo_Four> Such options make a DB non-ACID
[11:00] <rjaway> its still acid
[11:00] <_yuni2> what if the db blows up prior to the execution of the asynchs
[11:00] <Halo_Four> No it's not
[11:00] <purl> No it's not is not
[11:00] <_yuni2> is it in the transactino log
[11:00] <Halo_Four> "The obvious danger of asynchronous commits is that your DBMS is no longe
[11:00] <rjaway> yes it is
[11:00] <Halo_Four> http://www.orafaq.com/node/93
[11:01] <rjaway> iall youre doing is not waiting or the disk to say, yeah i got it
[11:01] <_yuni2> so halo you use super small timeout?
[11:01] <rjaway> which is the same as using async io or disk caching
[11:03] <Drk`Angel> "If the environment is not configured for synchronous commit, the commit
[11:03] <Drk`Angel> http://www.oracle.com/technology/documentation/berkeley-db/je/java/com/sl
[11:03] <NyQuil> http://tinyurl.com/2c58nb
[11:04] <Drk`Angel> I think I trust the guys at oracle more than I trust some random schmoe o
[11:04] <Halo_Four> burn
[11:04] <rjaway> if you use caching on a disk array you cant guarentee that either
[11:04] <rjaway> so i say it still is
[11:04] <Halo_Four> Good thing you're the authority.
[11:04] <Halo_Four> Oh wait, you're not
[11:04] <Drk`Angel> YOu can also say the sky is purple if you want to. You'd still me wrong.
[11:04] <Drk`Angel> be*
[11:05] <Halo_Four> Disk cache has a battery
[11:05] <rjaway> and?
[11:05] <rjaway> doesnt guarentee reliability
[11:05] <rjaway> san says yeah i got the data
[11:05] <Halo_Four> Gets as close as it can
[11:06] <rjaway> not yeah its written to disk
[11:06] <Halo_Four> Better than the software making that determination
[11:06] <bcow> :O
[11:06] <Drk`Angel> Also - if you think the tradeoff is worth it, then do it. Just don't run
[11:06] <Halo_Four> Doesn't matter, the current employees of Oracle think you're wrong.
[11:06] <Halo_Four> You could do something similar in MSSQL, but you'd have to design it expl
[11:07] <rjaway> eh doesnt matter. i was one of them employees writing the material
[11:07] <Halo_Four> Yeah, many moons ago
[11:07] <rjaway> im as much an authority lol
[11:07] <Halo_Four> Not anymore
[11:07] <rjaway> i say its acceptably acid
[11:07] <Halo_Four> And they don't
[11:07] <rjaway> by the same notion that the disks dont report true writes
[11:07] <Halo_Four> Lots of people say MySQL is acceptably ACID
[11:08] <rjaway> but it doesnt matter. ms will add the feature in 8 years
[11:08] <rjaway> thhen youll suck gates dick raving about it
[11:08] <Halo_Four> How long did it take Oracle to get calculated fields again?
[11:09] <rjaway> how long did it take ms to get flashback query or db?
[11:09] <rjaway> :)
[11:09] <Halo_Four> Still doesn't have it. What's your point?
[11:10] <rjaway> the dude here needs to ensure locks dont screw him up on maintanence sql. t
[11:10] <rjaway> too bad hes running ms
[11:10] <rjaway> lock timeouts..... what a reliable alternative.... lovely
[11:11] <Halo_Four> Sure, you can improve performance by ignoring ACID. That is the MySQL ma
[11:11] <rjaway> what happens to user when you time him out?
[11:12] <Halo_Four> You'd rather the user assume something was successful?
[11:13] <rjaway> yep. sine i know its on the dbwr queue and will get done
[11:13] <rjaway> same thing it does anyway
[11:14] <Halo_Four> If you're telling me that batch/nowait commits don't observe locking then
[11:14] <rjaway> you cant guarentee its on disk with normal commits. only that it was passed
[11:15] <Halo_Four> Which has nothing to do with lock contention
[11:15] <rjaway> ohhh well im at the mall now. you kids enjoy your sqlserver and ask santa fo
[11:15] <Halo_Four> Enjoy your implicit successes Mr. PHP.
[11:16] <Halo_Four> There's nothing like assumptions in the DB. Yay.
[11:17] <POWER2112> retard - christmas is over
[11:20] <mattman> retard
[11:25] <bcow> hrmm whats the best way to select duplicates based on 3 columns, in ms sql 200
[11:27] <POWER2112> SELECT column1, column2, column3 FROM dbo.Table GROUP BY column1, column2
[11:28] <POWER2112> You could even throw a "COUNT(*)" in the select list if you wanted to see
[11:32] <bcow> cool, thanks POWER2112
[11:33] <POWER2112> yarrrrr
[11:38] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Merry Chr
[11:55] <cell> rjarett has short cock timeoutz
[12:16] <wassa> good afternoon.. I was hoping to write an active X task for mSSQL 2000 that w
[12:16] <wassa> but rather in how to write the insert command?
[12:17] <wassa> i can't see how to write the insert and use the text file connection string?
[12:17] <wassa> other than to loop through each row
[12:18] <Halo_Four> DTS doesn't loop
[12:18] <Halo_Four> Is it always 5 files?
[12:18] <wassa> yes
[12:19] <wassa> well i could set up a loop within the active x though right?
[12:19] <Halo_Four> You can use an ActiveX Script task to set variables to the file names and
[12:19] <Halo_Four> Yes, but you can't loop the imports
[12:20] <wassa> hmmm i was hoping to create a small scheduler table that would hold the vars
[12:21] <wassa> then the user would only need to add a new schedule item without having to st
[12:22] <cell> you can do it
[12:22] <cell> with a vb6 app or someshit
[12:22] <cell> ohhh
[12:22] <cell> halo said alrdy
[12:22] <wassa> that was what i was thinking
[12:22] <wassa> just create one simple vbs with a couple loops
[12:23] <wassa> but like i said .. my issue is in how to quickly take the csv datasource and
[12:25] <Halo_Four> Where is the CSV and what kind of transformation is necessary?
[12:25] <wassa> if is set x=SQL Datasource and Y=CSV datasource.. and the SQL for x is insert
[12:26] <wassa> the csv can be in \\ohercomputer\path\name.csv .. the shell data is already s
[12:26] <wassa> shell data = shell table
[12:26] <wassa> shell table
[12:26] <Halo_Four> Could use BULK INSERT
[12:27] <[_MoZ_]> wassa, whats the target dbms?
[12:27] <wassa> MSSQL 2k = I was thinking the bulk insert but can you put that into a a VB6 c
[12:27] <[_MoZ_]> DTS has a bulk-insert option that accepts CSV as a source
[12:28] <wassa> where you can change the csv source dynamically?
[12:28] <Halo_Four> You can perform a BULK INSERT purely from T-SQL
[12:28] <[_MoZ_]> and if you have an unknown number of text files, of the same file format ..
[12:28] <Halo_Four> MoZ: It doesn't
[12:29] <Halo_Four> DTS flow control is precedent based
[12:29] <[_MoZ_]> Halo_Four, it does if you write an ActiveX Script, lol
[12:29] <wassa> you can tweak it to loop Halo
[12:29] <Halo_Four> You can loop within an ActiveX script, yes, but you cannot loop import or
[12:29] <Halo_Four> SSIS can, tho
[12:29] <Halo_Four> DTS tasks only execute once
[12:29] <[_MoZ_]> Halo_Four, DTS can have a circular reference ...
[12:29] <Halo_Four> When all of the precedent tasks complete
[12:29] <Halo_Four> No it can't
[12:29] <[_MoZ_]> I've done it before
[12:30] <wassa> you could tack an active x onto either end of a DTS and just set a variable t
[12:30] <Halo_Four> You can't backtrack steps
[12:30] <[_MoZ_]> wassa, yeah, you could do that ...
[12:30] <[_MoZ_]> Halo_Four, steps can be linked to anything ...
[12:30] <wassa> you can't backtrack, but you can redirect until the variable = y
[12:30] <[_MoZ_]> if step 1 goes to step 2 then to step 3 ... 3 can go back to 1
[12:30] <Halo_Four> You can set their precedents, they are not linked
[12:31] <Halo_Four> A circular precedent will never execute
[12:31] <wassa> Halo, I like your idea though of the bulk insert from T-sql
[12:31] <Halo_Four> The only way to loop in DTS is via attempting to grab individual tasks an
[12:32] <wassa> agreed
[12:32] <[_MoZ_]> Halo_Four, yeah
[12:32] <[_MoZ_]> or alternatively, the package could execute itself, lol
[12:32] <[_MoZ_]> which was my original idea for this, lol
[12:32] <[_MoZ_]> wassa, if all your doing is importing CSV data ... then yeah, a bulk insert
[12:33] <Halo_Four> DTS is just a wrapper around a bulk insert
[12:33] * [_MoZ_] changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[12:33] <[_MoZ_]> Halo_Four, uh huh ;p
[12:33] <[_MoZ_]> ie; too bloated for the task
[12:33] <Halo_Four> nah
[12:33] <[_MoZ_]> T-SQL is much more elegant for doing bulk inserts from flat-file datasource
[12:34] <Halo_Four> As long as the file is simple and located somewhere that the server can r
[12:34] <[_MoZ_]> lol
[12:34] * [_MoZ_] wonders how far he can take the useless and pointless conversation
[12:34] <[_MoZ_]> DTS sucks!
[12:34] <Halo_Four> In which case, yeah, works great
[12:34] <[_MoZ_]> T-SQL Rocks!
[12:34] <[_MoZ_]> unF!
[12:34] <Halo_Four> BULK INSERT is very limited in terms of what it can do
[12:35] <[_MoZ_]> yeah, but if all your doing is a straight import ... it's the fastest, most
[12:35] <[_MoZ_]> if you need to perform transforms, etc ... then DTS is the best way
[12:35] <wassa> agreed, but in this case my only requirement at this time is to get the data
[12:38] <wassa> from T-Sql 'You do not have permission to use the BULK INSERT statement.'
[12:39] <wassa> hmm but I am listed with dbo privilege
[12:40] <[_MoZ_]> need sysadmin rights to do bulk insert
[12:40] <[_MoZ_]> requires direct access to the file system
[12:40] <wassa> ok
[12:53] <wassa> jhg
[12:59] <[_MoZ_]> asdf
[13:06] <cell> no
[13:07] <cell> grant bulk-insert on table to you
[13:07] <cell> somtehinglike that
[13:09] <Kunnis> [_MoZ_] There's actually a bulk load privlige that you can use instead of s
[13:10] <Kunnis> "Bulk Insert Administrators" in the gui
[13:11] <cell> fuck gui
[13:13] <mattman> i like to fuck the gui
[13:23] <warjest> with mssql2005 is there any sort of wizard to generate insert/update stored
[13:28] <warjest> erm, guess not.
[13:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[13:34] <wassa> hmm. bear with me here.. the data is looking like this "123423",123 street","
[13:34] <mattman> yea
[13:34] <wassa> when I look at it in notepad2, the terminator shows up as LF
[13:35] <wassa> rowterminator
[13:36] <wassa> hmm cuz when i use that i get an error saying last column is too long, and wh
[13:37] <warjest> load it in a hex editor, that has text qualifiers and field terminators
[13:39] <wassa> winhex?
[13:40] <warjest> any advanced text editor to see what type of line feeds it is using
[13:40] <wassa> im using notepad 2
[13:40] <ShrikeX> fuck notepad
[13:40] <ShrikeX> textpad is free
[13:40] <ShrikeX> us vi
[13:41] <wassa> vi?
[13:41] <purl> vi is like masturbation, it's not as good as the real thing, but at least it's
[13:45] <cell> vi is cool
[13:47] <Aragorn16> I'm switching from SQL 2003 to SQL 2005. I knew enough DTS to get by, but
[13:50] <wassa> ergh... i get OA as the ending which ascii converts to ? which still don't wo
[14:17] <wassa> maybe a dumb one here.. but if i have 21 cols in the table and col21 has a de
[14:19] <mattman> yea
[14:21] <wassa> hmm this is weird man... i don't get any errors, but I get 0 rows inserted ea
[14:21] <wassa> affected = inserted
[14:25] <wassa> can someone give this a shot and tell me if the syntax is working for them? l
[14:25] <wassa> http://sql-servers.com/nopaste/index.php?show=150
[14:25] <wassa> using mssql2k
[14:27] <Halo_Four> You sure that the MSSQL service user can access that share?
[14:29] <wassa> well I was getting truncation errors earlier
[14:29] <wassa> which leads me to think that it should be able to
[14:30] <wassa> and when i fuck around with the file.. i generate other errors
[14:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[14:35] <wassa> any ideas Halo_Four?
[14:41] <totalnooo> hey, i have a Scalar-valued Function. but the data I have is in a Table
[14:41] <totalnooo> how do I return that data?
[14:42] <totalnooo> its only 1 item with 1 column
[14:42] <totalnooo> http://www.nomorepasting.com/getpaste.php?pasteid=9057
[14:42] <NyQuil> http://tinyurl.com/yvlweq
[14:53] <LVK> looks like you return it fine there, what's the problem?
[14:54] <wassa> this is driving me fuckin crazy
[14:54] <LVK> eh, well, return the value perhaps
[14:54] <LVK> DECLARE @val INT
[14:54] <LVK> SELECT @val = ....
[14:54] <LVK> RETURN @val
[14:57] <totalnooo> I needed to put the whole thing inside Return
[14:57] <totalnooo> didn't know that ^.^
[14:57] <totalnooo> thx
[15:07] <wassa> fucking hell.. I just can't see what the problem is here.. I Have tried.. \t,
[15:10] <wassa> is anyone able to run this sample successfully? http://sql-servers.com/nopas
[15:14] <LVK> does it run at all, give errors? give wrong results?
[15:20] <LVK> Hello?
[15:21] <LVK> FYI it runs fine here, except for the fact that it adds quotation marks on firs
[15:29] <wassa> hi.. i am positive it has to do with the fact the rowterminator is LF vs CRLF
[15:33] <LVK> well, it worked "fine" for me, I got 2 rows imported, first and last column got
[15:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[15:41] <wassa> thanks..
[15:42] <LVK> perhaps the file you're trying to import has problems?
[15:42] <LVK> what happens when you try it?
[15:58] * Disconnected
[15:58] * Attempting to rejoin channel #sql
[15:58] * Rejoined channel #sql
[15:58] * Topic is '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the New Year, and n
[15:58] * Set by NyQuil!~NyQuil@HW-ESR1-208-102-43-89.fuse.net on Fri Dec 28 15:33:16
[15:58] -NyQuil- Welcome to #sql Please read these brief rules or be banned without warning:
[15:58] -NyQuil- 1) Dont ask if you can ask a question, just ask it.
[15:58] -NyQuil- 2) If you ask a database question, and dont say what database youre using (MSSQL,
[15:58] -NyQuil- 3) SQL Code should not be pasted in chan, please use http://sql-servers.com/nopast
[15:58] -NyQuil- 4) If we say RTFM, its because you should. For MSSQL check Books Online. Enjoy You
[15:58] -NyQuil- 5) No Homework! No MySQL!
[16:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[17:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[18:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[19:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[20:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[21:27] <Kunnis> AWw, I knew the answer to wassa question
[21:28] <Kunnis> there's a "feature" about bulk import.. it interpets \n as \r\n... there's a
[21:32] <Kunnis> you have to build a query, using "bulk import blah blah... rowterminator = '
[21:32] <Kunnis> Then execute that string
[21:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[21:45] <QWERTQ> hello
[21:45] <QWERTQ> i have a simple question
[21:45] <cell> go
[21:45] <QWERTQ> how can i execute mssql in cmd ?
[21:46] <cell> what
[21:46] <cell> use isql tool
[21:46] <QWERTQ> i want to use some command line
[21:46] <QWERTQ> ?
[21:46] <Purple-> if it's simple you should stop being lazy and google it
[21:46] <cell> isql tool damnit
[21:46] <cell> or osql
[21:46] <cell> w/e its called
[21:46] <cell> its a command line executible
[21:46] <cell> u pass info to it and shit
[21:46] <Purple-> if you can't google it, you aren't qualified to define it as "simple"
[21:46] <QWERTQ> erm
[21:46] <QWERTQ> i googled it
[21:46] <Purple-> and can't find the answer?
[21:46] <QWERTQ> but all is not concern with mine
[21:47] <QWERTQ> and lots of people ask the same question in forum but did not get reply
[21:47] <Purple-> so how do you have the balls to define it as "simple"?
[21:47] <QWERTQ> hey
[21:47] <QWERTQ> dont argue bout that word ?
[21:47] <cell> i gave you an answer
[21:47] <cell> and you are talking
[21:47] <cell> go google it
[21:47] <cell> !google isql mssql
[21:47] <NyQuil> Isql Command line parameters - MS SQL @ http://www.thescripts.com/forum/thre
[21:47] <logiclrd> cell: http://www.thescripts.com/forum/thread83211.html
[21:47] <QWERTQ> cell : thanks...
[21:48] <cell> fucking tard
[21:48] <Purple-> only thing worse than noobs is lazy noobs.
[21:48] <Purple-> been a long time since I met a non-lazy noob these days :(
[21:49] <Purple-> great. now I have Zep stuck in my head
[21:49] <QWERTQ> purple-
[21:49] <QWERTQ> go to hell
[21:49] <purl> it has been said that go to hell is http://www.boasas.com/?c=691
[21:49] <QWERTQ> donkey
[21:49] <Purple-> "been a long time, been a long time, been a long lonely lonely lonely lonel
[21:49] <Purple-> qwert: meet you there you lazy fucktard
[21:50] <QWERTQ> scrap purple
[21:50] <Purple-> only pleasure I get from you people is knowing that you will either never g
[21:51] <cell> i hate lazy noobs
[21:51] <cell> dumb
[21:51] <cell> amazingly
[21:52] <Purple-> hrm...brb
[22:08] <QWERTQ> purple is dump fuck
[22:08] <QWERTQ> haha
[22:09] <light2> hey
[22:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
[22:36] <Purple-> ah, the famous "name call and run"
[22:36] <Purple-> classy
[22:39] <Purple-> my fan club. :)
[22:46] <cell> lol
[23:33] * NyQuil changes topic to '[ http://sql-servers.com || PasteBin on Main Menu ] | Fuck the
Session Close: Sat Dec 29 00:00:00 2007