Using MS SQL Server
in [Microsoft SQL Server]
|
Use of having with additional select Hello guys, i have this query: select c8.cerveh, sum(c8.monto1) monto1, (select prima from arysauto a where a.cerveh=c8.cerveh) priari, (sum(c8.monto1)-(select prima from arysauto a where a.cerveh=c8.cerveh)) dif from clpf08 c8 where c8.ramo=31 and c8.poliza=6100265 and ... 23 Apr 2008 22:07
Performance question concerning varchar(max) SQL Server 2005 Simple scenario - We want to store answers to survey questions. Some questions require very short responses (one or two words) while others require long essay type responses. --Scenario 1 -- store all answers in one column, regardless of question CREATE TABLE Answers ( AnswerID int identity ... 23 Apr 2008 14:55
using LEN to find a first word greater than 17 how do i write a sql (ORACLE) statement for where the first word in the name field is greater than 17 chars? if i do this SELECT businessname FROM tablename WHERE LEN(businessname) > 17; it will return all records when the combined length of words is greater than 17. i only want to check if the first word i... 23 Apr 2008 09:19
exporting a table with long field names to Access Hi all, I need to export a table from Ms Sql to Access. However, dts import/ export gives me an error because the field names are too long. Is there a quick way to trim the names of all fields to the 64 characters allowed by Access? Or is there a better alternative? Thanks! ... 23 Apr 2008 22:55
Job ends successfully even when it's not true Hi, we've got this problem with some particular jobs: they look as they ran correctly, but actually they didn't made it all through their duties. The problem is that this job is calling a sequence of DTS, where there is a DTS with an ActiveX control which modifies another DTS before launching: the error happens t... 24 Apr 2008 06:50
Yet another basic SQL question I have the following statement that is intended to provide the most records with the most recent status from the SAF2 table, based on dbo.SAF2_Status.ActionDate along with the corresponding record from the SAF2_Pay table. However, it is yielding more than just the most recent record....it is providing multiple sta... 22 Apr 2008 22:47
Basic SQL Question I cannot figure out why this is not working. For some reason the following statement is yielding multiple records with the same CESAFID eventhough it is supposed to be grouped. The query is intended to find the most recent record status date (GoStatusDate) and record status (GoStatus). Please help! SELECT ... 22 Apr 2008 11:36
copying data from one server to another Hi all I am trying to copy data from one database server to another. I only want to copy one table's data, not the entire database. The part that I am having trouble with is connecting from one database server and connect to another then telling it to insert into the second database server. Not sure if this i... 22 Apr 2008 09:45
FAQ & Solution: How to generate a number automatically for the Primary Key when inserting a record? When inserting a record into a table, I want SQL Server to generate a number automatically for the Primary Key. (e.g. OrderID is 1, 2, 3 and so on) How to do it? (This behavior is similar to the "Auto-number" in Microsoft Access) http://raymondlamsk.blogspot.com/2008/03/faq-ms-sql-server-how-to-generate_24.html ... 23 Apr 2008 03:33 |