polkadot (8/13/2016)

---

am working in dev environment sql server 2012. Need to create a date from 'snapshot month' (6) and 'snapshot year' (2016). Found DATEFROMPARTS() function works but wondering if...

drew.allen (8/12/2016)

---

This is actually an improved version of the test harness. I am putting a slight edge on credits, so that they should appear 60% of the time. ...

drew.allen (8/11/2016)

---

I did a quick comparison of J. Livingston's solution and my solution with 10,000 records. J. Livingston's solution did not account for multiple customers, whereas mine did. ...

is this close?

--code based on ChrisM fine work at http://www.sqlservercentral.com/Forums/Topic1731617-391-1.aspx

CREATE TABLE #t1

(TransactionID INT,

Customer INT,

TransactionType VARCHAR(10),

[Date] ...

User7766 (8/10/2016)

---

Hi All,

I've a table which gives the output when queried normally. I want to transform rows to columns and columns to rows to show it in a report.

PromotionIn ...

Sean Lange (8/8/2016)

---

J Livingston SQL (8/8/2016)

---

I see Brent Ozar is using torrent for the Stack Exchange Data Dump...I would dearly like to get the data for a future project, but...

how are you joining your tables ?

please read this and post back...thanks

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

please provide sample data and expected results......see here for how to do that https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

I see Brent Ozar is using torrent for the Stack Exchange Data Dump...I would dearly like to get the data for a future project, but am quite concerned about the...

can you please repost the original question....i was looking at this, and I cant find it either !

thanks Phil.

hi...would help us all to help you if you read this please

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

and post back with the article's suggested method.

thanks

edit updated URL correctly

ALan....consider the following please

DECLARE @tblResumeTag TABLE ( int identity primary key, TextVersion varchar(8000));

INSERT @tblResumeTag(TextVersion) VALUES

('I accelerated the development of the system by making rationale decisions based on my collaboration with...

...its nearly bed o'clock here in the UK and I've got a 400 mile round drive tomorrow.

hopefully someone else will help you out in the meantime.

I will keep a...

Nusc (8/3/2016)

---

Ok reset this thread.

Here is the data:

ftp://eclipse.ncdc.noaa.gov/pub/ibtracs/v03r08/wmo/csv/year/

I want to do the following as illustrated on the microsoft website:

add a line layer to map

https://msdn.microsoft.com/en-us/library/ee240828.aspx#LineLayer

They give an example with 3 points.

I...