If using xp_cmdshell won't get you yelled at, you could have a stored procedure copy the file to a processing directory so it wouldn't be locked by the program. Just...

Can I vote for whichever format doesn't have code or results printed over multiple pages? That's a huge pet peeve of mine.

Yeah, the thing I watched didn't really explain what the @ did, or maybe it would have made more sense if I had a better grasp on the terminology. Either...

Actually, this seems to get me where I need to go. For some reason the tutorial I watched had @ signs in alias paths(?). When I took them out, it...

Hi Alan,

Thanks, that sort of gets things right. However I still have three columns with concatenated data that should be separated out:

VISIT_SURVEY

182Visit10692810016800002MMM2013-08-13RegularFacility...

polkadot (9/27/2013)

---

well, then I had to comment out WITH SCHEMABINDING, because try as I might, to do what the message wanted, it was still same error.

If you can show...

I vaguely recall running into that error when creating a view. In my case adding dbo. to the table name fixed it. So in your case dbo.Runs. Hope this works...

Made my day. 😀

Luis Cazares (9/10/2013)

---

If I understand correctly, you want to show the emails that have multiple ids.

Here are 2 options. If I continue to be wrong, please explain what's the problem...

Luis Cazares (9/10/2013)

---

Another option would be using a different approach.

select s.email,

COUNT( distinct s.id) [ids]

from dbo.j3688931 s

GROUP BY s.email

HAVING COUNT( distinct s.id) > 1

I'm just guessing here because I can't...

I haven't, since the issue was with the column name throwing an error (invalid column name or s1.col couldn't...

Lynn Pettis (9/2/2013)

---

Oracle765 (9/1/2013)

---

Hi Professionals

I have a script thats exports to a csv file

exec exporttocsv 'select top 5 * from newtable', 'test.csv'

the problem I am encountering is that some of...

If there's anything else I can provide to help you help me, let me know!

Jeff Moden (9/5/2013)

---

erikd (7/14/2013)

---

Just a quick note on sample data generation, (forgive me) without reading all 18 pages of this thread.

I altered what you posted to run like this, because...

Good luck...

Six Genders of old Israel

In the old Kingdom of Israel (1020–931 BCE) there were six officially recognized genders:

Zachar: male

Nekeveh: female

Androgynos: both male and female

Tumtum: gender neutral/without definite gender

Aylonit: female-to-male...