Charmer (6/29/2012)

---

INSERT [dbo].[CADInc] ([CADNo], [RptDttm], [District], [IncidentID], [ProductID]) VALUES (2012000001, CAST(0x00009FCC00FFD238 AS DateTime), NULL, 100040002662851, 2)

GO

INSERT [dbo].[CADInc] ([CADNo], [RptDttm], [District], [IncidentID], [ProductID]) VALUES (2012000001, CAST(0x00009FCC00FFD238 AS DateTime), NULL, 100040002662851, 2)

GO

INSERT...

Sorry, looks very similar to each other.

http://www.sqlservercentral.com/Forums/Topic1322880-391-1.aspx

I'm still having a problem understanding what you are trying to accomplish. It would help if you would provide the expected results in an unabiguous manner, meaning as a...

Charmer (6/29/2012)

---

Sorry Friends, i was not able to post my DDL and DML last night....I am sorry Lynn.....

USE [MyDB]

GO

/****** Object: Table [dbo].[CADInc] Script Date: 6/29/2012 2:04:16...

The clustered index will still not guarantee the order of the data when output via a select statement.

The only way to guarantee the order of the data is to use...

Jeff Moden (6/28/2012)

---

C# Gnu (6/28/2012)

---

Yep Lynn that looks sound.

As regards postcode validating I found an intersting post - essential reading on the subject!

It turns out there are some exceptions to...

It would help if you could provide the DDL (CREATE TABLE statement) for the table, some sample data as a series of INSERT INTO statements (sample date means just taht,...

davoscollective (6/28/2012)

---

Normally I answer these without looking up BOL first but this time I thought I'd double check.

Unfortunately this myth comes straight from the horse's mouth:

"Before you can create the...

There may be other ways to this, but based on what you provided this does work.

create table #TestData (

CloseDate date,

Volume int

);

go

insert into...

Okay, what kind of function are we talking about; scalar, inline table valued, multi-statement table valued function?

How is it being used?

Biggest problem, we can't see what you see. Anything we tell you is nothing more than a shot in the dark. When you talk about a function running,...

Since you indicate that the code works fine when run with the given input in SSMS, I would start looking at the code that is making the call to SQL...

All we are doing is taking shots in the dark. We can't see what you see. You have to set something up that at least mirrors the problem...

I think we are suffering from a language issue, english is obivously not your first language. You have post some good information but it doesn't convey what it is...