drew.allen (4/4/2016)

---

Eirikur Eiriksson (4/4/2016)

---

Here is a quick suggestion towards a solution, let us know if you need more assistance.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @XQUERY_STR NVARCHAR(MAX) = N'';

DECLARE @PARAM_STR NVARCHAR(MAX) =...

Jeff Moden (4/4/2016)

---

If all the rows were identical, then stats will only have...

Brandie Tarvin (4/4/2016)

---

At 11:55 p.m., my boss asked me if there was anything else he could do. At that point it was a one person job which I was working...

Quick question,...

TheSQLGuru (4/4/2016)

---

First and by FAR the most important let me say that this should be done OUTSIDE of SQL Server (unless you are going to be using the set in...

Here is a quick suggestion towards a solution, let us know if you need more assistance.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @XQUERY_STR NVARCHAR(MAX) = N'';

DECLARE @PARAM_STR NVARCHAR(MAX) = N'@TXML1 XML';

DECLARE @TXML1...

JKSQL (3/30/2016)

---

I have created code similar to below. This is slow since this is a very large table. Is there a way to make this into one call?

UPDATE...

Sachin Nandanwar (3/31/2016)

---

Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It can be...

WhiteLotus (3/29/2016)

---

Hi All ,

I have just moved the databases from 1 server to another server (I performed Attach detach method for user databases )

When I checked in SQL error log...

Alan.B (3/25/2016)

---

Anyone want to take a stab at this. Essentially the OP needs a csv splitter that handles text qualifiers; Eirikur Eiriksson's RFC-4180 compliant splitter from this article: This article[/url]...

Hugo Kornelis (3/29/2016)

---

Eirikur Eiriksson (3/29/2016)

---

Quick thought, the first (union) query will use two index seek operators (if the correct indices are in place) while the latter does a single scan....

Quick thought, the first (union) query will use two index seek operators (if the correct indices are in place) while the latter does a single scan. If the cardinality of...

Few ways of doing this and one is replacing the apostrophes with double apostrophes.

😎

Quick sample and quick correction on Drew's code.

DECLARE @Cleintslist TABLE

(

Cust_id INT IDENTITY(1,1)...

drew.allen (3/29/2016)

---

Eirikur Eiriksson (3/29/2016)

---

Quick thought, there is no need for the subquery as this can written as a normal query

😎

SELECT

C.cust_id

,C.cust_name

...

Quick thought, there is no need for the subquery as this can written as a normal query

😎

SELECT

C.cust_id

,C.cust_name

,C.cust_state

...