Viewing 15 posts - 7,591 through 7,605 (of 10,144 total)
Raj Deep Alapati (7/30/2010)
I just read this article.. any ideas if it can help mehttp://www.sqlservercentral.com/Forums/Topic669022-338-1.aspx#bm669714
Thanks
Raj Deep
The article you've linked to points out that a LIKE comparison can be optimised if...
July 30, 2010 at 6:28 am
DROP TABLE #Exclusions
CREATE TABLE #Exclusions (ExclusionID INT, ExcludedURL VARCHAR(200))
INSERT INTO #Exclusions (ExclusionID, ExcludedURL)
SELECT 1, '%://llnw-1083.listen.com/6%.rad%' UNION ALL
SELECT 2, '%://fe5357.sidestep.com/servlet6/%' UNION ALL
SELECT 3, '%://cdn-62.blinkx.com/stream/%.flv%' UNION ALL
SELECT 4, '%://genio.virgilio.it/scripts/alice/ifr_virg_comu_genio_cachebust.js_728x90_rmt931648.html%' UNION ALL
SELECT 5,...
July 30, 2010 at 5:26 am
Hi Raj Deep
Please could you provide a sample table with a few rows containing data similar to that found in your exclusion table? It should be in a format like...
July 30, 2010 at 4:18 am
Eugene Elutin (7/29/2010)
Chris Morris-439714 (7/29/2010)
Eugene Elutin (7/29/2010)
SELECT a.*
FROM dbo.Person a
LEFT JOIN dbo.Person_exclusion b
ON...
July 29, 2010 at 10:23 am
skcadavre (7/29/2010)
You cheated Chris! You changed his sample data 😛I'm sure that what you posted is what he meant
LOL!
July 29, 2010 at 9:35 am
skcadavre (7/29/2010)
whitlander (7/29/2010)
Does that help?
I'm feeling generous. . .
This is what you were asked to produce
SET DATEFORMAT dmy
GO
DECLARE @TABLE AS TABLE(
datasource_id VARCHAR(2),
EventType_ID VARCHAR(2),
User_ID VARCHAR(1),
period DATETIME,
Notes VARCHAR(255),...
July 29, 2010 at 9:20 am
Eugene Elutin (7/29/2010)
SELECT a.*
FROM dbo.Person a
LEFT JOIN dbo.Person_exclusion b
ON a.Name LIKE b.Name_similar
WHERE b.Name_similar...
July 29, 2010 at 8:57 am
malavika.ramanathan (7/29/2010)
i have a query which gives the percentage of time against each user.
I have 6 records in total. I must now select top 3 records from it in...
July 29, 2010 at 7:19 am
Santhosh Yamsani (7/29/2010)
-- update a set a.ExclusionID = b.IDSELECT COUNT(*)
FROM dbo.Person a
join dbo.Person_exclusion b
on a.Name like b.Name_similar
Try running this statement to see...
July 29, 2010 at 7:04 am
Paul White NZ (7/29/2010)
Thank you Chris, that was very kind. 😎
No worries Paul I could see you were in deep water there, mate 😀
July 29, 2010 at 5:20 am
CREATE TABLE #SampleData (Name VARCHAR(10), Result INT)
INSERT INTO #SampleData (Name, Result)
SELECT 'Joan', 5 UNION ALL
SELECT 'Jhon', 5 UNION ALL
SELECT 'kris', 3 UNION ALL
SELECT 'alice', 2 UNION...
July 29, 2010 at 5:05 am
Look up DENSE_RANK() in BOL (Books On-line).
July 29, 2010 at 3:01 am
bitbucket-25253 (7/28/2010)
Are the OPs getting bummer and dumber or just lazy and lazier, have others noticed this behavior with fellow workers?http://www.sqlservercentral.com/Forums/Topic960056-146-1.aspx?Update=1
That's just too funny, Ron!
bitbucket-25253 (7/28/2010)
http://technet.microsoft.com/en-us/default.aspx
Input "Upgrading to...
July 28, 2010 at 9:58 am
whitlander (7/28/2010)
INSERT INTO [PELVIS].[dbo].[Event]
([DataSource_ID]
...
July 28, 2010 at 9:37 am
Hi Andy, I'm sorry but I don't have time to convert your post into a set of statements which will populate the sample table.
It should look something like this:
INSERT INTO...
July 28, 2010 at 9:01 am
Viewing 15 posts - 7,591 through 7,605 (of 10,144 total)