MS SQL Server

155K

Solutions

174

Articles & Videos

43K

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.

Refine results

I have a table in SQL Server with a number of fields, i have created a composite PK of LoanNumber, BorrowerName, LenderNumber; I need to compare a new data set that contains these and other fields to …

823 views
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

I am working with a Microsoft Access Database.  There is a table which contains a column called 'City'.  This column contains the City, State and Zip in a comma delimited format.  I would like to writ…

79 views

After copying a database and security information to a new server, I'm trying to map a user ('UserX') to a database in SQL.  However, when attempting to save, I get an error message: User, group, or r…

30 views

Need to combine these two queries:

(CODE)

and

(CODE)

530 views

I need to delete duplicate data
i.e. if i have 2 rows exactly the same, delete one of the rows

I have a table called Tbl_Data
It has these columns

ID
GPSDateTime (datetime)
ReportID (int)

312 views

When I execute the following stored procedure in SQL Server 2008, I get the error

Msg 102, Level 15, State 1, Procedure proc_CSL_AutoDetStop, Line 7
Incorrect syntax near '='.

Do you know how …

212 views

How do I resolve the following error using SQL Server 2008?

dtCreated has a data type of datetime and has a value such as "2009-08-03 00:00:00.000"

Msg 1023, Level 15, State 1, Procedure proc_CS…

116 views

I hope you can deduce what i am asking from the excel spreadsheet
it has 3 tables listed and the desired results.  I don't know how to write this query.

the problem area is the gallons table.  
 …

726 views

Question about Sql users.  I have a sql user that is added in the security section of the actual database.  I have the same user located in the instance level of security.  I deleted the user at the i…

19 views

I have the following substring issue..and not working for me


So the DiscussionTypeNumber has a prefix of 3 characters that needs to be removed to join to the c.nid value.
The DiscussionTypeNumbe…

910 views
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

sql server 2008 r2

I have an id_column that is varchar(50)

I have this query where I'm trying to pullout data in sequence piece by piece. into a text file.

[code][/
SELECT [Id_Column]
     …

413 views

I am trying to update the table. where I have following columns:
folioNo,pgPos,PgName,

folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…

526 views

I have deployed a SSIS package on my sql server 2012 integration service. its in my production environment and to execute the package I do not see the option of right clicking on the package and execu…

312 views

Hi,
We have SQL Server 2012 and a database has few tables that have different Collation then Temp db.

Is there any way that collation changes can be down without or minimum downtime? Data in the t…

1023 views

Hi Experts, We have upgraded SQL Server 2014 Alwayson and we are getting issues on cluster sudden failures. the cluster fail-over happening suddenly and getting resolved automatically after sometime. …

919 views

Hi all,

from time to time our TEST DB will reported to have data lost from users/tester, e.g. they enter the data yesterday or hours ago and it gone.

I found out sth like if the tempdb has conte…

2360 views

Hello

I have a stored procedure in sql server 2012 which I pass in a comma separated value, loop it and update a table...all good.

but now I have 2 lists to handle now which they need to be pair…

1212 views

Lets say I have one table. with n number of columns.

I would like to create a new table that made a new row for each column name and the value of that row would be the value from that column

So …

2114 views

Hello:

Yes, I have twelve files embedded.  And, yes, once again I'm having trouble with very simple T-SQL syntax.

A lot of the files that I have attached are for background purposes.  What I'm h…

1538 views
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Sql 2K8
See attachments for tables

Problem: How to query to show bonus when sales exceed tier level for each year

Thanks much!

1818 views

Don't know what happened with my computer.  I had issues with Visual Studio and SQL Server.  I reinstalled VIsual Studio and that resolved that issue.  I repaired SQL Server but i'm still having and i…

66 views

Hi,

I am installing SCCM2012 on Windows 2012 server, during the installation when I have to define the SQL server name and DB name, if I choose our SQL server which is running SQL 2014 on a separa…

1926 views

ACT! system requirements state it is certifies for 2008 & 2012, it also mentions "other versions". Can anyone confirm if ACT! v16.2 runs without problems on SQL 2014?

912 views

I want to create a stored procedure with the following script below. Reason being I want schedule this procedure as a job. How can I do this?

(CODE)

836 views

When doing a query on a table with multiple indexes how can i know which one SQL is using?

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server 2005
    (71,384)
  2. MS SQL Server 2008
    (48,409)
  3. Query Syntax
    (47,078)
  4. Databases
    (53,323)
  5. .NET Programming
    (131,253)
  6. MS Access
    (214,891)
  7. MS Development-Other
    (47,908)
  8. ASP.NET
    (122,810)
  9. SSRS
    (8,613)
  10. Visual Basic.NET
    (91,585)