It might also help to see the code you are running to create/drop the procedure.

The problem with that is keeping the file system backups in sync with the database backups. We want to ensure if a restore is completed, all related information is...

John, My only comment regarding your explanation post (which was well done, by the way), is to NOT use between on date range queries; use >= and <. ...

That is why I posted this question, I was hoping someone else out there has run into this same issue and has some guidance instead of myself or our PeopleSoft...

Here is what I came up with, but no testing.

CREATE TABLE [dbo].[ChildAdmitRecords](

[ChildXAdmitID] [int] IDENTITY(1,1) NOT NULL,

...

Could still use some sample data and the expected output. Also, will need the lookup table as well if you want anyone to test their work.

😎

Could you post the DDL for the tables, some sample data (using inseret statements) for each table, and the expected output from each query based on the provided sample data.

😎

GSquared (5/21/2008)

---

Keep in mind that an inline function (like these) has an overhead to it. With something as simple as the dateadd version for this, you're better off including...

veenagireesha (5/21/2008)

---

Hi,

You need to work around with something like this....Find all command options available through winzip..It has password (-s) command etc...You need to use xp_cmdshell, unless you are not fan...

tony.sawyer (5/21/2008)

---

We've got a UDF called TruncDate that effective truncates the date by removing the time element from it. This mimics the TRUNC() command in Oracle.

ALTER FUNCTION TruncDate

(

@InDate DATETIME

)

RETURNS...

DBA (5/20/2008)

---

yes thank you!, i just need to figure out which one will work better with my transaction, your approach or the other one....

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

GO

BEGIN TRANSACTION

Select.....

Updates......

GSquared -- Another I use for DMing AD&D, for tracking encounters and battles, exp and loot. (How uber-nerd is that? I myself shudder when I think about it....

Is there a way by reading each row to uniquely identify what data is in each row?

😎

James Goodwin (5/20/2008)

---

I think everyone is missing the point of what is happening.

What is occuring is an automatic type conversion. If I do this:

Declare @tmp datetime

set @tmp = '20080101'

select...

mtassin (5/20/2008)

---

Lynn Pettis (5/20/2008)

---

I disagree with statement #2. SQL is a programming language. Yes, it is a Data Manipulation Language, but so is COBOL, FORTRAN, Pascal, Modula-2, Ada,...