sivaj2k (6/27/2013)

---

Hi, Please check the following code .

declare @table table (id int identity(1,1),item varchar(10),amt int)

insert into @table values (1,100),(2,200),(3,300),(4,400)

declare @sumtotal int

select @sumtotal = SUM(amt) from @table

SELECT a.id, a.amt,@sumtotal-SUM(b.amt)

FROM ...

Sample data: -

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN;

DROP TABLE #testEnvironment;

END;

SELECT TOP 10000 IDENTITY(INT,1,1) AS ID,

(ABS(CHECKSUM(NEWID())) % 1000) + 1 AS usage

INTO #testEnvironment

FROM master.dbo.syscolumns sc1, master.dbo.syscolumns sc2,...

mamzy10 (6/27/2013)

---

Hi cadavre still having prolems its still spitting out ALL of the data and not just those ones with 21 and something else. im getting learners who dont even...

Firstly, whenever you come on a technical forum you should always try to provide people with DDL and readily consumable sample data. This makes people far more willing to answer...

Can't really explain why, but change the function to: -

CREATE FUNCTION [dbo].[func_SPLIT_STRING]

(@INPUT VARCHAR(8000)

,@DELIMITER CHAR(1) = '|'

)

And...

ArjunaReddy (6/24/2013)

---

Hi ,

Environment: SQL Server 2008 Enterprise Edition with sufficient hardware.

I have a table with > 60 Million records on which I am performing delete operation using a stored...

Since we're talking about SQL Server 2008 here, any issue with using the date type?

SELECT CONVERT(DATE, DateAdd(yy, - 5, GetDate()));

For you to have got that error, you must've not run...

Bear in mind that if your Row_ID is not contiguous, you need to use the ROW_NUMBER solution propose...

You're over complicating things. This is just a bit of simple maths 😉

-- CREATE SAMPLE DATA

IF object_id('tempdb..#Table') IS NOT NULL

BEGIN

DROP TABLE #Table;

END;

SELECT TOP 30

ROW_NUMBER() OVER(ORDER...

Teee (6/19/2013)

---

Hi All,

I need to return the minimum date from my table and manipulate it so it starts from the first of the month

e.g 2012-06+'-'+'01+ and use this as...

Another couple of ways: -

-- IF FROM A TABLE

SELECT fin

FROM (VALUES('[N] 18. Is the C.B. removed from the panel? [Yes / No]')

)a([STRING])

CROSS APPLY (SELECT...

First, let's create some sample data from the mess that you posted: -

IF object_id('tempdb..#test') IS NOT NULL

BEGIN;

DROP TABLE #test;

END;

SELECT [Job Posting Create Date_JP], [Report Run Date_BYR]

INTO...

Brandie Tarvin (5/28/2013)

---

So I just upgraded my new laptop from Win 7 Home Premium to Win 8 Pro and ... Well, darnit, I can't figure out how to find my...

ChrisM@Work (5/15/2013)

---

dwain.c (5/15/2013)

---

Sorry to disappoint you guys but I wasn't able to come up with anything.

My gut was telling me an rCTE wouldn't do it and the set-based loop I...