Viewing 15 posts - 8,581 through 8,595 (of 10,144 total)
john.arnott (4/3/2009)
Chris Morris (4/3/2009)
GSquared (4/3/2009)
Anyone else have any ideas on this?
There were two other ideas which I've not had time to follow up yet. The first was to derive an...
April 5, 2009 at 7:09 am
jsanborn (4/2/2009)
using a case statement to include multiple columns simultaneously when zero is encountered will not work.
Not so. Here's a solution using just that:
drop table #test
create table #test (
ID int...
April 5, 2009 at 7:00 am
KTTHOOL (4/4/2009)
The problem is that the SQL SERVER 2005 stores in yy/dd/mm format.
No, the problem is that you think it does, and it does not. SQL SERVER 2005 stores dates...
April 4, 2009 at 5:07 am
WHERE exists (select USERID from dbo.tblUserdesignees)This will return true if there are any rows in the table dbo.tblUserdesignees.
Do you mean this?WHERE EXISTS (SELECT 1 FROM dbo.tblUserdesignees WHERE USERID =...
April 3, 2009 at 2:14 pm
Bob Hovious (4/3/2009)
Both "Ping Pong Ball" and "Elephant" have three vowels.
Both "Ping Pong Ball" and "Cricket" contain the letter "I".
Elephant and cricket each have one bowel. Dumbo and...
April 3, 2009 at 10:51 am
GSquared (4/3/2009)
Anyone else have any ideas on this?
There were two other ideas which I've not had time to follow up yet. The first was to derive an average slope for...
April 3, 2009 at 10:23 am
Thang.Nguyen10 (4/3/2009)
As you suggested, I start running your script in Dev environment (where I am the only user) at 10:11am and now is 11:09am, the script is...
April 3, 2009 at 9:17 am
GilaMonster (4/3/2009)
Looking at the nicely cleaned up version posted by Chris (Thanks Doc) part of your problem is fairly easily apparent.
You're welcome, poppet.
Next thing I'd do is test out some...
April 3, 2009 at 8:53 am
Anye Mercy (4/3/2009)
Guys & gals, I think it's time to stop feeding the troll.
Shhhhhh.... he's asleep, let's keep it that way:satisfied:
April 3, 2009 at 8:10 am
Let's start at the beginning. You will want to test any suggestions without affecting the data, so I've stripped out the INSERT part leaving the SELECT which feeds it. Some...
April 3, 2009 at 8:01 am
GilaMonster (4/3/2009)
Chris Morris (4/3/2009)
No need, Barry - somehow in my misspent youth I managed to "satisfy the requirements" for a PhD. GF bullies me to use the title.
So we need...
April 3, 2009 at 7:43 am
panpaliachanchal (4/3/2009)
I have used for navigation code. But It takes a long time.
I can't used stored procedure because my condition...
April 3, 2009 at 7:06 am
panpaliachanchal (4/3/2009)
I have used for navigation code. But It takes a long time.
what is SP. (You can do all your...
April 3, 2009 at 6:06 am
panpaliachanchal (4/3/2009)
My database consists of 60 tables & 50 views.One single table contains nearly 6,00,000 records.
When i use Adobd.recordset to fill it takes a long time .
Why do...
April 3, 2009 at 5:12 am
Viewing 15 posts - 8,581 through 8,595 (of 10,144 total)