Viewing 15 posts - 4,141 through 4,155 (of 8,731 total)
That's possible with minor changes to the code that I posted. Based on your OP, it could look like this:
CREATE TABLE dbo.tblReps(
id int
);
INSERT INTO tblReps VALUES(1),(2),(3),(4),(5);
DECLARE
@startDate...
September 23, 2015 at 8:58 am
Would you need something like this?
CREATE TABLE dbo.TimeFrames(
StartDate date,
EndDate date
);
INSERT INTO dbo.TimeFrames
VALUES
('4...
September 23, 2015 at 8:42 am
A simple CAST seems to work.
(DT_DATE)"Sep 14 2015 10:14PM"
September 23, 2015 at 8:29 am
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...
September 23, 2015 at 8:25 am
Manic Star (9/23/2015)
patricklambin (9/23/2015)
Stewart "Arturius" Campbell (9/22/2015)
Interesting question, thanks SteveAnother of the functions copied from Excel.
I don't think so. These functions have been introduced only to make easier the translation...
September 23, 2015 at 8:00 am
mw112009 (9/23/2015)
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...
September 23, 2015 at 7:46 am
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...
September 22, 2015 at 2:28 pm
Duplicate post. All replies should go to the following thread: http://www.sqlservercentral.com/Forums/Topic1721931-2799-1.aspx
September 22, 2015 at 1:49 pm
Do you need something like this?
WITH History_CTE
AS
(
SELECT loanID,
HistoryCounter,
DENSE_RANK() OVER...
September 22, 2015 at 1:46 pm
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.
September 22, 2015 at 12:38 pm
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...
September 22, 2015 at 9:17 am
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...
September 22, 2015 at 9:03 am
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...
September 22, 2015 at 8:40 am
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.
September 22, 2015 at 8:35 am
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...
September 22, 2015 at 6:53 am
Viewing 15 posts - 4,141 through 4,155 (of 8,731 total)