In a way that is not too bad, we just have to figure out why;-)

😎

Now I have few...

Quick thought, is TCP/IP enabled?

😎

We all have to...

Here is the Window function version Jeff mentioned

😎

SELECT

M.ORDERNO

,ROW_NUMBER() OVER

(

...

Thank you for the timely question Vimal, XML is a topic that definitely needs more coverage, especially when the current SQL Server's capabilities provide some of the best tools for...

ado-712642 (8/14/2014)

---

Is there a different way I could do a query like this:

SELECT ID FROM PropertiesFreeholdAndCondos WHERE lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL...

rana_gman (8/15/2014)

---

Hello,

I have set the environment set for AutoRecover (for every 3 minutes and Keep information for 7 days under the SSMS 2014 Menu: Tools -> Option ->Environment -> AutoRecover).

I've...

Here is some code that does the job, not perfect though and leaves some room for improvements.

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* Staging tables */

create table dbo.tmp_management

(memberid int,

pid int,

firstname varchar(10),

lastname varchar(10),

DOB...

SQL_Surfer (8/16/2014)

---

I've a CSV file as source going to OLEDB Destination (SQL table)

Row delimiter is CRLF

Text Qualifier is "

Issue is some data value inside itself contains " to represent...

halifaxdal (8/16/2014)

---

Thanks for the discussion but I am sorry I didn't see that your reply is talking my question here:

What I am looking for is a simple query (with no...

In the old days (pre 1998) this was simple, only handful of top level domains. Today this is quite complicated and the only way is to maintain a registry of...

Koen Verbeeck (8/16/2014)

---

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as...

Evil Kraig F (8/15/2014)

---

Brandie Tarvin (8/15/2014)

---

It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one is a...

I agree, anything one can...

Ed Wagner (8/15/2014)

---

Jeff Moden (8/15/2014)

---

GilaMonster (8/15/2014)

---

Eirikur Eiriksson (8/15/2014)

---

Koen Verbeeck (8/15/2014)

---

GilaMonster (8/15/2014)

---

However OP said

I really don't like this temp table...