ben.brugman (8/2/2016)

---

The static tables are the result of the import. And this is not the end and it is not a dead end. Offcourse there must be columns which contain...

ChrisM@Work (8/2/2016)

---

Sergiy (8/1/2016)

---

Dates do not have format...

ben.brugman (8/1/2016)

---

From this I understood that on the first off April the data should change.

So '20160331' would become 2013-04-01 (Two years and something,...

John Mitchell-245523 (7/21/2016)

---

Yes! I like that. I think I prefer going with explicit dates rather than integers - it makes it easier to see at a glance what...

Dates do not have format stored in...

Which particular value from t2 you're assigning to each...

Mark W Johnson (3/9/2011)

---

krowley (3/9/2011)

---

When you don't know if a feature will really meet the needs of your users because they don't really know what they want themselves, it just...

Can you be more specific about the term "completely different logic"?

Are the tables at least the same for those different logics?

1. The CSV fields are not known at design time, they are not known at the...

ben.brugman (7/21/2016)

---

How do you handle EOL within fields? (Or a bit less dramatic: How do you handle delimiters within a field.)

Especially handling the EOL within fields is a bit problematic,...

I guess there is no point of getting rid of the cursor.

You may mark a payment "Paid" only after the payment has been actually made.

And I bet the payments are...

Paul Giles-Randall (7/25/2016)

---

What I need to replicate is the following:

The cursor, is holding a running total, when this running total goes over 20, then, as in the example above i...

calvin_wk_wong (7/24/2016)

---

pietlinden (7/24/2016)

---

What are N1...N7? Are they the number of days to add to a date?

Maybe this article will help... should be required reading.

Forum Etiquette: How to post data/code on...

Is ApproverID a unique key in table [Navision].[dbo].[Radia Inc PS - LIVE$Approval Entry] ?

Here is the scrit to illustrate the point:

USE tempdb

CREATE TABLE #TableA (

ID INT IDENTITY(1,1),

Name NVARCHAR(50),

PRIMARY KEY (id),

)

CREATE TABLE #TableB (

REfID INT ,

Reference NVARCHAR(50),

FOREIGN KEY (RefID) REFERENCES #TableA (id)

)

DECLARE @Lastid INT,...