Sean Lange (7/11/2012)

---

Hard to tell for sure without ddl, sample data and desired output but I think this is pretty much the same thing...

Something like this perhaps?

INSERT INTO dbo.ProdHistMaster

(...

Are you looking for something like this? Please note that you can't put my query in a view and pass it a parameter, but an inline table valued function...

ScottPletcher (7/11/2012)

---

Lynn Pettis (7/11/2012)

---

Matt Miller (#4) (7/11/2012)

---

Lynn Pettis (7/11/2012)

---

This works as well:

CREATE TABLE [dbo].[TEST1](

[ID] [VARCHAR](10) NULL,

[VALUE] [int] NULL

);

GO

INSERT INTO dbo.TEST1 (ID, VALUE) SELECT 1, 10;

SELECT 'PRE' LABEL1, * FROM dbo.TEST1;

DECLARE...

That's okay, but the links don't seem to work where I am. Not getting...

I don't see an INSERT inside the while loop.

May be blind. 😎

Matt Miller (#4) (7/11/2012)

---

Lynn Pettis (7/11/2012)

---

This works as well:

CREATE TABLE [dbo].[TEST1](

[ID] [VARCHAR](10) NULL,

[VALUE] [int] NULL

);

GO

INSERT INTO dbo.TEST1 (ID, VALUE) SELECT 1, 10;

SELECT 'PRE' LABEL1, * FROM dbo.TEST1;

DECLARE @SAVE1 INT;

UPDATE dbo.TEST1...

Besides understanding the datatypes, particularly for BV.DischargeDateTime and BV.ServiceDateTime, you should look at modifying how you do your range testing for datetime values.

You really should move to a process that...

This works as well:

CREATE TABLE [dbo].[TEST1](

[ID] [VARCHAR](10) NULL,

[VALUE] [int] NULL

);

GO

INSERT INTO dbo.TEST1 (ID, VALUE) SELECT 1, 10;

SELECT 'PRE' LABEL1, * FROM dbo.TEST1;

DECLARE @SAVE1 INT;

UPDATE dbo.TEST1 SET

@SAVE1...

A small example of the overall problem may help with understanding.

Looks like the draft is on 9/2/2012 at 5:00 PM MDT.

ScottPletcher (7/11/2012)

---

Lynn Pettis (7/11/2012)

---

ScottPletcher (7/11/2012)

---

gerard-593414 (7/11/2012)

---

I have a table which holds the next Invoice Number. What SP code should I use to increment it (Cant be self incrementing)

There are...

ScottPletcher (7/11/2012)

---

gerard-593414 (7/11/2012)

---

I have a table which holds the next Invoice Number. What SP code should I use to increment it (Cant be self incrementing)

There are numerous users and...

Are these date/time values stored as character strings or as date/time values in a columns defined datetime or datetime2?

I think this might help:

http://msdn.microsoft.com/en-us/library/ms187997.aspx

Brandie Tarvin (7/11/2012)

---

Lowell, Ah. Interesting. I didn't think about it that way.

FYI: Please don't think I was saying "it's bad to use sys.columns." I was just genuinely curious why people...