Viewing 15 posts - 58,216 through 58,230 (of 59,048 total)
Hi Toni,
Could you post the current code you are using that is coughing up the aborant data, please?
May 12, 2006 at 5:58 am
Beat me to it, Conway... absolutely correct.
May 12, 2006 at 5:55 am
From the main screen, click on [Resources][Discussion Forums]. You will be taken to a screen with different forums. The T-SQL forum seems to be the most popular but take the...
May 11, 2006 at 11:54 pm
Something like this, I would imagine...
SELECT (--Finds count of ALL distinct machine names in the table
SELECT COUNT(DISTINCT MachineName)
FROM yourtable
)
- (--Finds count of distinct machine...
May 11, 2006 at 11:45 pm
Hector,
What does the stored proc do with the command shell? There might be some better ways to do things without have to use command shell...
May 11, 2006 at 9:17 pm
Just an alternative to Pam's good code...
WHERE DATEDIFF(mm,0,src_terrier.datadate) = DATEDIFF(mm,0,@dt_src_date)
AND
(src_terrier.Areacode = @chr_div) AND
(src_centre_list.Portfolio_no = @vch_portfolio_no) AND
(src_centre_list.propcat = @vch_prop_cat) AND
(src_tbl_rental.site_ref = src_terrier.siteref)
May 11, 2006 at 9:13 pm
Mauro,
Just trying to clarify... are you saying that each row of the QueryDescription column contains the code for a complete query and that you want to execute all of them...
May 11, 2006 at 8:47 pm
Mauro, I'm looking at your post right now...
May 11, 2006 at 7:47 pm
Sorry, Mirko... I missed your post from way back in February...
You wrote "I don't need statistics on temp tables, because I usually know enough about their structure and data that...
May 11, 2006 at 7:46 pm
Andy,
THANK YOU, THANK YOU, THANK YOU!!!!!
In the bowels of your code, I finally found what I've not been able to find anywhere else... a replacement for using xp_CmdShell (security risk)...
May 9, 2006 at 1:18 pm
Interesting...
I may have a method that might even beat ASP.Net for performance but I need to know, does your table have an auto-numbering IDENTITY column? And, it doesn't matter if...
May 8, 2006 at 9:28 pm
Too bad... I think this was homework and didn't see where Paul tried...
May 7, 2006 at 4:46 pm
I don't believe it's returning the the latest identity value unless someone put a trigger on the table that does so. Check to see if there are any triggers on...
May 5, 2006 at 9:40 pm
Sorry Kenneth... didn't exactly return the favor.
My Tally table is 9999 rows, single "n" column is INT with a Clustered PK.
The million row test table is made up of 6...
May 5, 2006 at 7:19 am
Viewing 15 posts - 58,216 through 58,230 (of 59,048 total)