Bill Talada (12/23/2016)

---

Strange! I've never seen anyone set a date datatype variable to an empty string. But if you do that, it immediately gets set to Jan 1,...

Here is a better way of testing for the missing date value

😎

ALTER PROCEDURE [dbo].[MyStoredProcedure]

(

@MyDate date = NULL

)

AS

BEGIN

If @MyDate IS NULL

BEGIN

SET @MyDate...

ptownbro (12/23/2016)

---

This seems like it should be simple to solve, but for some reason I can't find the answer.

We have a simple stored procedure that has one date parameter that...

You are missing the on clause for the inner join

😎

Add the ON clause after the closing parenthesis in line 85

Can you amend the sample data please?

😎

Running it returns this error

Msg 207, Level 16, State 1, Line 32

Invalid column name 'CALIBRATION_TYPE_ID'.

HappyGeek (12/21/2016)

---

Getting error on replication, log reader agent:

Log reader fails with “The process could not execute ‘sp_replcmds’ on <DB01> ” error

Needs to be sorted asap, has anyone come across this...

Here is a quick suggestion to a solution, uses the DelimitedSplit8K function, should be enough to get you over this hurdle.

The function can be found in these two articles

1) Tally...

VastSQL (12/20/2016)

---

Hi Experts,

I have a job which runs an SSIS package to fetch data from multiple tables in a database and then put it in an .csv file and then...

liorvikel (12/20/2016)

---

i have db link to oracle from mmsql

when i run localy in oracle query of select i get 4 sec result

from mssql to oracle i get 24 sec

can...

Lynn, feel free to send me any examples and problems, I'm happy to help

😎

Thanks Lynn

😎

Jeff Moden (12/18/2016)

---

You just can't believe all the examples I've been through in the last 24 hours never mind the ones I've seen over the last decade or so. I've...

The TROW statement works similar to the RAISERROR but has the severity level default of 16. Suggest you change the statement to the latter with higher severity level or even...

The XML construct within that function is sub-optimal, 23 operators in the execution plan and there of 3 XML Reader Table valued functions.

😎

This can be significantly improved by changing...

etl2016 (12/18/2016)

---

hi,

This is a classic scenario of an SP wrapped in a sqlAgent job and despite SP failing to do its job (say, loading a table), and despite setting...