Microsoft SQL Server 2005

71K

Solutions

27

Articles & Videos

25K

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.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. ASP.NET
  7. SSRS
  8. Windows Server 2003
  9. DB Reporting Tools
  10. Visual Basic.NET
Refine results

hi there
i have table that hold moves for customer like in the bank
there is withdrawal and deposit this is sample :
from start date : 01/01/2017 to 15/01/2017

MID      MDATE     CID    SUM  …

813 views
Webinar: Aligning, Automating, Winning
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Hello guys,

I have a table where there is a field datetime, this field is indexed.
What is the better way to filter by date?

Currently, I have a query that is written this way:

(CODE)

525 views

hi experts

i need denied (Avoid impersonation)
execute as login
and
execute as user

which T-SQL?

1331 views

hello EE,

please look at this image and the way I retrive the results.

the select looks like this :

(CODE)

my problem is that the results are not in 1 line. i would like 1 line for each …

718 views

hi experts

i am reading about What Is an Error?
but i do not understand State
this is definition:
State is defined by the author of the code that raised the error. For example, if I was writing …

227 views

hi experts

i am reading about Database Mail Profiles

In which cases should you use a public or private profile?

Profiles can be private or public. Private profiles are strictly controlled and…

122 views

hi experts

i am reading about. Applying Roles in Common Scenarios
whats the mean
"As an abstraction layer: When details of users are not known—for example, during development"

319 views

This is SQL 2016 Developer.

This works (SQL at the end) but you see how I get the data in columns. Is there anyway to get them in rows?

So, I have paragraphNum1,paragraph1,  …

422 views

This is SQL 2016 Developer

I've been getting help from two experts: Ryan and Husayn so thanks for that.

This brings back 33 rows which is correct. but when I add a "Cross Apply", it brings back …

439 views

Hello,
can you please help,
I need one statement instead of below 2 and get one value for each,
right now, I get 2 value for each operator.

Select Operator AS [Operator],Convert (Varchar(11), …

425 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

This is SQL 2016 developer.

This is a long XML but please run it. You see column "subchapter". There are 4 "subchapters" but they're all lumped together in this one column.

1. How can I get 4 …

1130 views

This is SQL 2016 Developer

I got this solution from an expert but column "SectionNoteNotCorrect" doesn't get the values for all the sections --> row 2 and 4 are null.

I added another line to …

331 views

I have records where:

COMPANY NAME          PART NUMBER             MFG CODE                  CAPABILITY CODE
 Acme LLC                             A123                          1234A                         BC…

647 views

This is SQL Server 2016 Developer edition

I have this example. I know why I only get the first nodes data. It's because I use section[1]/heading[1]. How can I get the rest? I think I can do …

340 views

This is SQL 2016 Developer

I have this sample data.
1. You see "noteheading" column has this value: "Codification". This is correct
2. You see "sectionnote" column also contains the same value …

935 views

This is SQL 2016 Developer.

I have this XML. You see there are these tags:
Main
  Chapter
   Section
       num
       heading
       note

I can get the "chapter" and 'section' info. But …

328 views

This is SQL 2016 Developer.

I have an XML like this. This one works and I can get the value

(CODE)

This one doesn't work. I think I don't have the path correct

(CODE)

930 views

Hello expert,

Have built table in SQL Server Management Studio with create table statement
copied herewith below.
Now trying to get data into it from Excel spreadsheet.

So I Googled it and got…

726 views

Hi Experts,

I have an extremely large table with hundreds of fields, with many of them not in use anymore, and would like to get a list of all those unused fields, and perhaps move them to a …

1274 views
PeopleSoft Has Never Been Easier
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Hello

I need to merge three tables into one.  They all have the exact same structure.

Table_A_original
Table_A_Archive_1
Table_A_Archive_2

Then a target table new_TABLE_all

They were …

225 views

Hi Experts,

We have SQL Express 2005 and I realized our data file is almost reaching the limit (4GB).
Now my question is, how can I shrink the size of the file in order to prolong the need to …

36108 views

Hi, We are using SQL Server 2005. We have just added another table to ther transactional replication schema. Replication fails with the following error
 Cannot insert explicit value for identity …

123 views

This is SQL Developer 2016.

I found this function

(CODE)

I have this sample data

(CODE)

You see how the data is in separate rows. I want the data to be in columns. Is there a way of …

442 views

Hello

We are in the process of converting a very old system that has close to a billion records.  The system we are migrating out is old and was originally an AS400 system then in 2005 the vendor …

333 views

Is there a faster way to get a row count from a view than select count(*) from ViewName??

Migrating a massive, humongous doc management system out of SQL 2005 and need to get row counts. Almost a …

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

Microsoft SQL Server 2005

71K

Solutions

27

Articles & Videos

25K

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.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. ASP.NET