Viewing 15 posts - 31 through 45 (of 64 total)
In this partiqular query there is a a single ccID variable, I explicilty called it 1518 because it was the last one I was working with... thanks for the tip...
March 7, 2003 at 12:43 pm
quote:
Depending on what you're trying to achieve, changing the nulls to zeros may impact the result in a way you dont...
February 16, 2003 at 1:13 am
Thanks for the reply. I never anticipated any problems with this syntax because in fact I have another procedure with some variying paramters that uses the same syntax for...
February 14, 2003 at 5:27 pm
FULL TEXT SEARCHING is an internal SQL feature right? What other engine could you use besides FULL TEXT Search? move the data warehouse to mySQL? :O
-Francisco
February 13, 2003 at 2:39 pm
Thanks for replying with your system set up. I was just curios, you see our System Admin is the one who set up the box and has been fighting...
January 14, 2003 at 11:09 am
that is one impressive database, I don't hava that db but I am curious of your hardware setup, for us on a smaller system wich averages about 30+users and about...
January 13, 2003 at 10:53 am
Thanks for posting such helpful replies, I will try casting the column again, but I know for a fact that it IS a varchar type... but I suppose it...
January 10, 2003 at 9:25 am
Try commenting out the
Exec(@SQL)
and adding the line
PRINT @SQL
this will give you the SQL syntax of how the server sees it, it...
January 3, 2003 at 4:11 pm
Thanks to all for the replies,
I didn't include more of the script as it was basically just
Function Main()
DTSDestination("MyFields") = DTSSource("MyFields")
...
January 3, 2003 at 9:14 am
I'm acctually spitting this into a DTS sql script, I thought the TempTable would only live for the life of the session thus the temptables wouldn't be available for the...
November 13, 2002 at 2:55 pm
Well I took your advise, and fixed it up like so...This runs fine, but I had to append log backups, it's either that or increase the size of the log...
November 13, 2002 at 1:05 pm
of course...
I'll post this out as I have it ...
(code follows)
USE devREDe
SET NOCOUNT ON
/***************************************************/
/* Eliminate Case Repitition...Speed boost*/
/*
if not exists (select * from tempdb.dbo.sysobjects where id = object_id(N'#tCompany'))
BEGIN
DROP...
November 12, 2002 at 3:23 pm
If a sales guy can do any of this, he wouldn't be outta'v a job! I agree that the biggest threat is social engineering/hacking. Many people are more...
November 4, 2002 at 2:05 pm
Ouch!
I see what you're saying... in a sense I'm leaving the entire database wide open! I suppose it would be better to script the columns to digits...
November 4, 2002 at 9:40 am
Viewing 15 posts - 31 through 45 (of 64 total)