ScottPletcher (8/29/2014)

---

amns (8/29/2014)

Instead of a datetime, if I cast a string with format 'yyyy-MM-dd',

will this cast always result in the correct date regardless the collation or other server parameters? (considering...

If I understand you correctly this should be quite easy.

I understood that you want to have second detail row for val5 for each detail row. If this is correct then...

jkurzner (8/24/2014)

---

Thanks. I think there is a server process that accessed the file to do some cleaning and then send out the emails. I killed the process, but...

arnold-491793 (6/9/2014)

---

Hi,

I am having a problem in creating query for this exciting scenario.

Table A

ID ItemQtyCreatedDatetime

W001 CB112014-06-03 20:30:48.000

W002 CB112014-06-04 01:30:48.000

Table B

IDItemQtyCreatedDatetime

A001 CB112014-06-03 19:05:48.000

A002 CB112014-06-03...

yuvipoy (5/13/2014)

---

Do the table will get fragmentation often in GUID?

I checked the table with the fragmentation so i ran the dbcc dbreindex (we can ran the alter command also but...

I split file with 7 zip to smaller peaces and move them with multiple xcopy commands over rdp session.

This way I am able to continue if connection drops.

Paul White (5/12/2014)

---

Ville-Pekka Vahteala (5/12/2014)

---

I remember reading blog post or article about calculating running total so that you needed to fetch only the last row. It involved some extra column...

I remember reading blog post or article about calculating running total so that you needed to fetch only the last row. It involved some extra column for referential integrity. I...

At the moment I've got dual 21, but wanting triple. Normally I got at least 3 rdp sessions to servers.

What happens if You change variable declaration to

Declare @BeginDt as bigint = 20140101

Declare @EndDt as bigint = 20140430

Declare @LotNo as nvarchar(15) = N' 000000113855'

and execute query after the change. Especially...

Brandie Tarvin (4/25/2014)

---

The misconception would be mine, then. This is sample code supplied to me by the vendor receiving the file. It seems pretty generic and the person who gave...

SQLBill (4/8/2014)

---

Jack Corbett (4/6/2014)

---

So on Thursday I was asked to help analyze a batch process for a third-party product that originally took 2 hours and is now 19+...

GilaMonster (4/2/2014)

---

Ok......

Guideline for python code:

"Explicit is better than implicit"

I can agree with that, it's something I argue for when teaching T-SQL. Be explicit.

Then, from the style guide for python:

Bad form:

if...

Following query does the job, however it is not very efficient because it will not use spatial index.

select geom from tablea as source where exists (select * from tablea...

TomThomson (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these pieces of sh code...