Koen Verbeeck (10/9/2013)

---

Here you go:

SELECT TOP 25

RowNumber= number+1

,DateField= CONVERT(DATE,DATEADD(dd,number,'2009-11-09'))

,DateGroup= (number/4)+1

FROM master.dbo.spt_values

WHERE type = 'P';

I used the system table spt_values to get a list of numbers, but there are other...

I had to remove unitprice from the orderby to get deduplicated results.

declare @TempTable table (itemnumber int, unitprice decimal(18, 2));

insert into @TempTable values

(777, 10.10),

(777, 11.11),

(777, 12.12),

(888, 13.13),

(888, 14.14),

(888, 15.15),

(999, 16.16),

(999,...

Thanks for your quick reply

Siddharth Mehta (10/21/2009)

---

I have seen this behavior in BIDS 2008 when your machine starts running low on RAM. The solution that work for me is to close BIDS and reopen...

Toreador (10/2/2009)

---

Hugo Kornelis (10/2/2009)

---

That standard dictates that when strings of unequal length are compared, the shorter string is first padded with spaces until it matches the length of the longer...

Warren Gilbert (10/1/2009)

---

I am also of the opinion that the answer is incorrect.

The question specifically asks for extensions (subclauses) to the GROUP BY clause.

GROUPING_ID is a function, NOT a sub-clause...

Florian Reischl (9/24/2009)

---

Tested on 2008. Just tried on 2005 and get the same error...

Florian Reischl (9/23/2009)

---

For your error:

Strange, just deployed the function I posted on my server (as save assembly). Worked fine.

Your initial problem:

Probably it depends on the deterministic of your statement, as...

geervani (9/24/2009)

---

The answer for the question is YES. FROM clause can be used in UPDATE query. But the example query given is wrong.

something like this will work

update table1

set ...

RBarryYoung (9/23/2009)

---

Bhavesh-1094084 (9/23/2009)

---

Thats not true. Even if I add function in the inner join it will still be called for each row when it joins.

Using Exists is must better approach...

Thats not true. Even if I add function in the inner join it will still be called for each row when it joins.

Using Exists is must better approach against inner...

I got following error when creating the assembly

CREATE ASSEMBLY failed because method 'CLRFN00SplitStringToInt' on type 'UserDefinedFunctions' in safe assembly 'SQLCLR.Utilities' is storing to a static field. Storing to a...

I am surprised too!

Thats what I exactly did...

I have only added 3rd party dll to GAC in worked.

We want to use SSIS data transformation framework but avoid using Microsoft Jet engine which SSIS uses to read Excel Source.

However, I've came with the solution to use Script component...