Most voted "sql-server-2005" questions
10 questions
Sort by count of
-
8
votes4
answers7856
viewsCalculate Total Hours by identifying Equal Time Intervals
after a bit of a break in the head, I ask for help from you to assist in the following situation: I have a problem with SQL (Sql Server 2005) calculation of hours; Basically I have to calculate the…
-
6
votes2
answers345
viewsSQL Server 2005 and line version control
In my current scenario, every Friday, I need to list all rows of a table that have been added or changed. In this table we have a field DataDeInclusao which obviously receives the date of inclusion…
-
4
votes3
answers3464
viewsAverage between 3 direct dates in sqlserver bank?
What is the most efficient way to calculate the average of dates in the same column by the sqlserver database? I need to take the date of the last 3 sales of a customer, and return in days to know…
sql-server sql-server-2012 sql-server-2008 sql-server-2014 sql-server-2005asked 8 years, 10 months ago Laísa Ferreira Cardoso 116 -
2
votes1
answer423
viewsError creating SQL Server 2005 database with compressed disk
When I try to create a database, the following error occurs: TITLE: Microsoft SQL Server Management Studio Express Create failed for Database 'based'. (Microsoft.SqlServer.Express.Smo) For help,…
-
2
votes3
answers92
viewsManipulate String in JAVA?
I have an appointment of SQL that the content brings me so: [email protected];[email protected] I only need the first address, I have to disregard everything from the ;?…
-
1
votes1
answer150
viewsVFP - SQLEXEC is returning DATE field as CHAR
I am supporting a "legacy" application written in VFP, which uses DBF tables and now migrating to SQL Server. I created a test table in SQL, which contains fields of some basic types, to be able to…
-
1
votes0
answers73
viewsHow to show decimal places only when they exist?
How could I make in my select the numbers appear without decimal place when they are 00 and appear decimal places when they are non-zero. Example: I have 5 numbers returning like this: 16.00 ; 10.00…
-
1
votes1
answer1533
viewsHow to convert a VARCHAR(30) FIELD WITH SPECIAL CHARACTERS TO NUMBER?
I have a seemingly simple question, but I’ve been racking my brain for a few hours, so I decided to ask for help. When executing the below query it normally executes. Select campo1, campo2 from…
-
1
votes1
answer45
viewsHow to make a select where the order "Group" is shown after "Child Groups"
As it is a system that contains registration of Product Groups. I want to know how to make a select that brings me the information in the following order inside SQL and ordering everything…
-
-1
votes1
answer29
viewsAzure connection - SQL Server 2005
I’ve been trying to connect on the Microsoft Azure database server to an application encoded in . Net Framework that is running on a windows server 2003. The problem is that only this server is…