Luis Cazares (8/14/2012)

---

I'm not sure if it will solve the problem without having DDL and sample data to test on.

My suggestion is to move the condition from the WHERE clause...

mhambleton (8/14/2012)

---

Hi,

I'm working a project where I need to be able to create a text file from a SQL Query. I use the BCP function but continue to get the...

Your WHERE clause forces the equivalent of an inner join. Move the @User = o.owneridname into your join criteria.

Brandie Tarvin (8/14/2012)

---

I get ideas from the weirdest places. I keep threatening to write stories about you people and never do. Well, this debate has inspired me to come up...

Brandie Tarvin (8/14/2012)

---

I get ideas from the weirdest places. I keep threatening to write stories about you people and never do. Well, this debate has inspired me to come up...

ChrisM@Work (8/14/2012)

---

Here's an alternative using PARSENAME()

SELECT

bi.Building_Name,

COUNT(di.DeviceNum) NumberOfDevices

FROM #Building_Information bi

INNER JOIN #Device_Information di

ON PARSENAME(bi.Subnet,4) = PARSENAME(di.IP_Address,4)

AND PARSENAME(bi.Subnet,3) = PARSENAME(di.IP_Address,3)

AND PARSENAME(bi.Subnet,2) = PARSENAME(di.IP_Address,2)

GROUP BY...

sotn (8/14/2012)

---

Nope, in Transact-SQL, a timestamp is a special binary field. so looks like this 0x00000000000007DA

It is also called 'rowversion'

This field gets updated every time the row is modified, so...

Munabhai (8/13/2012)

---

I am loading data from SQL Server to Flat File and add date at end of filename. It works perfectly. Same way I try, taking Excel as Destination and...

Do you mean something like this (based on test setup provided by rVadim):

CREATE TABLE #Building_Information (

Building_Name VARCHAR(50)

,Subnet VARCHAR(15)

);

INSERT INTO #Building_Information (Building_Name, Subnet)

VALUES ('Building 1', '192.168.1.%'),

...

Yes there was, 0 (zero) seconds was added to the 0 (zero date, 1900-01-01 00:00:00.000).

drew.allen (8/13/2012)

---

I disagree. While I'm sure that the intention is that the statement before must end with a semicolon, implementation and general practice...

GSquared (8/13/2012)

---

Lynn Pettis (8/13/2012)

---

This is how I would code it. Also note that I am using sys.indexes, not sysindexes.

IF EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME...

This is how I would code it. Also note that I am using sys.indexes, not sysindexes.

IF EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')

...

My question is why do the IF EXISTS ... DROP followed by an IN NOT EXISTS ... CREATE? Why not just do the IF EXISTS ... DROP folloed immediately...

I would say to create the index if it doesn't exist. Using the DROP EXISTING implies that the index already exists. We do it here to ensure that...