timotech (4/21/2016)

---

But i have another question

can i do something like this for example:

declare @Criteria nvarchar(4000)

set @Criteria = 'DayOfInterview'

Select @Criteria, Urbanisation, Gender, AgeGroup, Religion, MaritalStatus, from tmp

group by @Criteria

how can...

If there is anything in the row (in another column) that defines it as new, then you could do part of your requirement by using a filtered index:

CREATE UNIQUE INDEX

ON...

I tried to build a "sort-of" substitute based on the ASCII and CHAR functions, but ran into the same issue you had: both ASCII and CHAR are not supported.

The list...

Sorry, was not aware you were using standard sample code.

I set up a SQL 2016 CTP3 VM on my Azure account and ran the same code you used. After changing...

Can you perhaps also post the code of the UDF used? Both the T-SQL version and the natively compiled version, of course...

I am confused.

I never used this extraction and I cannot test it so I hope someone else will for the definitive answer. However, I expected the asnwer to be two...

Toreador (4/21/2016)

---

Although the documentation states that conversion of an int value that is too long will give an error if converting to nvarchar, but * if converting to varchar, it...

From the explanation:

TRY_CONVERT should obey the CAST and CONVERT rules, which note that truncated values are returned as an E for char and varchar. However, a NULL was returned on...

John Rowan (4/20/2016)

---

In addition to what Hugo has stated, you may consider looking into partitioning your table by date (month) if you can. This requires Enterprise Edition, but it...

I do not see any compelling reason to do so from a technical point. From a logical point, I...

The error message itself appears not to come from SQL Server, but from the application. However, the terms used are clear and tell us what the problem is.

Apparently, this software...

The ANSI-standard for...

Thanks for posting CREATE TABLE and INSERT statements, expected results, and the code you have so far - an excellent way to ask a question!

I copied your code, changed it...

Sgar... (4/16/2016)

---

Andrew Ryan (7/9/2009)

---

Sorry if this has been covered but as you might imagine searching for this has been problematic.

I want to use vaariables with my USE commands.

USE @DBName

GO

if I...

PL/1