clayman (5/12/2013)

---

Got it right finally. Maybe not the best solution but here's what I did. Split up both the input SSRS string and the "Paratype" strings, joined the two...

Jeff Moden (5/10/2013)

---

wolfkillj (5/7/2013)

---

Phil Parkin (5/7/2013)

---

This is probably what you meant by "I can program the loading process in another way, I know." but to remove most of the doubt...

dwilliscp (5/9/2013)

---

The only things I left out was the listing of columns and the complete name (liked server.database.dbo.table), and the WHERE includes a limit on the #delivery... "Where #Delivery.Load_From =...

mark.dungey 56406 (5/9/2013)

---

Hi All,

I have a problem trying add a element with an illegal character. I have the following SQL

SELECT

'en-GB' AS '@xml:lang',

'20120217164611.1712._3FO0ZXYQ3@GBRAPPCHL1' AS '@payloadID',

'2012-02-17T16:46:11' AS '@timestamp',

'1.2.014' AS...

Phil Parkin (5/8/2013)

---

dawnbrown243 (5/7/2013)

---

OCR means Optical character recognition, it is the mechanical or electronic conversion of scanned images of handwritten, typewritten or printed text into machine-encoded text. Some PDFs are...

avitron2020 (5/7/2013)

---

I'm looking for a SQL statement that will output 'new vs duplicate' data on a monthly bases, but I can't seem to come up SQL statement that can accomplish...

ChrisM@Work (5/8/2013)

---

curious_sqldba (5/8/2013)

---

ChrisM@Work (5/8/2013)

---

curious_sqldba (5/7/2013)

---

I have a update statement which is killing my PLE( Page Life expectancy), it is dropping from 4000 to 120. Attached is the execution plan, would...

Phil Parkin (5/7/2013)

---

This is probably what you meant by "I can program the loading process in another way, I know." but to remove most of the doubt I like to...

I came up with another solution based on the same mathematical concept as Lynn's, but I think Lynn's is more elegant:

with TestData as (

select datavalue

from (

values

(5.0000016), -- should be 5.01

(6.1000138),...

Sergiy (5/6/2013)

---

Try to run queries like this:

select * from FK_Table F

WHERE NOT EXISTS (

select * from PK_Table P

where P.PK_Column1 = F.FK_Column1 and P.PK_Column2 = F.FK_Column2

It should give you the entries...

Hugo Kornelis (5/6/2013)

---

wolfkillj (5/6/2013)

---

Good question - I appreciate the QotDs that demonstrate quirky behavior.

It bears mention that Microsoft has slated the "timestamp" syntax for deprecation in favor of "rowversion"...

You can do this with a CHECK constraint that calls a scalar function, although I suspect that this could have a significant impact on performance, especially when inserting a lot...

Kricky (5/6/2013)

---

Many times we need to rely on records being next to each other to determine next Value ordered by a Date, let's say. So, if the identity column...

Good question - I appreciate the QotDs that demonstrate quirky behavior.

It bears mention that Microsoft has slated the "timestamp" syntax for deprecation in favor of "rowversion" as of SQL...

sotn (5/3/2013)

---

thanks for the reply.

Unfortunately, I've already examined that option but we cannot really change our erp system easily, so I hoping for an easy 'timestamp' comparison rather than comparing...