Create a table with an IDENTITY column and a single varchar column set to max length of input line

bulk load the data

then select the relevent detail associated to each 'Event'...

CONVERT(char(8),DATEADD(minute,[value],0),114)

GilaMonster (2/6/2012)

---

Given the distribution of answers, I'm considering a followup question - "does recovery model ever affect the ability to rollback transactions?" because it appears way too many people don't...

Meh! Dodecahedron with the emphasis on doh!

I think your dynamic query should look like this

SET @hpQyery= 'SELECT p.Id,

p.[PropertyAddress],

s.MainCityState,

c.CityValue

FROM Property p

JOIN cj_MainCity_States s ON s.[id]=p.MainCityStateId

JOIN FROM cj_Cities c WHERE c.[id]=p.CityId...

Five! ???? :w00t:

DeanORenO (1/12/2012)

---

I like all the interpretations of my question but still no answer. I imagine if I asked the question what is 2 + 2, I would get people telling...

IIf(Fields!EmailSold.Value = 0, 0, (Fields!EmailSold.Value+Fields!EmailNotSold.Value) \ IIf(Fields!EmailSold.Value) = 0, 1, Fields!EmailSold.Value))

Create a DataSet (eg DataSet1) and set the query to

SELECT DISTINCT mastercompanyid,RTRIM(CompanyName) + ' ' + Convert(varchar(25),mastercompanyid) AS Company

FROM vCompanyView

Create Parameter eg ReportParameter1 and tick Allow multiple values

For Available Values

Dataset:...

Congrats Koen 😀

And to repeat previous query

USE MANY_MANY_PATIENCE

GO

DROP Dirty_Nappy

GO

INSERT Baby INTO Nappy

SELECT Clean_Nappy

FROM Nappy_Pile

WHERE COUNT(Clean_Nappy) > 0

GO

GRANT ALL...

Hugo Kornelis (12/15/2011)

---

Out of curiosity...

OK, my first idea for an answer before I did the cte thinng was

SELECTa.PostPeriod, a.NPI, a.location, a.location_mapping, a.location_category, a.category, a.CPT, a.modifier, a.MTDCharges, a.MTDUnits,

SUM(b.MTDCharges) AS [YTDCharges],

SUM(b.MTDUnits) AS [YTDUnits]

FROM...

OK maybe this then

;WITH cte (Period) AS (

SELECT '11010' UNION ALL

SELECT '11011' UNION ALL

SELECT '11012' UNION ALL

SELECT '11101' UNION ALL

SELECT '11002' UNION ALL

SELECT '11003'...

Confused :crazy:

Scrapped post, answer not right :blush:

Feeling posts is OK, taking them home to see mama, that's improper :hehe:

Jeff Moden (12/13/2011)

---

Only if the posts...