TheRedneckDBA (3/19/2016)

---

I've only been in a position to interview candidates for the past few years or so, but in that short time I've been amazed at how many people I've...

As a manager for a database development team, I get falsified resumes and CVs all the time. I had to tech-screen over 30 people to fill three positions less...

I use schemas frequently.

For example, in a current ETL database, I have core functionality for all files that will be imported into the database, and then there are peripheral objects...

Simplest solution I can come up with:

SELECT

SaleID,

CustID,

SalesRepID,

SaleDate,

case when exists

(select 1

from #Sales as Sales2

where Sales2.CustID = Sales1.CustID

and Sales2.SaleDate > dateadd(day, -1, Sales1.SaleDate)

and Sales2.SaleDate < Sales1.SaleDate

and Sales2.SaleID...

I had to fix the XML by adding the necessary end tags for "set","TomAgingAlertProperties", and "properties", since those were missing from the second set of values. Judging from the...

You'll need to do it with dynamic SQL, in that case. Pretty easy to select the column names from sys.columns and go from there.

USE ProofOfConcept;

GO

CREATE TABLE dbo.T1

(ID INT IDENTITY

PRIMARY KEY,

Col1 CHAR(1) NOT...

Jeff Moden (5/21/2013)

---

Lowell (5/21/2013)

---

Jeff I've only file copied system files a couple of times when building backup machines; i know that the new server has to be the exact same...

TC-416047 (1/11/2013)

---

GSquared,

Thank you for the link. That helps alot.

The /*...*/ was put in by me because I copied that code out of a SQL trace file and did not have...

arnipetursson (1/15/2013)

---

Another valid use case is of course as input parameter to a stored proc.

Again, if i have a substantial amount of data in the table variable input parameter,

I immediately...

Snargables (1/16/2013)

---

actually. no. i shouldn't have any security issues running sql smd prompt manually. i was thinking of running it in script call or via job. I'll give that a...

Ed Wagner (1/16/2013)

---

I'm glad to see you're not going to copy and paste from Excel. I've found that when doing this, data isn't pasted it as it should be,...

The Replace() version is better than the Case version. But you should still seriously consider moving that kind of thing to the presentation layer of the application.

It depends on the exact results you want.

One way to do that is to join the two tables:

select *

from dbo.MyTable1 as T1

inner join dbo.MyTable2 as T2

on T2.DateColumn between T1.DateColumn1 and...

There are some very solid, and pretty intuitive, ways to speed up Merge.

For my cross-server ETL, I set up a bulk-copy database that just copies the source tables from the...