dustinprevatt (6/20/2012)

---

Here is the query I am working with.

select *

from table where cast (postdate AS int(128)) between ({fn Curdate()}) and ({fn Curdate()}) + ({fn minute(1439)})

I originally had this

select *

from table...

I thought I'd look at the resource database on one of our development servers, it is only 60.5 MB (63,438,848 bytes) in size.

For it to be 69GB seems really...

We need to see how the data is related between the two tables to be able to help you.

If you have Jeff's split function, this works:

DECLARE @TestStr VARCHAR(128);

SET @TestStr = '/DBNAME/TEST DATA/PRODUCTION_CONTROL ';

SELECT * FROM dbo.DelimitedSplit8K(@TestStr,'/') WHERE ItemNumber = 3;

Jeff's function if you don't:

USE [Sandbox]

GO

/****** Object: UserDefinedFunction...

If you used the url /url ifcode short...

krypto69 (6/19/2012)

---

Lets say the power...

CELKO (6/17/2012)

---

SQL programmers do not use local temp tables. This is how COBOL mimic scratch tapes. We use derived tables AND CTEs so the optimizer can work.

Floating point math...

The witness, by the way, has nothing to do with transferring transactions. It sole purpose in life is to automate the failover from the principal to mirror database.

krypto69 (6/19/2012)

---

Maybe then I'm doing something incorrectly..

I have...

Well, with no details from which to work, here is a shot in the dark.

WITH basedata AS (

SELECT

ROW_NUMBER() OVER (PARTITION BY ProductID ORDER BY ReceiptDate DESC)...

krypto69 (6/19/2012)

---

Okay..

I'm stuck with using...

Or this.

DECLARE @TestStr VARCHAR(20),

@CharToFind CHAR(1);

SET @TestStr = 'This is a string';

SET @CharToFind = ' ';

WITH

e1(n) AS (SELECT 1...

This is something that may be better handled in an application of perhaps a CLR aggregate function of some sort.

Reminds me of something used for packaging parts, looking for the...

If I may, what is the business case for this? I don't understand why you would be looking for a set of unrelated items whose sum(quantity) = aconstantvalue.

hi2u (6/19/2012)

---

Hello,

Create a table with an Identity column, insert data / restart the server / insert more data / restart the server/ insert some more data.

My data looks like...