Here is the first part and the goal of this part is to improve the yearweek table which then allows us to do a direct join to it rather than...

Quick thought, isn't Merge Cells what you are after here?

😎

The code fails because the first character in the Pattern sequence is NCHAR(0). Any usage of the string will recognise this as the end of the string, truncating the string...

smart_analyst (8/28/2014)

---

I have created a my first SSIS package where I am using Execute SQL task and trying to run a simple select query.

I am using one input variable school_name...

sqlfriends (8/28/2014)

---

But sometimes those databases need to work with different SQL server versions.

For example some retired db is at version 2000 and only works with 2000, some with 2005 etc.

So...

Some good points you make there Steve, thanks!

But now a days computers are such a robust stable platforms, with such a stable reliable storage media, used by very competent and...

Quick thought, my preferred approach would be a named SQL Server instance, normally SERVERNAME_OLD. Kind of in line with Jeff's suggestion. Reason being that normally there are more than one...

Ed Wagner (8/28/2014)

---

Lynn Pettis (8/28/2014)

---

I really must be getting jaded. I get chastised for not being able to figure out what some ones uncommented and convoluted code on a...

Here is a quick sample solution, much worse performance wise than Chris's but I put it forward more as an alternative method anyway.

😎

USE tempdb;

GO

;WITH TDOC(

[ID]...

Here is a quick SQL 2K8 solution, toggles by the flag changes using self-join, SQL 2012 solution would be easier with running total;-)

😎

USE tempdb;

GO

create table #test ( num int ,orig_time...

Here is a quick solution, adds a row number to join the two sets

😎

IF OBJECT_ID('Tempdb..#tTable1') IS NOT NULL

DROP TABLE #tTable1

CREATE TABLE #tTable1(ID INT,

...

daz.chauhan (8/28/2014)

---

Morning folks

Please can someone help with the format of a field? I have a number field (well I have hundreds on a number of reports) and I need...

My apologies if I was out of line earlier, somehow I get kind of agitated when requirements focus more on HOW than WHAT, especially when it's incorrect.

The problem itself is...

Hi and welcome to the forum, complements on the fine DDL and sample data!

Not too clear on what you are after but please bear with me as I'm only on...

errolthomasql (8/27/2014)

---

i am not sure how this will show up after changing the file extension. i wasnt able to upload as .csv

also, i am not going to be opening up...