NAW's:

upgradation

incrementation

What did you get with 102? Never mind, you really want 101 for mm/dd/yyyy. Crooked eyes on my part.

bill.brazell (5/3/2010)

---

That's just some sample script. I believe someone put the DROP statement in there just to clean up.

I did add a UDF called DelimitedSplit, but can't figure out...

Date formatting should be done in the UI, not in SQL, but if you really need it,...

The best way to do this is to read and follow the instructions in the first article I reference below in my signature block regarding asking for assistance.

If you follow...

lmu92 (5/3/2010)

---

The following code would solve the example you provided, but as Lynn already suggested, posting your code would probably help us help you with the "real issue"...;-)

SELECT 'Header Record'

UNION...

stark 41816 (5/3/2010)

---

Hi everybody,

I inherited a SQL Server project, that contains a set of tables with primary ID fields, which (for several reasons) are not auto-incremented. Instead, the database includes...

Sounds good to me, just thought...

yogesh.pancholi (5/3/2010)

---

Run below query in Query Analyser. I have specified in Options | Results to output to Text, and do not print column headers. Also, I'm using SQL Server 2000.

SQL...

And I'll be out tomorrow. I'll leave him a note about the code and see where he is on the changes.

My co-worker is modify code he wrote to access data from SharePoint to remove proprietary info. Unfortunately, he is also out today so I don't have anything for you...

What are you trying to accomplish and wht is the desired results?

Only question I have, are those two the only ones we want to look at more closely? I know that a third one didn't impress a few of us,...

Two things; first, have you tried double clicking on the error message? That will take you directly to the line with the error.

Second, why the () around the outer...

Actually, for a database server that needs to host 150+ databases, I'd be looking at a minimum of 64GB to 128GB ram, more would be better.

IIRC, our network services group...