mar.ko (8/11/2015)

---

@pvColumnName??VARCHAR(100) = Default,??

However, I am unable to determine what is the value for Default.

Is it '' ?

Default is not permitted as a constant - below fails to parse:

WHERE t2.TABLE_TYPE...

mar.ko (8/11/2015)

---

@pvColumnName??VARCHAR(100) = Default,??

However, I am unable to determine what is the value for Default.

Is it '' ?

Default is not permitted as a constant - below fails to parse:

WHERE t2.TABLE_TYPE...

The lack of GO at the appropriate location means that the procedure would then include the statements up through the GO at the end of your code block. So...

In order to have ANY chance at splitting this string, you HAVE to have something that is consistently true across ALL rows. Some possibilities include:

1.) The 2nd slash...

Sorry, but TRY / CATCH blocks cannot, under any circumstances, go beyond the "batch". GO is a batch terminator, and there's just no getting around the fact that...

dan.tuma (8/10/2015)

---

I hope I can explain this issue I am having well enough for everyone to understand it. Here it goes:

I am trying to SELECT data based on custom groups...

mrtran0404 (8/10/2015)

---

Dear Sir,

thanks for your help i tried but not change with my database, I have trouble even in this query:

SELECT [Number], NETWORK_ID SimType_ID, Price, ROW_NUMBER () OVER (ORDER...

Scott Coleman (8/10/2015)

---

I have a colleague who seems to be a big fan of ELTLTTLTTTTL processes. It's just not enterprisey enough if there aren't multiple redundant copies of the...

yuvipoy (8/10/2015)

---

sgmunson (8/7/2015)

Just constructing such an example would require more time than I have available. There's no easy way to be sure you could cover all the possible...

Luis Cazares (8/10/2015)

---

sgmunson (8/10/2015)

---

Luis Cazares (8/10/2015)

---

sgmunson (8/10/2015)

---

Given the rather small size of the likely range of values here, any suffered performance is likely to be irrelevant, and the recursive CTE...

Sean Lange (8/10/2015)

---

sgmunson (8/10/2015)

---

mar.ko (8/10/2015)

---

Thanks Guys. I think decimal(9,2) is adequate....and it uses only 5 bytes.

The only problem :

when summing large numbers of rows....that could result in overflow if...

Alvin Ramard (8/10/2015)

---

sgmunson (8/10/2015)

---

studySQL (8/7/2015)

---

I have a data flow that brings the data from flat file (.txt) to a table but after processing few rows, it fails with this...

Luis Cazares (8/10/2015)

---

sgmunson (8/10/2015)

---

Given the rather small size of the likely range of values here, any suffered performance is likely to be irrelevant, and the recursive CTE is a lot...

thbaig (8/10/2015)

---

Yes, I have confirmed. Overall data set size in temp table is ~100k rows.

When I set offset it terminate on EndRows , but always start from 0. e.g. if...

There is a way to get the "old" behavior back - via a trace flag. If my recall is correct, it's 2453, but someone please verify. ...