ghughes (9/21/2016)

---

I am wondering if there is a better way............. here was my challenge.

I have 2 tables and I am attempting to match models. (they are described...

You need to add spaces between the parameters, use the correct field delimiter (you stated comma but the sample uses tab), set the first row (to skip the header), set...

Please, also share a sample of your input file.

Here's also the best explanation I've had on importing flat files: http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

Can you start by sharing a sample of the file? It might be possible to do it during the import, but I can't be sure without a sample.

Doesn't support or doesn't have documentation on...

Please, disregard my previous post as it does the opposite of what you asked.

Here's a corrected code:

DECLARE @DatabaseName NVARCHAR(130)

DECLARE DatabaseList CURSOR LOCAL FAST_FORWARD FOR

select QUOTENAME(name)

from sys.databases

where name IN...

Here's an alternative that doesn't rely on undocumented procedures.

DECLARE @sql nvarchar(MAX) = '';

SELECT @sql = (SELECT 'DROP TABLE ' + QUOTENAME( DBName) + '..' + QUOTENAME(TableName) + ';' + CHAR(10)

...

It's not syntactically correct.

SQL Server does not have a boolean data type, it only has a bit data type.

Your BEGIN has no END.

You're RETURN does not have anything to...

You have an ISNUMERIC function in T-SQL. That can be misleading, but it works: http://www.sqlservercentral.com/articles/ISNUMERIC()/71512/

Instead of using To_Number, To_Char & To_Date, T-SQL has CAST and CONVERT. You can also use...

braidensjones (9/20/2016)

---

Hello,

I was a bit confused by a section in the article where it's stated that,

"Note that when dealing with negative numbers, CEILING will continue to go away from...

Could it be referring to something like a catch-all query?

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Brandie Tarvin (9/20/2016)

---

Jeff Moden (9/19/2016)

---

More like "people" season. Some people just don't get it. See the following where what someone is doing actually could kill people. I've...

John McC (9/20/2016)

---

The Conditional rounding is not giving the desired results, based on the statement

That would imply an OriginalValue...

You just need an additional condition.

SELECT name

FROM Sys.databases

WHERE name not in ( 'tempdb', 'master', 'ReportServer' )

AND HAS_DBACCESS(name) = 1;

Sean Lange (9/9/2016)

---

The Dixie Flatline (9/9/2016)

---

I have been making bacon like that for years...never knew it had a name. Another great way is to put a liberal amount...