Questions tagged as 'sql-server-2005'

Tagged questions
2
answers

Iterative query with permissions

I have two tables jerarquia and permisos , where hierarchy has an ID, a ID_PADRE (pointing to the same table to a parent node) and a DESCRIPTION of the node itself. The permissions table has an ID_OPERATOR (id of the user that is lo...
asked by 04.08.2017 / 16:14
1
answer

Calculate distance between two points

in Sql server 2008 it was very simple for me to get the distance between two latitude and longitude points, but now I am occupying Sql server 2005 and the data type geography apparently does not exist ... I do this: DECLARE @source geog...
asked by 27.10.2016 / 17:43
2
answers

Create Stored Procedure to fill a table

I have a mobile application that calls different services that I have in c# with Wcf . The issue is that I have one of those services in which the user from the mobile sends an object called Medicion . This object has a list o...
asked by 09.11.2016 / 23:33
3
answers

SELECT between two dates

I am trying to do a SELECT that brings me all the records that are between two dates. However, I want to ignore the time (hours, minutes, seconds, etc ...). For example, I have a record that has 2016-11-14 11:47:56.207 , but I send...
asked by 15.11.2016 / 16:43
2
answers

Error in dates in laravel 5.5 and SQLServer

Inserting any date in laravel 5.5 into a SQLserver database gives me the following error: SQLSTATE[22003]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server] Error de desbordamiento aritmético al convertir expression al tipo de datos datet...
asked by 24.10.2017 / 18:45
0
answers

How to change from sql server 2005 to 2008 and from collection

I am migrating my database that is located in Sql server 2005 with collection SQL_Latin1_General_CP850_CI_AS and I want to migrate it to Sql server 2008 R2 with collection SQL_Latin1_General_Pref_CP850_CI_AS, when I change the collection in prop...
asked by 29.10.2018 / 15:34
1
answer

Dynamic parameters in Reporting Services

I am currently generating a report using the SWL Server Business Intelligence Development Studio 2005 since it is the reporting version used by my client. Your request is a report with 2 filters, one per region, and another one for stores, bu...
asked by 01.03.2017 / 18:12
1
answer

Use the ORDER BY in a select with ROLLUP

I have a Stored procedure that brings me the following information: Zone (used as a grouper in the rollup) Store Received Orders Accepted Orders Denied Orders Percentage of acceptance This information, my user wants to con...
asked by 06.02.2018 / 19:44
1
answer

The texts in my database are closed [closed]

I have a database in SQLServer 2005, and a couple of months ago in 2 tables we started to cut some records in a random way, I mean. If in a field before it said "hello world", nowadays it says "hello mu" or "hol". The strangest thing is that...
asked by 26.05.2017 / 22:37
0
answers

Instances of sql server 2005

Please forgive help with this If I have an instance with several tables and it is damaged, well and create another instance to be able to create a new database that I need and that I can not access by the damaged instance as I try to resto...
asked by 17.04.2017 / 16:36