Gopi S (5/5/2015)

---

Hi DBA's,

I'm looking for a process to archive data through replication. I have nightly job that purge records in few source tables(publisher) retaining only 3 yrs data. I...

rpetit1230 (5/5/2015)

---

I'm trying to run an Insert on tables using a User Login but I keep getting the error above. I ran the insert using my own credentials and it...

charipg (5/5/2015)

---

Can i get help for this below script , facing syntax errors.

================================================

DECLARE @strSQL Varchar(MAX) = '';

select @strSQL = "select 'grant execute on ' +

QuoteName(specific_schema)...

Racer

Brilliant work Erland, thank you very much!

Eirikur

MotivateMan1394 (5/3/2015)

---

Hi

I dont want that you rewrite these queries.Only For you Inform :

I Tried 2 Times but the result was not very efficient .

I need an idea...

diogo.venturatomas (5/3/2015)

---

I have a table Sample with data stored like below

ID|STRING |

------------------------------------------------------------------

1| 'ENGLAN SPAIN' ITALY 'FRANCE GERMANY' BRAZIL

I need the output like..

-----------------

|ENGLAND SPAIN |

|---------------|

|ITALY ...

Roust_m (5/4/2015)

---

Hi,

I am trying to do the following:

DECLARE @MinBoundary DateTime, @s-2 nvarchar(max)

declare @DBName sysname, @TableName sysname

select @DBName = 'MyDB', @TableName = 'MyTable'

select @s-2 = '

SELECT Convert(DateTime, MIN(PRV.value))

FROM sys.partition_functions AS PF

JOIN...

Jeff Moden (5/3/2015)

---

There is no need for anything sophisticated here. In this case, brute force is the shortest and most likely the fastest. The "+1" thing in the...

Uday3421 (5/3/2015)

---

ID A B C AVG

------------------------

1 08 09 10 10

------------------------

2 10 25 26 26

------------------------

3 09 15 16 16

------------------------

i trying to get...

Can you add the DDL and data for the dbo.giftregistry table, it is missing from your...

Suggestion, could you add the MOVE (file), closely related and I often get the question.

😎

Eirikur

petervdkerk (5/3/2015)

---

Ok, not sure what you mean by pasting in into replay...it looks better now anyway.

However, my actual question is not answered yet, as I still don't have the desired...

Think you answered your question here;-)

😎

Quick question, LinkedIn?

😎