SQL thread | xltronic messageboard
 
You are not logged in!

F.A.Q
Log in
Register
  
 
  
 
Now online (1)
dariusgriffin
...and 113 guests

Last 5 registered
Oplandisks
nothingstar
N_loop
yipe
foxtrotromeo

Browse members...
  
 
Members 8025
Messages 2614636
Today 1
Topics 127575
  
 
Messageboard index
SQL thread
 

offline Sclah from Freudian Slipmat on 2008-01-25 00:25 [#02167266]
Points: 3121 Status: Lurker



DECLARE @SQL NVARCHAR(1000)
SET @SQL = '
SELECT b.id, b.RefId, b.Headline, b.Area, b.Version,
b.fPriority, p.PriorityDescription,
s.StatusCode, s.StatusDescription, i.ReportedBy,
i.ReportedTime
FROM misc_Bug b
INNER JOIN misc_BugPriority p on b.fPriority =
p.PriorityCode
INNER JOIN misc_BugStatusInstance i on i.fBugId = b.id
AND i.ReportedTime = (
SELECT MAX(ReportedTime)
FROM misc_BugStatusInstance
WHERE fBugId = b.id
)
INNER JOIN misc_BugStatus s on i.fStatusCode = s.StatusCode
'

IF @PRefId <> '%'
SET @SQL = @SQL + 'AND CAST(b.RefId AS nvarchar(10)) = ''' +
@PRefId + ''' '

IF @PHeadline <> '%'
SET @SQL = @SQL + 'AND b.Headline LIKE ''%' + @PHeadline +
'%'' '

IF @PArea <> '%'
SET @SQL = @SQL + 'AND b.Area IN (' + @PArea + ') '

IF @PPriorityCode <> '%'
SET @SQL = @SQL + 'AND b.fPriority IN (' + @PPriorityCode +
') '

IF @PStatusCode <> '%'
SET @SQL = @SQL + 'AND s.StatusCode IN (' + @PStatusCode +
') '

SET @SQL = @SQL + 'ORDER BY i.ReportedTime DESC'

EXEC(@SQL)

 

offline oxygenfad from www.oxygenfad.com (Canada) on 2008-01-25 04:47 [#02167305]
Points: 4442 Status: Regular



I'm in your DB, Injecting your codez

CONCAT(CHAR(39),CHAR(97),CHAR(100),CHAR(109),CHAR(105),CHAR
SELECT user FROM login WHERE user = (110),CHAR( 39))

UNION SELECT IF(SUBSTRING(pass,1,2) = CHAR(97,97),
BENCHMARK(1000000,MD5(CHAR(59))),null) FROM login


 

offline leftblank from manchester/dublin on 2008-01-25 05:09 [#02167312]
Points: 462 Status: Regular



DELETE FROM @TmpAvlSearch
IF @StrSiteList <> ''
BEGIN

INSERT INTO @TmpAvlSearch
EXEC spBookingAvailSearch @EID = NULL,
@PG = 1,
@CompanyID = @CompanyID,
@Code = N'',
@RegionID = NULL,
@SupplierID = @strSiteList,
@ObjectID = @Accom,
@AcmFet = N'',
@Pax = @Adults,
@Ages = @Ages,
@Qty = 1,
@Pet = @Pets,
@Date = @StartDate,
@Nights = @Nights,
@attr = N'',
@Acnt = 0,
@Equip = NULL,
@Length = NULL,
@Width = NULL,
@Sort = NULL,
@GStart= NULL,
@GFinish = NULL,
@SearchStart = @dtSearchStart,
@SearchFinish = @dtSearchEnd,
@Web = 1,
@ProviderID = @intProviderID
END

----DEBUG
--SELECT * FROM @TmpAvlSearch
--SELECT* FROM @Supplieralternatives

DELETE FROM @Alternatives
INSERT @Alternatives (
Date,
Duration,
Serv,
Supp,
ObjectID
)
SELECT S.Date,
N.Number,
S.ID,
S.SupplierID,
S.ObjectID
FROM @TmpAvlSearch AS S
--Join Valid Arrival dates
LEFT JOIN dbo.ArriveDepartRule Arrive ON Arrive.Dep=0
AND Arrive.Act=1
AND Arrive.SupplierID=S.SupplierID
AND S.Date BETWEEN Arrive.Start AND Arrive.Finish
AND (Arrive.ServiceID=S.ID
OR IsNull(Arrive.ServiceID,0)=0)
--Join Valid Durations
INNER JOIN dbo.Numbers N ON N.Number BETWEEN
IsNull(@DurationRangeFrom, @Nights) AND
IsNull(@DurationRangeTo,@Nights+1)
AND N.Number>=IsNull(Arrive.MinStay,0)
AND (NullIf(Arrive.FixedStay,'') IS NULL
OR EXISTS(SELECT *
FROM dbo.MakeTable(Arrive.FixedStay)
WHERE Str=N.Number)
)
----Join Valid Departure Dates
LEFT JOIN dbo.ArriveDepartRule Depart ON Depart.Dep=1
AND Depart.Act=1
AND Depart.SupplierID=S.SupplierID
AND DateAdd(Day, Number-1, S.Date) BETWEEN Depart.Start
AND Depart.Finish
AND (Depart.ServiceID=S.ID
OR IsNull(Depart.ServiceID,0)=0)

WHERE S.Date BETWEEN I

 

offline leftblank from manchester/dublin on 2008-01-25 05:13 [#02167315]
Points: 462 Status: Regular



to be continued

 

offline goDel from ɐpʎǝx (Seychelles) on 2008-01-25 13:19 [#02167517]
Points: 10238 Status: Addict



nerds

next semester i'lll be doing sql as well....:/

 

offline chaosmachine from Ottawa (Canada) on 2008-01-25 16:24 [#02167557]
Points: 2330 Status: Lurker



SELECT r.timestamp, r.title, r.body, u.uid, u.name
FROM node n
INNER JOIN users u ON u.uid = n.uid
INNER JOIN node_revisions r ON r.vid = n.vid
WHERE n.status = 1 AND n.nid
IN ( SELECT nid FROM nodereview WHERE reviewed_nid = 1062 )
ORDER BY r.timestamp DESC

 

Messageboard index