cbrammer1219 (6/15/2015)

---

This is exactly how the data is stored, that is why I am having so much trouble pulling the correct data. This data comes from a Unix system and...

cbrammer1219 (6/14/2015)

---

Here is the table structure and attached is the data.

USE [dsg]

GO

/****** Object: Table [dbo].[DICE_APDH] Script Date: 6/14/2015 3:44:42 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING...

rc_stone_1 (6/15/2015)

---

I am writing dynamic sql to create a work table. I would like to format my create script such that the data types are all lined up, rather...

syed_3177 (6/14/2015)

---

I have a right join query where i have a table where all employees attendence entry are registered and another table where pay master table.

I need a query where...

It's not a direct relationship. Take a close look at the following...

Take a close look at the CONVERT function in Books Online (aka BOL). It can handle most date formats, and if you have to, you can always use...

Why don't they just use SSIS ? Even the import/export wizard in SSMS might be a better choice. I suspect a registry permissions issue, but I...

tcronin 95651 (5/19/2015)

---

Since Idera was nice enough to kill user forum, looking for some comparison of other DBA's who have an EMC san. Seeing some alarming The operating...

Given that CXPACKET waits was larger than the other waits, thought I'd go looking for good info, and found some from a really good source:

http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/%5B/url%5D

Read it, and toward the end,...

Generally, when you install software, the "hidden" stuff is what goes into the registry. If the D: drive didn't contain the operating system, then as long as the...

Sorry, here's the forum link:

http://www.sqlservercentral.com/Forums/Forum2800-1.aspx

It's titled SQL 12.

Ernest Libertucci (6/11/2015)

---

No forum for SQL 2016, so I do apologize for posting this here. However, I can't find documentation for the R-Integration features. Could anyone point me in the...

Then just add HAVING COUNT(*) > 1 just after your GROUP BY and you will see only those months that have more than one record contribute....

If a stored procedure is a single query, then the basic answer is no. However, that doesn't mean that what the query accesses might not be able to create...

It doesn't change two rather important things:

1.) The @CUSTOMER_O_id is still always going to be equal to @MANAGER_O_id, regardless of which record of the query you are processing.

2.) You still...