Microsoft SQL Server

158K

Solutions

187

Articles & Videos

48K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Related Topics

  1. Microsoft SQL Server 2005
  2. Microsoft SQL Server 2008
  3. Query Syntax
  4. Databases
  5. .NET Programming
  6. Microsoft Access
  7. Microsoft Development
  8. ASP.NET
  9. SSRS
  10. Visual Basic.NET
Refine results

I have this query

UPDATE Table1  
SET
      CompareFlag = 'Y'
WHERE
      (Table1.doc_id IN
      (
          SELECT Table2.doc_id
          FROM   Table2
          WHERE  (batch_id IS …

23 views
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hi.  I'm trying to set up an odbc connection from client machine (windows 7) to Sql Server (2008 r2 express) using Windows Authentication.  The only driver available is sql server with no native …

49 views

Hello experts,

I use the following query which give me the attached result.
(CODE)


I don't know why I have empty rows in the result even if  I tried with the is not null <> '' properties but…

1120 views

Hello,

I have a table, with records sorted by ID field:

ID TeamID TeamRecord
1  111          1
2  0              0
3  0              0
4  555          1
5  0              0
6  0           …

411 views

hi,

I am looking for books/resource to learn SSIS and I prefer learning SSIS of SQL server 2014/2016, please suggest:

in my list, I have:

1319 views

hi,

right now we have a task to relocate SQL 2000 (long time ago, I can't remember how to do it...) from a Windows 2000 server to Windows 2003 server so that we can apply security patch on Windows …

1833 views

Hello,

I've a function which returns comma separated values like
Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday

I've seven columns i.e. Monday to Sunday in SELECT query. I need to …

525 views

Hello:

This morning, I reviewed the SQL Server Agent of SQL Server 2016.  There are what I believe are two default database integrity jobs that come with SQL.  They are both failing, according to …

620 views

Hi All,
Can anybody correct me with the below query where the query is going wrong ?
For the below Query i need to add where clause and get based on client names. When i execute the query i am able …

819 views

I have the following data:
Value      ReadingTime      EntityID      ServicePointChannelID
0.273      2017-05-17 00:15:00.000      76058805      1
0.272      2017-05-17 00:30:00.000      76058805      1
0.274      2017-05-17 00:45:00.000      76058805…

324 views
Free eBook: Backup on AWS
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

I wanted to alter the size of a column but sql server wont let me.

the error is
(CODE)

i tried like this:(CODE)

511 views

Hi Guys,

For example i have got the data in a table like below
(CODE)

So if i query (CODE)

is it possible that i rank the search according to the search criteria so that everything which …

310 views

Hi,

I posted an almost identical question earlier but closed the question and needed to alter it, so here is a new question.

I have this query looking like this query looking like this:
(CODE)…

317 views

Hello,
Is there a way that I get all values from a column in uppercase .

Example :
TableA

Col1 Col2
abc   gh
dff     fggg

Select * from TableA

Result expected

Col1 Col2
abc   GH…

212 views

Hi EE,

I am running SQL Server 2012 HAG group, and I am trying to restore a database to it. However when I execute the command on the primary replica:

exec sp_change_users_login 'update_one', …

817 views

Dear Experts,

I would like to use an 'array' kind of variable in SQL in the following format:

(CODE)

but the above code gives error message:
Must declare the scalar variable "@ListofCCs"

515 views

Hello all,

I have several queries that have been written and copied over the years to conform with the different request.  Each query is almost the same just a different where statement.  For …

831 views

I am very new to SQL Server.
I have an existing SPROC that returns a recordset.  I would like to be able to change the order of the recordset returned from the  SPROC by passing a parameter.  The …

3439 views

Over the last few months, we've had enough deadlocks occur that when viewing event data for the extended events, the list is much too long. Viewing the properties of the Deadlock Extended Event, I see…

2365 views
Why You Need a DevOps Toolchain
Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Hello, I'm using MS SQL Server 2014.

I have data that looks like the following:

(CODE)

And I'm trying to 'collapse' the various groups which have the same values into a single row - for …

229 views

We have several SQL-based applications which sends out email alerts. But when sending to 4 or more individual recipients, it fails. Error message states: "The mail could not be sent to the recipients …

234 views

Hi Expert,

In the following report i want to see total section based count like this Total EBS Core count xyz
Expression i used =sum(cint(trim(Fields!processorecount.value)))


is_ebs      …

1011 views

Hi,

I want to group ordersales by date. I've formed this query:

(CODE)

For some reason the each instance comes in the result like below:
(CODE)

Can someone help me get it right so that I …

39 views

Hello,

I have query which specifies 'ON Job' based ob the collection date
(CODE)

Need to change the ' on job'  criteria if the A.StartDate = 23-May-2017  and A.EndDate =26-May-2017 then it …

2022 views

Hopefully the title will convey what I'm trying to do but:

Given a table similar to the following:
--------------------
| ID | Status  |
--------------------
| 1  |      1      |
| 1  |      2…

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

Microsoft SQL Server

158K

Solutions

187

Articles & Videos

48K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Related Topics

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