Viewing 15 posts - 1,006 through 1,020 (of 3,544 total)
SQLKnowItAll (2/23/2012)
It doesn't look like that will do any good since the identifiers for the event are on a separate line.
Not sure what you mean by this, since each row...
Far away is close at hand in the images of elsewhere.
Anon.
February 24, 2012 at 1:53 am
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'...
Far away is close at hand in the images of elsewhere.
Anon.
February 23, 2012 at 6:59 am
CONVERT(char(8),DATEADD(minute,[value],0),114)
Far away is close at hand in the images of elsewhere.
Anon.
February 15, 2012 at 7:00 am
GilaMonster (2/6/2012)
Far away is close at hand in the images of elsewhere.
Anon.
February 8, 2012 at 6:42 am
SQLRNNR (1/31/2012)
Worse, what if more tables get added, how do i create a polygon in tsql?
Meh! Dodecahedron with the emphasis on doh!
Far away is close at hand in the images of elsewhere.
Anon.
January 31, 2012 at 7:12 am
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...
Far away is close at hand in the images of elsewhere.
Anon.
January 13, 2012 at 7:40 am
SQLRNNR (1/12/2012)
I have a four letter word in mind for him in regards to his 2+2 question:-D
Five! ???? :w00t:
Far away is close at hand in the images of elsewhere.
Anon.
January 12, 2012 at 8:32 am
DeanORenO (1/12/2012)
Far away is close at hand in the images of elsewhere.
Anon.
January 12, 2012 at 7:15 am
IIf(Fields!EmailSold.Value = 0, 0, (Fields!EmailSold.Value+Fields!EmailNotSold.Value) \ IIf(Fields!EmailSold.Value) = 0, 1, Fields!EmailSold.Value))
Far away is close at hand in the images of elsewhere.
Anon.
January 12, 2012 at 7:09 am
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:...
Far away is close at hand in the images of elsewhere.
Anon.
January 12, 2012 at 7:04 am
Koen Verbeeck (1/4/2012)
.. my wife gave birth to a wonderful son ...
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...
Far away is close at hand in the images of elsewhere.
Anon.
January 5, 2012 at 8:20 am
Hugo Kornelis (12/15/2011)
If you really want to test the statement made in today's question, you have to run the two backup commands from two seperate tabs in SSMS
Out of curiosity...
Far away is close at hand in the images of elsewhere.
Anon.
December 15, 2011 at 10:20 am
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...
Far away is close at hand in the images of elsewhere.
Anon.
December 14, 2011 at 10:46 am
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'...
Far away is close at hand in the images of elsewhere.
Anon.
December 14, 2011 at 7:21 am
Confused :crazy:
Scrapped post, answer not right :blush:
Far away is close at hand in the images of elsewhere.
Anon.
December 14, 2011 at 7:11 am
Viewing 15 posts - 1,006 through 1,020 (of 3,544 total)