Jeff Moden (1/23/2015)

---

Thought I'd throw my tweaks into the ring.

DECLARE @PassedInDate DATETIME;

SELECT @PassedInDate = '15 OCT 2014'

;

SELECT Wk# = ROW_NUMBER() OVER (ORDER BY wk.MondayDate), wk.MondayDate

FROM...

Quick thought, is TCP/IP enabled?

😎

Quick thought, the problem doesn't require a complex table structure, something like this should do

😎

+----------+ ...

Quick thought, seen this behaviour occasionally on SQL Server 2008, caused by an implicit cast or at least adding the N'' has fixed the problem.

😎

Try changing

convert(xml,'<xml><![CDATA[' + cast(TABLE.COLUMN...

GilaMonster (1/23/2015)

---

Or, if you want to be even more confusing...

create table [where]

([where] char(5),

[from [where] varchar(25),

[select [where from [where] varCHAR(50),

)

go

insert into [where] values ('from where', '[from [where]]', 'select...

Removed bad solution

😎

Quick question, can you post the DDL and some sample data as an insert statement, makes it easier to help?

😎

pkapas (1/22/2015)

---

I have a stored procedure that calls several views that rely on each other. In the past these views used to go parallel and use up all 100% of...

Brandie Tarvin (1/21/2015)

---

HeaddeskHeaddeskHeaddesk.

Can I scream yet?

I just got the "white paper" for a new project. 46 freaking pages of "time to integrate the systems". Which isn't bad. I support the...

That's probably the best way around the problem, schedule the job for off-hours/maintenance window execution when no users are affected.

😎

denis.gendera (1/21/2015)

---

I have table with PatchGroup Information. I like to run query using While statement that returns specific results for each patch group.

I'm using SQL Function and doing the...

Quick thought, one can query the xml for both element/attribute names and values, if you have some sample XML then I'll chip in a query for this.

😎

Thordog (1/21/2015)

---

ALTER TABLE [dbo].[TableNameExample] REBUILD PARTITION = ALL

WITH (DATA_COMPRESSION = PAGE)

The table is 110 GB, so will take time to compress. But it is one table in a database...

Stephanie Giovannini (1/21/2015)

---

I'm attempting to convert some INSERT-EXEC structures into table-valued functions because the procedures are deeply nested and INSERT-EXEC doesn't like nesting (Error 3915: Cannot use the ROLLBACK statement...

Post the...