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...

TeraByteMe (5/3/2015)

---

I started a new position recently and my Manager says there is a UDF out on a database but I can't find it anywhere not under object explorer in...

OsborneHar (5/3/2015)

---

Restore from the SQL Server backups or use SQL Server Repair Toolbox. The MS SQL repair tool reads *.mdf and *.ndf files and saves data, structure, links, etc. as...

MotivateMan1394 (5/3/2015)

---

Hi again

I have 2 Functions in my Query. (then 2 columns in my query's output)

Function 1 : calculate a value on check a state field. (get values from...

Here is an addition to the previous code, nothing fancy but it should work most of the time

😎

USE tempdb;

GO

SET NOCOUNT ON;

SELECT

AW.Id

,CS.city_state_ID

...

GilaMonster (5/2/2015)

---

With the SOLE exception of read committed snapshot, isolation levels are effective from the SET TRANSACTION ISOLATION LEVEL statement until the end of the batch or until the isolation...

Paul Webb-223029 (5/1/2015)

---

I have a T-SQL query that outputs exactly as I wish when run via Management Studio. I now want to automate this query to run monthly via...

Markus (5/1/2015)

---

We have a SQL Server 2008R2 system that has heavy usage to one specific table. I have tuned basically all I can as far as making sure SQL...

sqlvitoco (4/30/2015)

---

Hello.

I have a flow that includes a Foreach Loop Container that loads many files into a table. Also, the last task in the flow sends an "OK" email, and...