Would you need something like this?

CREATE TABLE dbo.TimeFrames(

StartDate date,

EndDate date

);

INSERT INTO dbo.TimeFrames

VALUES

('4...

A simple CAST seems to work.

(DT_DATE)"Sep 14 2015 10:14PM"

It would be easier if you tell us what you're doing. You could certainly execute a stored procedure for each row or you could tell us what are you trying...

Manic Star (9/23/2015)

---

patricklambin (9/23/2015)

---

I don't think so. These functions have been introduced only to make easier the translation...

mw112009 (9/23/2015)

---

Thanks

Ahh.. but you still have to manually go and replace every single quote with a double single quote.

I was thinking whether there was a way to get around that...

You can't blame me if you use a different query than the one I posted. You keep joining the CTE to the table with no valid reason. You're basically assigning...

Duplicate post. All replies should go to the following thread: http://www.sqlservercentral.com/Forums/Topic1721931-2799-1.aspx

Do you need something like this?

WITH History_CTE

AS

(

SELECT loanID,

HistoryCounter,

DENSE_RANK() OVER...

You can use CHARINDEX and SUBSTRING to achieve this.

Give it a try and post it. If you still have problems we can give you a hand.

I was just trying to prove a point. My option is very similar to yours but with the simple way to speed things up as validation isn't needed because the...

It seems that you need to review the way you create the primary key.

Here's an example on the failure and a possible workaround.

You mentioned you're using long data types, which...

There are 2 issues here:

Joins in general can generate duplicate rows which might affect the count. If you remove any join it could reduce the row count.

Inner joins can reduce...

Check this thread for large implementations of SQL databases.

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

You'll realize is not about size, it's about purpose.

Ben,

I agree completely with you in the sense that there's no way to define a first or last row without an ORDER BY. Rows in a table aren't organized in...

I believe that the leading zero is correct and missing the zero is incorrect. That coming from the article shared by Jason.