tendayit (8/18/2011)

---

The Universe program was modified to read data into a temp file in Universe from sql and to close the connection to sql. Data gets processed in Universe and...

ChrisM@Work (8/18/2011)

---

This incorporates many of the changes suggested to date and replaces the cursor with a local temporary table.

ALTER PROCEDURE [dbo].[cust_CreateJournalEntry]

@PO_NUMBER VARCHAR(10)

...

Eugene Elutin (8/18/2011)

---

When you've cleared the file, does search work for other noise words? If not the file you've changed is not the one used by sql server. What I'm...

Sean Lange (8/17/2011)

---

And what exactly did you contribute? A lot of arrogance and confrontational nonsense.

Here is your post with all of the arrogant and non contributing drivel strikethrough

There is nothing...

GSquared (8/16/2011)

---

nadabadan (8/15/2011)

---

troe_atl (8/15/2011)

---

As for nadabadan your response was awful. I don’t expect you to read my mind and I didn’t need or want your rude response. There...

Lowell (8/11/2011)

---

.NET has a bulkCopy object you can use.

you need to read the data into a datatable first, and like bcp, the table has to exist as well.

here's a translated...

tendayit (8/15/2011)

---

Hi,

Thanks for all the responses. I ran the query below first:

---------------------

sp_who2 --Run first to see what / who is blocking. Then put SPID below where 133 is.

DECLARE @Handle...

mar10br0 (8/16/2011)

---

A few months ago I installed 4x 64GB SSD in a RAID 0 configuration using the SATA-controller on my motherboard in my home PC. I can tell you: it...

troe_atl (8/15/2011)

---

As for nadabadan your response was awful. I don’t expect you to read my mind and I didn’t need or want your rude response. There are comments...

What an awful post. There is no way to help you even if anyone wanted to. Do you expect people to read your mind?

I see two inserts into PLT_DBOH_DATA..gltrxdet

I see...

SQLTestUser (8/15/2011)

---

I am trying to build a script where the user has to input his email and name ann we will build a a record for that user with a...

opc.three (7/28/2011)

---

MysteryJimbo (7/28/2011)

---

I generally use this to generate the TSQL.

select 'exec sp_dropsubscription @publication = N''' + sp.name + '''' + ', @article = N''' + sa.name + ''''...

Are NULL|NOT NULL specifications for alias types only valid for table columns? That is when it's not overridden?

CREATE TYPE NotNullType FROM VARCHAR(10) NOT NULL;

DECLARE @nnt NotNullType

SET @nnt = 'abc'

SELECT @nnt

SELECT...

dimitri.decoene-1027745 (2/25/2011)

---

Another way to do it is by using the Tally table. Check out Jeff Moden's article http://www.sqlservercentral.com/articles/T-SQL/62867/.

Here's some example code (how i use it on our systems):

SET ANSI_NULLS...

http://technet.microsoft.com/en-us/library/ms345122(SQL.90).aspx is a good white paper on XQuery that you may want to look at.

At the bottom of this white paper are links to three other decent...