Here is a quick sample, should get you passed the hurdle.

😎

USE tempdb;

GO

CREATE TABLE #BOMTbl

(

ItemNo HIERARCHYID NOT NULL,

Lvl AS ItemNo.GetLevel() PERSISTED,

MatID VARCHAR(25)...

Looks like you have been "Granted" a...

ChrisM@Work (9/5/2014)

---

Meatloaf (9/3/2014)

---

Hello,

I trying to figure out the logic to add a number to the end of an ID to create a series.

For example, I have an EventID that may...

Quick thought, use aggregation and group by to eliminate the nulls (cross tab style)

😎

Phil Parkin (9/5/2014)

---

cstrati (9/5/2014)

---

Hi Phil

Thanks for your reply.

Unfortunately I've ran your script and I'm getting the same 4 results.

It doesn't appear that the columns that are emtpy display when...

Jeff Moden (9/5/2014)

---

Eirikur Eiriksson (9/4/2014)

---

Jeff Moden (9/4/2014)

---

I guess my question would be, if you recognize it as not being a good practice, why would you post the technique? We...

Jeff Moden (9/4/2014)

---

I guess my question would be, if you recognize it as not being a good practice, why would you post the technique? We just don't know what...

Here is a quick demonstration of the formula I posted earlier (EventId * 10^(number of digits) + sub-event-id)

I am by no means recognizing this as a good practice, this is...

My two cents in the form of some quick questions:

1) is the budget big enough or do you have to compromise?

2) do you have the resources for...

Luis Cazares (9/4/2014)

---

batgirl (9/4/2014)

---

Lynn Pettis (9/4/2014)

---

Yes, I actually threw one of Mr. Celko's own arguments back at him in a post talking about dates.

I liked the COBOL reference since he...

Solomon Rutzky (9/4/2014)

---

Sean Lange (9/4/2014)

---

Solomon Rutzky (9/4/2014)

---

Eirikur, I completely agree with the statements of "just think how much is going to fail down the line if suddenly NULLs become empty...

Solomon Rutzky (9/4/2014)

---

Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of the space...

Quick thought, CURDATE() returns the current date in either string or numerical format, the formats being as string 'YYYY-MM-DD' or in numerical if one adds 0 to the function (select...

Quick questions,

1. What Version and Edition of SQL Server are you on (SELECT @@VERSION) ?

2. Do you have a XSD (XML Schema Definition) for the XML date?

Here is a...

Quick thought, use a HEX editor to check for the BOM, Byte Order Mark, at the beginning of the output file. If the correct UTF-8 mark is there then the...