Here is what I put together:

CREATE TABLE [dbo].[testPartition](

[testCol] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

);

insert into dbo.testPartition

select 'a'

union all select 'a'

union all select 'a'

union all select 'b'

union all select 'c'

union all select 'd'

union...

deebabat (4/20/2012)

---

Thanks for your advice, this is what I have it's just that I am not sure it's right

WITH Numbers(Number) AS (

SELECT 1

UNION ALL

SELECT...

deebabat (4/20/2012)

---

Write a query that returns a two column rowset:

-Column 1: contiguous integers from 1 - 102

-Column 2: if Column 1 is...

Does this happen to all tables or only certain tables?

enlightenment

After my quick foray this morning before leaving for work, I am staying away. I may read, but I am not getting...

You shouldn't have to pay anything since you are retiring the old servers. All you are doing is moving the licensed software to new hardware.

And after that, check out these articles:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

You would really need to check with Microsoft. Depending on the edition you are installing, it is possible that you could actually combine the CALS and have 13 users/devices...

SQLRNNR (4/20/2012)

---

Lynn Pettis (4/20/2012)

---

Sean Lange (4/20/2012)

---

Lynn Pettis (4/20/2012)

---

SQLRNNR (4/20/2012)

---

The Dixie Flatline (4/20/2012)

---

I am enjoying a lighthearted chuckle at your expense. I'm also thinking about writing up a...

One little change (well, a couple of changes if you look at my setup code as well):

create table #group

(

ISSUE char(20),

ROW_DATE datetime,

DURATION int

);

insert into #group

select 'red','2012-04-01 15:40:00.000',300

union

select 'orange','2012-04-01 15:45:00.000',2580

union

select 'blue','2012-04-01 16:28:00.000',480

union

select...

Or, an alternative:

CREATE TABLE ProductLocs (

ProductLodID INT IDENTITY(1,1),

Product VARCHAR(10),

Location INT);

INSERT INTO [ProductLocs] (

[Product],

[Location]

) VALUES (

'PROD1',

1 );

INSERT...

CELKO (4/20/2012)

---

>> I have a table that has lots of staff (described by unique staff_ids) and hours worked as a metric for each int week number. <<

You have not ever...

Sean Lange (4/20/2012)

---

Lynn Pettis (4/20/2012)

---

SQLRNNR (4/20/2012)

---

The Dixie Flatline (4/20/2012)

---

I am enjoying a lighthearted chuckle at your expense. I'm also thinking about writing up a 12-step program for...

djustice 20821 (4/20/2012)

---

How does this code look? I created a table JobrunCal with the dates of the Monday holidays.

DECLARE @countVar int

set @countVar=1

While @countVar=1

begin

if getdate() in (select * from...