pietlinden (4/28/2015)

---

Save yourself the headache. Store the dates as dates, not as two columns with numbers. Then you can do date math really easily, index columns and all...

I think you are looking for (I'm calling your Year column "yearCol" and month column "monthCol":

WHERE

(yearCol = 2014 AND monthCol >= 9) -- All dates in year...

Using the DDL and example data that you provided can you provide an example of what the correct output would look like?

Getting a cert should not hurt you in any way. That said, I learned C# about 12/13 years ago because, at the time I wanted to be a .NET web...

The @ sign is used for referring to XML attributes. You are looking for the value of the Element.

Below is the code that will get you what you are...

dwain.c (4/27/2015)

---

Alan.B (4/27/2015)

---

Jeff Moden (4/26/2015)

---

Alan.B (4/26/2015)

---

Over the past year I have heard some folks around here talk about a "set based loop". What's that all about? Can someone provide an...

Gary Harding (4/27/2015)

---

When I first saw this type of usage...

Jeff Moden (4/26/2015)

---

There are...

I figured it out...

$myArray =@()

foreach ($item in $TestLocations) { $myArray += $item.LineNumber }

dwain.c (4/20/2015)

---

Interesting solutions there gentleman, but regardless of how you set up your PRIMARY KEY/INDEXing, might this not be just a tad simpler?

SELECT name, =MAX()

FROM

(

SELECT name,...

DonlSimpson (4/22/2015)

---

Alan.B (4/21/2015)

---

Minnu (4/21/2015)

---

Hi Team,

The solution provided by are working fine..

but there is a change in my result.

my request is

if a record_1 is in Table_A and Table_B, then

output...

Read Paul Whites articles about APPLY, they are the best out there IMHO. These are the two article that really helped me understand APPLY:

Understanding and Using APPLY (Part 1)[/url]

Understanding and...

-- a db we both have

USE tempdb

GO

-- create your table

IF OBJECT_ID('tempdb.dbo.xdocuments') IS NOT NULL DROP TABLE dbo.xdocuments

GO

CREATE TABLE dbo.xdocuments(xid int not null, yourxmlcolumn xml not null);

GO

-- insert a couple records

INSERT...

Luis and Sean beat me to it... I was going to add, here's a good article on this subject:

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

J Livingston SQL (4/22/2015)

---

Alan.B (4/22/2015)

---

This is what I came up with:

SELECT

ab.AddressCode,

AddressInstance = ROW_NUMBER() OVER (Partition by ab.AddressCode ORDER BY (SELECT (NULL))),

ab.PostCode,

...