MS SQL Server 2005

71K

Solutions

27

Articles & Videos

23K

Contributors

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Refine results

How to restrict the returned result set to 100 rows in TSQL?

10 views
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Okay, so I have this query, with a case statement:

                        (CODE)

For some reason its repeating the value for the first case twice:

 Case 1 - 23
Case 2 - 23

instead of

 Case 1 - 23
Case…

225 views

I want to list all the orders whose amounts are greater than $500.00 and order them by date. Need help

1422 views

Hi All,

I have below query :

UPDATE A
                  SET A.LeaveStatusId = 'L0'
                 , LateInAfterTolerance = ?
                  , A.LateInWork = 1
                  FROM TH…

1031 views

Hi Experts,

I'm in middle designing a SQL dynamically by code and need a way to

1- Proper construct the SQL
2- To have it done in a clear manner

here is an extract of the statement.

 …

1423 views

Guys I have a problem with SqlConnection at this code and I cant find whats missing


using System.Data.SqlClient
    (CODE)
so anyone help;

5123 views

Hi,

How would I grant create and alter table to a role in SQL Server 2005?  The development team wish to use the Entity Framework in their application and this requires that role has the create and…

915 views

I have the 3 following Zip Codes in my file

76012
75130-6789
76015-3211

Per the flat file spec's from my client, I have to return 9 characters and not use the hyphen that separates the Left 5 …

217 views

I need to read a Tablea, then add those records (10  varchar)  into a existing SSRS report parameter (@Temp) before I process that parameter in the Stored Procedure. The parameter will already have ch…

1129 views

I'm trying to create an aggregate table using the combination of two others.

Feed Table A:

(CODE)

Expected Result (Table B):

(CODE)

In record 1, 80 is the most recent record, 75 is the …

2447 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

I need  to display data in text field   to update all information i need from the table.
 when i tried to do it the error message  " Column named id cannot be found.
Parameter name: columnName"

630 views

We have a current SQL query which summarizes the hours worked by a particular branches staff.  Rather then running this report every month I would like to create a new report which automatically calcu…

528 views

Hi Experts,

I need some modification to the following posts answer.
https://www.experts-exchange.com/questions/28984589/How-to-place-a-condition-in-a-filter-criteria-in-t-sql.html?anchor=a41896938…

1021 views

Hi Experts,

I'm building a dynamic sql string and looking for the following.

Lets say there are two fields a text field (varchar 1000) and a date field.

Now I would like to filter for a date …

1236 views

hi,

right now I have a procedure that we need to execute a script against a DB, then it will output a script, then we need to run that output script again the same DB,

in SQL job, what is the s…

72101 views

Sample data-

CREATE TABLE #emp_records
(
 Id INT,
 Name VARCHAR(80),
 Salary NUMERIC(8, 2)
)
GO
 
INSERT INTO #emp_records
(Id, Name, Salary)
VALUES(1, 'A', 7000),
(2, 'B', 30000),
(3, …

427 views

Hi Experts,

Lets say I have a variable called MySTR and has the following value 'A very long string, testing the string'
since the word string is duplicate I would like to eliminate it, and just g…

3044 views

Introduction
This article is very old, and while most of its principles are sound, PHP programming has changed a lot in the last decade.  For that reason, I've updated this information in another art…

726,319 views

I am using Microsoft SQL Server 2005. I need to know the most recent date/time  when each table was last opened. Is there a utility or query that can provide this information ?

730 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

I've got a Microsoft CRM database that I need to work with in order to prep for a data conversion to our new internal software.

However, this database is 40GB and it's problematic for me to get fre…

729 views

Hi

i am trying to create stored procedure but getting syntax error and dont know what am i doing wrong,

(CODE)
please assist me

734 views

Hi experts

i have execute this code
USE master;
ALTER DATABASE ConfidentialDB
SET ENCRYPTION ON;

whats the mean?
i execute this select
SELECT * FROM ConfidentialDB.dbo.SecretKeys
i can vie…

145 views

I have a detail table with order information and I use a query with group by to rollup the details into summary lines by customer. The key here is that the SUB_GROUP_KEY is the

(CODE)

The detai…

930 views

Hi, I have a Datawarehouse  SQL job . Basically the job will populate our Datawarehouse overnight. one of the steps in the job will delete all the  data in the datawarehouse overnight and reload
the …

6390 views

Full disclosure - I am very nearly a total SQL newbie.

I am trying to follow work instructions put together by our previous DBA to build a SQL 2012 server. I have the server in place and have follo…

876 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,711)
  2. MS SQL Server 2008
    (48,768)
  3. Query Syntax
    (47,304)
  4. Databases
    (53,501)
  5. .NET Programming
    (131,569)
  6. ASP.NET
    (123,037)
  7. SSRS
    (8,705)
  8. Windows Server 2003
    (128,510)
  9. DB Reporting Tools
    (8,006)
  10. Visual Basic.NET
    (91,887)