aaron.reese (11/14/2014)

---

...VARCHAR / NVARCHAR - who cares on a small adatabase that is only ever going to be used with Latin CP1 collation unless the number of records is going...

measterbro (3/12/2015)

---

Unfortunately I am not able to post data or DDL since it is proprietary. I just thought there might be a known problem with dynamic SQL and appending variables,...

Msg 213, Level 16, State 1, Line 2

Column name or number of supplied values does not match table definition.

You're not...

TSQL Tryer (3/11/2015)

---

Worked it out -

select officer_code

,department

,eff_date

,CASE WHEN LEAD (eff_date-1, 1, 0) OVER (PARTITION BY officer_code ORDER BY eff_date) =...

chef423 (3/8/2015)

---

...

Caveat:[/u] The WHERE clause cannot be used in writing this Query as it is used to determine the time span of the report by a line called WHERE %PARAMS%,...

rodjkidd (3/10/2015)

---

Eirikur Eiriksson (3/10/2015)

---

rodjkidd (3/9/2015)

---

Eirikur Eiriksson (3/9/2015)

---

Grant Fritchey (3/9/2015)

---

Great seeing everyone this week at SQLBits.

And, I got to meet Gianluca and Eirikur for the very first time. Total pleasure gentlemen....

dwain.c (3/10/2015)

---

I guess the real point of my post was not to offer competition to DelimitedSplit8K (or any of its variants).

Rather to see if anybody has ever seen this "short-circuiting...

Grant Fritchey (3/9/2015)

---

ChrisM@Work (3/9/2015)

---

The optimiser has difficulty with more than seven or eight tables in the FROM list regardless of how they are joined. More than that and you are...

This ON clause will generate an error as it breaks at least two syntax rules:

JOIN dbo.PeriodDefinition AS pd

ON CAST(t.dt_close_time AS time) BETWEEN CAST(pd.dt_start AS time) CASE when i_period_definition_id =...

Bouke Bruinsma (3/8/2015)

---

We have a view with many left joins. The original creators of this view might have been lazy or sloppy, I don't know. I have rewritten the query...

ding

You're bored, mate. Beer sometime?

A table displaying the required results would be helpful.

Try this:

;WITH RunningTotal AS (

SELECT

a.id, a.account, a.deposit, b.Budget,

[Total] = SUM(a.deposit) OVER (PARTITION BY a.account ORDER BY a.id)

FROM #TestData a

INNER JOIN...

karthik82.vk (3/3/2015)

---

Hi,

I have created a function that will check whether the data is null or not. If its null then it will display that as No data else it will...

There are NULLs in your data. Try this:

SELECT 'SELECT '

+ ISNULL(QUOTENAME(user_name,''''),'NULL') + ','

+ ISNULL(QUOTENAME(date_of_change,''''),'NULL') + ','

...