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?

😎

petervdkerk (5/3/2015)

---

Thanks!

I forgot to add a critical component I see now, the data for table giftregistrypurchases.

I updated my question with that data and desired results.

btw: How do you get your...

Uday3421 (5/3/2015)

---

ID A B C AVG

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

1 08 09 10 -

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

2 ...

Quick questions, is the server running SQL Server? Is AWE enabled on the server? What are the memory (min/max) config of the SQL Server? What is the output of SELECT...

polkadot (5/3/2015)

---

Eririkur, this problem is gone at this time. I don't really know why. I reimported the files from ftp server, re-unzipped, and rebuilt from scratch the DTF handling of...

baldwin 38894 (5/3/2015)

---

I reinstalled a cursor of Dle 8.2 and I removed a database. It is possible to restore somehow? in dbconfig.php provided the names of the bases, there was...

shape2sql only works up to 2008R2, didn't get to work properly for 2012 so I had to do few tricks;-)

First one was pretty lame, import to 2008, detach and attach...

paul 17028 (5/3/2015)

---

Hi

I am trying to alter this SQL to search for exact match only, non case sensitive. I have been trying for over an hour without result

Thank you

strSQL...