Doctor Who 2 (12/27/2016)

---

That might be what I've done wrong. Or put differently, what I've not done. I don't think I enrolled in the Visual Studio Dev Essentials program. How...

Some examples based on your last post.

SELECT ID,

SUBSTRING(ID, 4, 8000),

STUFF(ID, 1, 3, ''),

CASE WHEN ID LIKE 'ING%'

...

Check the scope of the variable.

To keep it safe, I usually keep the scope of all the variables as package wide.

Chris.McCarty (12/27/2016)

---

Hello,

how to write a query - to exclude the field that starts with ING

select * form table where ID NOT LIKE 'ING%' ?

I want to exclude ING from all...

Have you tried the query that you posted? Did it return the expected results? If not, what's the problem?

Carrie Fisher is now one with the force.[/url] :crying:

Can 2016 end already?

This should show if it's developer or evaluation edition.

SELECT @@VERSION

Maybe you were contacted as a follow up from a CTP or some other version previous to the final release.

If you're new to this, I'd suggest you to use the Import/Export wizard and review the results.

There are also a lot of tutorials either written or on video. The process...

Why are you doing this in batches? It's usually faster to do a single load than multiple ones.

Are the columns indexed?

Are you really trying to return a million rows result...

If you're inserting into a non-nullable column from a value that could be null, ALWAYS use ISNULL() or COALESCE().

TomThomson (12/15/2016)

---

The quasi-BNF for inline TVFs at the CREATE FUNCTION (Transact-SQL) page is quite amusing: it gives you four options for the parentheses: have both, have neither, have just the...

Would this do the same thing?

It's hard to know if there's no sample data and no code for the function.

INSERT INTO [RES-DW].[ROW].LogEntry (LogGUID, LogDatetime, MilliSeconds, LogType, LogAction, LogResult, AppGuid)

SELECT l.[rowGUID],

...

Sean Lange (12/15/2016)

---

george.p (12/15/2016)

---

Sean Lange (12/15/2016)

---

george.p (12/15/2016)

---

I missed the title so I assumed it meant Scalar functions 🙁

You're one of those people that puts all of the details in the...

Gail, Lowell and I posted almost at the same time....

Use INSERT INTO...SELECT...

And use a cross join to get the expected result.