As a note, you comment that you were instructed to write a script that shows the CC numbers with all but the last 4 as *s. Did they intend...

I believe a...

Hm, Identity column seeded at 1000001 and then obfuscate that into the 'LB' format with a calculated column should work as well.

Are you on the same domain, or are you VPN'ing in? It sounds like the VPN is doing something strange that you don't get when you're RDC'd.

rconway-574047 (11/16/2010)

---

Sean,

I will try it from the user standpoint. The user is looking at a report that has 50 questions with a total of 500 respondents. Question 1...

Please clarify. You have SQL 2005 SSMS installed on the laptop and you're connecting to the server, or you have a desktop SQL Engine running on your laptop running...

WayneS (11/16/2010)

---

FYI, I've asked Jeff to poke his head in here.

Something that is really interesting in an odd way: if you build the test data first, and then separately run...

You know, I think I've...

GrassHopper (11/16/2010)

---

In my subquery (join) table, I have millions of records. When I run the query without the loop it multiplies my records and it gets too big, doesn't...

I still think you're locked into a bad approach.

You can call a foreign procedure from a local one. For example, lets say I had a linked server DWServ2, and...

This gets complex, but the simple form of the method is this:

You don't call the job, you call the SSIS package (dtsexec.exe) and via that method, you feed it variable...

As an update:

This:

SELECT@NumAccounts= 1000,

@DateSpan= 4000

Is at an hour and climbing. Not sure which version is the problem child.

EDIT: Finally completed

Death to the lack of the Tally!

Test done for 1000...

rconway-574047 (11/16/2010)

---

I have three tables. A Fact table (Emp_Facts) which are aggregate counts of the survey data for each Survey_Key and Time_Key. I have a survey table (Survey_EMP) which is...

Is there anyone else...

WayneS (11/16/2010)

---

LutzM (11/16/2010)

---

If what you did over there would be considered being harsh, I'd have to stop posting!!

The effort you put...