mishrakanchan86 (1/9/2017)

---

Hi ALl

I have a view which looks something like below.

Select

* from T1 with(NoLock)

Inner Hash Join T2 With (NoLck) on T1.PID = T2.PID

Inner Hash Join...

ocean3300 (1/6/2017)

---

Thanks for the ideas and codes.

I have another question.

Let's say I have a string something like below:

test-asdasdasd="xxx"

If I want to replace asdasdasd="xxx" with blank ('') so that I...

You are very welcome

😎

Missing the VALUES keyword

😎

INSERT INTO LOG_RATE_MONTH(LOG_MESSAGE,LOG_DATE) VALUES('id='+@_prev,getDate());

Here is a quick solution that uses the dbo.DelimitedSplit8K function[/url]. Note that for this to work, the values cannot contain spaces!

😎

DECLARE @Text VARCHAR(256) = 'Generic="abcde" Generic="fghij" Generic="sdfsdfasdf"';

SELECT

...

Just for fun, here is a JSON based splitter, nasty fast but not fully tested, SQL Server 2016 and later.

😎

CREATE FUNCTION dbo.ITVFN_SPLIT_STRING_JSON

(

@INPUT_STRING NVARCHAR(MAX)

,@DELIMITER...

sosbgenius20 (1/5/2017)

---

Hi all.

In my office we are using MS sql server 2008r2.

We have a backup files but one of the files takes too long to be restored. Approximately it...

Can you post the accumulated business rules please?

😎

GilaMonster (1/4/2017)

---

Repost from Twitter:

Research for a blog post: What are the common forms of 'catch-all' / 'multi-parameter query' you've seen?

I've seen:

(Col = @C1 or @C1 is NULL)

Col =...

Why don't you use left outer join?

😎

VastSQL (1/3/2017)

---

Thanks Guys.

The file is uploaded to application server itself initially and then data gets inserted into multiple tables once the validation is complete. The validation checks in many tables...

JaybeeSQL (1/2/2017)

---

Hi all,

Got a bunch of date data in the wrong column, I'd like copied into a column on the same table. Here's as far as I've got:

Update...

The script doesn't have errors as such but it would possibly error on either the table name or missing schema prefix, suggest you add the table schema and use the...

I have the suspicion that this may be down to cached connection/meta data in Excel, suggest you look into clearing those.

😎

You will have to do more detailed analysis of the problem, without further information there is no way one can even start to guess where the bottleneck might be.

😎