Viewing 15 posts - 17,461 through 17,475 (of 26,489 total)
Gatekeeper (1/13/2010)
January 13, 2010 at 10:02 am
Gatekeeper (1/13/2010)
January 13, 2010 at 9:46 am
A count of unique email addresses, I am assuming as well. Does the user have the option to restrict the date range on the search?
If so, I would also...
January 13, 2010 at 9:33 am
Could you please explain what you are trying to achieve? What is the business case for this query (now I'm starting to sound life Jeff Moden)? How are...
January 13, 2010 at 9:16 am
ifila (1/13/2010)
(
Email1 nvarchar(1000),
Email2 nvarchar(1000),
Email3 nvarchar(1000),
Email4 nvarchar(1000),
Email5 nvarchar(1000),
Email6 nvarchar(1000),
Email7 nvarchar(1000),
Email8 nvarchar(1000),
Email9 nvarchar(1000),
Email10 nvarchar(1000)
);
INSERT INTO #OutputEmails SELECT Email1,Email2,Email3,Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM OutputResume3
where (contains (originalresume, '"livelink" and "java"'))
select count(DISTINCT (Email)) FROM
(
SELECT...
January 13, 2010 at 9:12 am
ifila (1/13/2010)
GilaMonster (1/10/2010)
ifila (1/10/2010)
BTW all i am trying to do is limit the number of records i am counting....pretty simple really. I just dont know the correct syntax.
It probably...
January 13, 2010 at 8:38 am
ifila (1/13/2010)
GilaMonster (1/10/2010)
ifila (1/10/2010)
BTW all i am trying to do is limit the number of records i am counting....pretty simple really. I just dont know the correct syntax.
It probably...
January 13, 2010 at 7:26 am
Grant Fritchey (1/13/2010)
I just read through that whole rigamarole. What a dink. Lynn, you're WAY too nice.
Maybe, but I'm willing to try and help him. And looking at was...
January 13, 2010 at 5:51 am
Grant Fritchey (1/13/2010)
I just read through that whole rigamarole. What a dink. Lynn, you're WAY too nice.
Maybe, but I'm willing to try and help him. And looking at was...
January 13, 2010 at 5:51 am
ifila (1/12/2010)
GO
/****** Object: Table [dbo].[OutputResume3] Script Date: 01/12/2010 22:58:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OutputResume3](
[ID3] [int] IDENTITY(1,1) NOT NULL,
[OriginalResume] [nvarchar](max) NULL,
[Email1] [nvarchar](1000) NULL,
[Email2] [nvarchar](1000)...
January 12, 2010 at 9:19 pm
Lynn Pettis (1/9/2010)
bitbucket-25253 (1/9/2010)
http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx
It is one of the worst I have seen on SSC in a long long time.
Lynn - I must compliment you on...
January 12, 2010 at 9:00 pm
ifila (1/12/2010)
Use
CREATE PARTITION FUNCTION
or
CREATE PARTITION SCHEMA
.....but as you all know i suck at SQL, so i really dont know exactly how to use this...
January 12, 2010 at 8:53 pm
ifila (1/10/2010)
......Help you i will, oh Jedi master.The force is strong in this one!
Okay, now it has been over 2 days. Have you gotten an answer to your question?...
January 12, 2010 at 7:35 pm
Paul White (1/12/2010)
Lynn Pettis (1/12/2010)
January 12, 2010 at 5:11 pm
BH-428850 (1/12/2010)
January 12, 2010 at 4:43 pm
Viewing 15 posts - 17,461 through 17,475 (of 26,489 total)