I think he's saying something like "Computers can't process sets efficiently because the algorithms available today mean they have to iterate over the items in a set." Which isn't generally true, but maybe he just isn't explaining himself well...
@ypercube Imagine the box with white and black balls. Those who can deal with sets simply say: let there be white! But we are pick balls one by one and separate them as a shepherd separates the sheep from the goats. Because we can operate lists, arrays, trees but not sets. When we deal with the set we say: okay, let's represent this set as the (randomized) list! And then we do all that we can - we iterate list elements one by one. We achieve the same result and think that have the same ability. Isn't that a pride? :) — Kondybas12 mins ago
I asked this question Does Postgres have a function for converting text into ASCII escaped or HTML escaped text? and was looking to add tags such as conversion, escape, translate, html, ascii and found that they were not available.
Should the admins add some of these tags or related ones? They s...
i have one category table and other is product table. category id is the forigen key in product table. i want to get category name along with its count that how many time each category id exist in product table.
columns: categoryid,category name
table = products
Restarting the server should be enough - those worktables should clear out. But I'd probably start it up in single user mode (-m) to prevent other processes from creating worktables before you successfully remove those files. Then redefine the files required for tempdb; perhaps deleting unnecess...
Using object explorer in SSMS, find the table in question and expand the node so you see the Columns, Keys, Constraints, Triggers, Indexes, and Statistics
Drag the Columns folder into the query window pane. This results in a column-space delimited list of the columns in a single line.
Good evening stackoverflow community,
I have a problem with a sql-query for my database. I want to get the last n-entries of a specific Table. Usually I would perform the following query: 'Select Top 1000 (*) FROM Table ORDER BY Column DESC', but the problem is, that the table contains a lot of ...
I wrote 6 lines of code and a makefile. The program in question was a finite element model written by a Belgian civil engineer and commented in French. However, I did successfully port the application to run on MS FORTRAN. To this day I still know nothing about FORTRAN.
@ConcernedOfTunbridgeWells Did I remember correctly that code starts in 7? My constant doing friends and neighbors fortran instead of my chemistry lead me to finally understand my true calling wasn't engineering but computer science
Yet he gets all uppity giving people shit for being too stupid to understand when the updates were made and why the code in the article is not the updated version and doesn't match the code that's in the download.
I'm confused before I even get into the body copy.
i am doing a mobile application project that will allow students to access question form the database and answer them and given answers at the end. the application will cover maths, chemistry, biology and physics. i want to create a MySQL database but i do not know the table names and their struc...
I'm really interested in learning SQL (SQL server or Oracle) as I already have a bit of experience with the databases at work (mostly select statements). I don't have a technical background since I was a humanities graduate in college. I'm already starting to read about SQL and maybe take a SQL s...
The government consulting company I worked for, their time entry system used essentially guid length billing codes. You couldn't copy and paste a code from there so I'd get PMs sending me charge codes but since they're typing it out, I'd get to play "is that a zero or an oh. One or L" They tried sending screen shots but the helpful webpage used sanserif fonts
ok. makes sense, thanks. i went through and refactored many of my demo scripts so as to not use metadata functions. i just didnt want to incorrectly use BETWEEN :)
@AaronBertrand right. so the date use case is the one with which i'm familiar (from past experience). i just didnt know if there was (in your opinion) ever an appropriate use case for BETWEEN or if you'd just advocate the expansion (>= =<) as a general rule
even if they'd considered the time component, there's no guarantee that they'd return it at the resolution you require ... i mean what if you need 2014-02-28 11:59:59.999999 and they only gave you 2014-02-28 11:59:59.997
i'm trying to achieve the following with tsql
What i have in my table looks like this
A B C 3
what i want to have is
A B C 1
A B C 1
A B C 1
to split it based on the quantity column 4..
Not sure what function to use.
Any help would be appreciated thanks.
@bluefeet I know! Unusual questions can often be put down to people struggling with a new technology. But since more than one person asked the question, it means they're living in the same Bizarro world. I wonder what problems lead to these Bizarro solutions where you might want to duplicate rows this way.
Oh god, that cursor that does nothing? It actually does something. They didn't know how to assign to a variable from the query results so they spun a cursor to do nothing, that query only returns a single row and the make use of the FETCH NEXT to populate the variables.
Joined a start up that had virtually no database documentation and was not happy with the extremely verbose SSMS auto documentation creation utilities, such as SQL Doc, so I decided to create my own that outputs text that can generate an html file and to have more control of what is included. Thi...
Using AdventureWorks, if we look at these two equivalent queries:
SELECT OrderDate FROM Sales.SalesOrderHeader
WHERE DATEDIFF(month,OrderDate,GETDATE()) BETWEEN 1 AND 7;
SELECT OrderDate FROM Sales.SalesOrderHeader
WHERE OrderDate >= DATEADD(MONTH, -7, GETDATE())
AND OrderDate <= DATEADD(MONT...
hahahahahaha. i didnt mean to make you think i disagreed with you on that, i just wanted to know your thoughts. people hear "social justice" and most seem to think, "hey - that's a good thing because i want justice for the social"
without actually thinking through the logical conclusion(s).
Still, my comment was there 6 minutes later. It's been a year and a half and (a) I'm still the only person who down-voted (b) it hasn't been corrected and (c) someone up-voted. Though maybe (c) happened in the grace period too.
There was a horrific account from ... I want to MN last year. Person had a big log tumbling around and decided to use their leg to kick it down further into the bin... This was one of those industrial grade ones and there was nothing left
The gruesomeness of that sequence of events is burned deeply into my brain for "things I don't want to see ever"