D-SQL (9/12/2012)

---

Thank you that worked perfectly and now of course, the requirement changes a little. I have been asked where this Expected_Close = 8) is in the where clause.

Could...

Possinator (9/12/2012)

---

Lowell (9/12/2012)

---

personally, since you have integers, i'd stick with using the dATEADD() functions:

/*

2012-02-01 00:00:00.000

2012-03-01 00:00:00.000

2012-04-01 00:00:00.000

*/

CREATE TABLE PS_TestForOnline

(

DAY_ INT,

MONTH_ INT,

YEAR_ INT

);

INSERT INTO PS_TestForOnline

VALUES(1,1,2012);

INSERT INTO PS_TestForOnline

VALUES(1,2,2012);

INSERT INTO...

A little more information. The date '1900-01-01 00:00:00.000' is sometimes referred to as the 0 (zero) date. If you run select cast(0 as datetime) you will return '1900-01-01'....

LoosinMaMind (9/12/2012)

---

Cool !!!

That the sort of thing i need as it going into a Business Intelligence system where users have to query aginst dates.

However, your dates come out as the...

Lowell is right, though as you should use the DATE data type, not a character string, especially if you are comparing or storing dates.

Easy.

CREATE TABLE PS_TestForOnline

(

DAYNBR INT,

MONTHNBR INT,

YEARNBR INT

);

INSERT INTO PS_TestForOnline

VALUES(1,1,2012);

INSERT INTO PS_TestForOnline

VALUES(1,2,2012);

INSERT INTO PS_TestForOnline

VALUES(1,3,2012);

SELECT *, right('0' + cast(DAYNBR as varchar), 2) + '-' + right('0' + cast(MONTHNBR as varchar),...

ariel_mlk (9/12/2012)

---

I agree. Believe it or not, a While loop that does the same thing as the rCTE will work at least as fast and sometimes faster and with a...

Decided to do some looking. Not sure, but maybe all you need is a semicolon.

DECLARE @sql NVARCHAR(4000)

SET @sql = 'SELECT * FROM OPENQUERY(OraSvr,''SELECT

...

If you can, could you post what you did here? It could prove useful to others with a similar task.

Here is my guess based on experiences at Progressive. SQL Server is preallocating space for the backup and estimates how much space it needs. Apparently, and this is...

ORA-00933: SQL command not properly ended

Cause: The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or...

jasona.work (9/12/2012)

---

Have you considered using Powershell? I'm presuming you have it on the server, so you could craft a Powershell script to grab the file(s), then unzip them. ...

Give this a try for a starter.

SELECT

tblObject_1.Name AS Agent,

COUNT(tblLoan.Object_ID) AS Count,

SUM(tblProcessingFile.LoanAmount_MIP_FF) AS Volume

FROM

tblLoan

...

Here is one place to start:

http://databases.about.com/od/specificproducts/a/acid.htm

Give this a try:

Alter proc [dbo].[InvoiceDisplayTest] (

@InvoiceNumber nvarchar(50),

@InvoiceDate datetime ,

@InvoiceDate1 datetime,

@AccountNumber nvarchar(50),

...