gbritton1 (4/24/2014)

---

Here's a great article on the topic:

http://www.brentozar.com/archive/2012/07/identifying-correcting-sql-server-implicit-conversion/

I stopped relying on implicit conversion years ago. In fact, in all languages I write I try to adhere to the "Explicit...

Sean Lange (4/24/2014)

---

Why not just increase the length to 36 characters and use newid()?

Or you could use an identity column and use ASCIIEncoding to convert the value to a...

gbritton1 (4/24/2014)

---

Sure, but Explicit is better than Implicit. SQL Server sometimes does not give you the implicit...

Stop working to get something you could easily get by using Identity or SEQUENCE as stated by twin.devil.

You should use a PK (or unique) constraint as well to ensure uniqueness....

This is clever: SUM(1-SIGN(Pos-1))...

This might be simpler.

WITH Clm2Values AS(

SELECT Clm1,

CASE Clm1 WHEN 'Trauma' THEN 1

...

You don't need explicit conversion. The insert will handle it implicitly.

CREATE TABLE #Testchar(

myvarchar nvarchar(10)

)

CREATE TABLE #Testfloat(

myfloat float

)

INSERT #Testchar VALUES('3.14159E0')

SELECT *...

Have you read about the Delimited8kSplitter?

Check it on this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/

It will show you how it works and how to use it.;-)

I would create an additional table to include the item's codes conversion. That way you can add it to your joins to keep an equality.

Post the exact error you're getting.

Can you explain why is this not correct?

SET DATEFIRST 1;

WITH SampleData (PERSON, [DATE], [HOURS], [DOW]) AS

(

SELECT...

I can understand the need to prevent the use in production code, but not in ad-hoc queries when developing and testing (I often use it to evaluate a table structure).

You...

MMartin1 (4/22/2014)

---

Extra comma's where? Do you mean there were extra fields in the text file that had empty string values? Else the purpose of the double quotes is to denote...

That's a...

Maybe you could do some networking if there's a local PASS chapter near you.

http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

That way you'll be able to speak with SQL Server professionals and prove that you might be...