Maybe this will make more sense? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Maybe this will make more sense?

Author

Topic

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-01-29 : 11:58:54

Take a look at this pic and this is what I am trying to do. The code I have so far is below it.

Code:


UPDATE W 
	SET PageRequested = PageRequested + '?tid=' + CONVERT(varchar(250), LEFT(NEWID(), 7))
	FROM WebLog W INNER JOIN 
		(SELECT IP, (ID), SUBSTRING(PageRequested, CHARINDEX('?tid=', PageRequested), 50) as PR FROM WebLog 
		WHERE  [Date]=(SELECT max([Date]) FROM WebLog) AND PageRequested LIKE '%?tid=%'
		GROUP BY IP, (ID), PageRequested)
	as Y 
	ON W.ID=Y.ID
	WHERE PageRequested LIKE '%crmresourcesthankyou.asp%'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources