Slight different between the two, roughly connect_by_isleaf is the equivalent of GetDescendant

😎

Quick question, is this hierarchical data?

😎

Quick solution

😎

SELECT

RoleName = max(pr.name ...

Pint

Slightly more pedantic approach preventing an implicit conversion

😎

DECLARE @sql NVARCHAR(400)

DECLARE @WgnWCUser VARCHAR(30)='DBO'

DECLARE @TIMESTAMP VARCHAR(30)='UpdateTimestamp'

DECLARE @datFrom DATETIME='20150916'

DECLARE @datTo DATETIME='20150930'

SET @sql='SELECT EVENTUID,EVENTTIMESTAMP,EVENTMAJORTYPE,EVENTMINORTYPE INTO #TEMP

FROM ' + @WgnWCUser + '.EMPLOYEE A WITH(NOLOCK)

WHERE A.'+@TIMESTAMP+'>=CONVERT(DATE,'''+CONVERT(VARCHAR(25),@datFrom,112)+''',112)AND...

dwain.c (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Eirikur Eiriksson (10/1/2015)

---

This made me spill my ESB...

sandhuz24 (10/7/2015)

---

Thanks Eirikur!

Sorry for the delay in getting back to the post. Been really busy at work. I had the indexes on the table as you suggest in your post...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

if object_id('Tempdb..#Element1') is not null drop table #Element1;

create table #Element1 (

[Attr1] varchar(10)

,[Attr2] varchar(4)

,[Attr3] varchar(2)

...

Does the 2008 db pass the integrity check?

😎

John Rowan (10/5/2015)

---

Number(38) is much larger than integer and I don't think they play nice together with implicit conversions. The error looks like it's happening on your destination component...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TableA TABLE

(

FldA INT NOT NULL

,FldB INT NOT NULL

);

INSERT INTO @TableA(FldA,FldB)

VALUES (3,4)

...

Grant Fritchey (10/5/2015)

---

You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the...

Quick question, can you post the DDL (create table script) for those two tables?

😎

chancrovsky (10/5/2015)

---

I've been reading about the protocols and i've been trying to connect to my SQL SERVER using each one of the protocols, but i think I'm missing something, i...

Are you certain those are full backups and not transaction log...