How are you so sure it fails on that specific line?

You could use a "simple case" expression (in contrast with the searched case expression you wrote).

SELECT CASE RTRIM(Customer.Source)

WHEN 'CREDITNEW' THEN 'CREDIT'

WHEN 'CREDITOLD' THEN 'CREDIT'

WHEN 'TOC' THEN 'CREDIT'

WHEN 'DEBIT' THEN 'UC...

Your scenario isn't entirely clear to me.

You do not explain what the value @UserInputDt has to do with @para (=2014-02-01).

Why is the result for Begfiscal 2013-02-01 and for Endfiscal 2012-01-31?

Wouldn't...

Griffster (10/22/2013)

---

TheSQLGuru (10/22/2013)

---

Griffster (10/22/2013)

---

Yes, we will be buying the Enterprise Edition. Looks like it would be worthwhile then so long as it's not too long a wait. If the release...

Unicode can handle a lot of characters. I don't know at the top of my head which characters are not supported.

If you know which characters you don't want, you can...

Somewhere at the top of your screen you have a link to the control panel.

There, go to the options (left below) and choose forum settings.

Sorry, I checked the forum settings and the maximum is 50 posts per page.

hjvegt1960 (10/22/2013)

---

Hi all

I found an interesting thread about linking SQL Server with other database applications.

This thread has many reactions and reactions at reactions etc. In all there are 13 pages.

Is...

This is a dangerous situation.

A query is issued to retrieve the configurations. If it retrieves multiple rows, all of those configurations are applied, with a configuration overwriting the previous one....

For the moment, SQL 2014 doesn't have much BI improvements (except for clustered columnstore), but they might announce new features. Who knows?

SSIS will get some new adaptors (OData and Azure...

Not that I know off.

I never lock variables. Never ran...

Depends on the features you want I guess.

If you desperately want Hekaton for your OLTP, I would wait for SQL 2014.

If you have an environment which is more used for...

How are you trying to define the relationship?

Can you post the DDL of the tables involved?

string columnname = "Name";

DataTable myTable; -- don't forget to initialize datatable

foreach(Datarow row in myTable.Rows){

Console.WriteLine(row[columnname]);

}

Haven't tested it, but it shouldn't be far off.