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,...

So, trying to read minds here based on the posts so far, you want something like this?

begin transaction

select

*

from

Production.Product with (UPDLOCK)

where

...

I guess I am still lost on what you are trying do.

😎

mtassin (5/20/2008)

2. SQL isn't a programming language. It is a set based Data Manipulation Language, last I checked you couldn't pause a stored procedure in the middle to ask...

Actually, it came down to this, your WHERE clause would not make use of an index on the date field if available, where as the change I made would allow...