andrew_c_worth@yahoo.co.uk (9/24/2015)

---

Interesting - I have tried a little - rough - test.

CREATE TABLE [dbo].[TestEmail](

[Id] [int] IDENTITY(1,1) NOT NULL,

[nvarchar](200) NOT NULL,

[chk] [int] NOT NULL,

CONSTRAINT [PK_TestEmail] PRIMARY KEY CLUSTERED

(

[Id]...

WayneS (9/24/2015)

---

SELECT activityName

FROM #Activities

CROSS APPLY (SELECT PATINDEX('[A-Z,a-z][0-9]%', activityName),

...

SELECT activityName, SortOrder = x4.LeftChars + x6.NewRightNums + ' ' + x3.RightPart

FROM #Activities

CROSS APPLY (SELECT SpacePos = CHARINDEX(' ',activityName+' ')) x1

CROSS APPLY (SELECT LeftPart = LEFT(activityName,x1.SpacePos-1)) x2

CROSS APPLY (SELECT RightPart...

jkramprakash (9/24/2015)

---

i have one table having three columns.This table contains lot of repeated records.

i want to delete this records .

In this below example i want to delete all the records

which...

Is there any particular reason for storing the email address as NVARCHAR?

vipin_jha123 (9/24/2015)

---

Hi Used below query to get the desired output.

;with cte AS (SELECT [ProgramId]

,[ProgramVersionId]

,[WRINPrefix]

...

Here's how you do it:

SELECT

s.*,

[ForecastDate] = DATEADD(DAY, x.n, s.ForecastStartDate)

FROM #STG s

CROSS APPLY (

SELECT TOP(1 + DATEDIFF(DAY, s.ForecastStartDate, s.ForecastEndDate))

n = -1 + ROW_NUMBER() OVER(ORDER BY (SELECT NULL))

FROM...

squvi.87 (9/24/2015)

---

Declare @var varchar(100)

set @var = '2000'

select case when ISDATE(@var ) =1 then 'Valid Date' when ISDATE(@var ) =0 then 'Invalid Date' END

In the above code I...

steve.tarry (9/22/2015)

---

drop table ##ss

select 3 as nr, 'a' as kar, 1 as groupingcode into ##SS

insert into ##SS values

(9, 'C',1),

(15,'h',1),

(7, 'e',1),

(6, 'd',1),

(12,'z',1),

(4, 'b',1),

(5, 'q',1)

select * from ##SS

--

-- Get the first...

Plenty of scope for optimisation here - and the faster a batch completes, the less likely it is to cause a deadlock. I'd start with the nested cursor. Resolve your...

There's a couple of references to the 64/65 split in this article by Paul White. I'm sure I've seen something more comprehensive somewhere but the Google - force eludes me...

IIRC Paul White has one or two articles which exploit...

Rod at work (9/11/2015)

---

Ed Wagner (9/11/2015)

---

If this is a one-time activity, you can query the rows in SSMS and save them as a CSV file by right-clicking the results pane...Save...

Have...

mohelsheikh (9/9/2015)

---

I have two different SQL 2008 servers, I don't have permission to create a linked server in any of them. i created a trigger on server1.table1 to insert the...