What if you had 3 rows for the civic? Or are you just looking for the lat two rows?select max(date) , car, type from tableA group by car, typewill give you the last row for each car. From there you can transform this into a subquery to get the row.select date , car, type from tableA a where […]
2004-06-14
Let me answer the questions as presented.> are there any alternatives that would be worth thinking about?Yes, but without a more specific problem domain, theory is about all we can offer you.> could you also explain the line "GID int IDENTITY"? What does GID stand for / relate to?The simple answer is that GID stands for […]
2004-05-19
I am doing a paper for a college programming course. Does anyone know how many companies worldwide use SQL server? How many servers does this constitute? At what rate is SQL use growing? If you can't provide me with close to exact numbers, please point me to a source where I could find them
2004-05-11
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-26
Comments posted to this topic are about the Question of the Day for 01 Apr 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=216.
2004-03-31
I created a RS report that contains 2 datasets. The first dataset calls a stored procedure that populates a table. The second dataset contains a select statement that pulls from the table that is populated via the stored procedure in the first dataset. Dataset2 is the source for the report.My problem is that dataset1 correctly […]
2004-03-23
2 reads
For EBNF conventions try:http://www.garshol.priv.no/download/text/bnf.html http://cui.unige.ch/db-research/Enseignement/analyseinfo/AboutBNF.html
2004-03-23
Hi all,I have this stored proc where I need to display all the subGroups and Indicators, whether or not they have any tasks assigned to them. Basically, I have 3 tables: SubGroup (from where I need all subgroups), Indicator (I need all indicators, too), and Task. If I run the query WITHOUT the date range part, it returns […]
2004-03-22
2 reads
What wizard? How do you want to store the values. Are they numbers (some locales use comma instead of full stop as decimal separator).If you want to store the values as decimal (numeric) then convert the commas to full stops as inDECLARE @test numeric(9,2) SELECT @test = REPLACE('1,111' , ',' , '.') SELECT @test
2004-03-18
Very strange. I assume that the column 'date' not this defined like so. But the probable thing is that it has an error in the definition of the value for which these applying the sentence.
2004-02-27
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers