samp.silvercreek (9/23/2014)

---

I like this solution because it handles the "dangling decimal point"...

Quick thought, full text search is not going to perform (or even work) when searching for a suffix, probably better off using the LIKE operator here.

😎

Is it just me or does this smell like a spam? A quick search returned few similar postings referencing the same vendor on other sites.

😎

thomashohner (10/4/2014)

---

I just did that and I am currently running a 50-55 second query vs 8+ minutes. I just don't understand why such a small thing made such a huge...

vinaygambhir (10/4/2014)

---

Thanks.. But the problem is I have to 1st use the below command:

EXEC ('CALL GETENROLLMENT() ')At serverName which returns the two data sets.

I do not know how to...

Here is a quick nesting example

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(Location,Building,RoomName,Habitant )AS

(SELECT * FROM (VALUES

('USA','White House','Oval Office','Mickey Mouse')

,('UK','Whitehall','24hour Lounce','Donald Duck')

) AS X(Location,Building,RoomName,Habitant)

)

,LOCATION_DETAIL(Location,LocationType) AS

(SELECT...

Yet another spam-tastic weekend:angry:

😎

vsamantha35 (10/4/2014)

---

Hi,

I need some help on security. Checking if any Security experts can guide me here.

How to do a Security assessment for an database application?

What are things to have...

Quick thought, by removing the alternative predicate from the...

TomThomson (10/4/2014)

---

Eirikur Eiriksson (10/3/2014)

---

It is worth noting that the THROW...

h2sh (10/3/2014)

---

hi,

i'm trying to work with full text search , i have create a view , but unfortunately , the view doesn't have a column which have a non duplicate...

Alan.B (10/2/2014)

---

I have a few dev boxes running 2014 and have have experienced some instances where 2014 is giving me a parallel query plan where on 2012 I get a...

Quick thought, use NULLIF or skip the ISNULL in the inner query for Actual_CurrentMonth and Budget_CurrentMonth to return NULL instead of 0, then remove those two columns from the group...

Quick thought, what is the data type of the MANUFACTUREDDATE column? If the MANUFACTUREDDATE is a character column of the format MM/DD/YYYY (101) then you must always use the 101...

Had this handy (straight from BOL);-) should get you passed the hurdle.

😎

/* Relevant date time functions with BOL comments*/

SELECT

/* Returns the current database system timestamp as a datetime

...