Viewing 15 posts - 496 through 510 (of 702 total)
Jan asks
... do you actually have Excel installed on your machine?
I thought of that but didn't dare dip my toe in that pool. How funny would it be if...
May 20, 2009 at 4:01 pm
GilaMonster (5/20/2009)
Grant Fritchey (5/20/2009)
May 20, 2009 at 10:55 am
I don't known for sure why this would behave differently as a job rather than from QM, but it may be part of the problem that the BEGIN TRANSACTION at...
May 19, 2009 at 6:11 pm
Bruce W Cassidy (5/18/2009)
Bob Hovious (5/18/2009)
Mr. Wilbur said RANK()rank() over (partition by s.objtype order by (s.usecounts) desc) as UCRank
[font="Verdana"]Erk. He did too!
Okay, key difference is this:
SQL Server Books Online
May 18, 2009 at 6:41 pm
🙁 Perhaps someone here with more experience than I can help with this one on the 2K/TSQL forum. I asked for more data after the...
May 18, 2009 at 5:49 pm
I'll ask around on this. To summarize: You have a stored procedure that gathers data somehow, then loops with a cursor to insert that data into table run_stats....
May 18, 2009 at 5:37 pm
Paul White (5/17/2009)
Lynn Pettis (5/16/2009)
O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?Deja vu!!!
Good find, Paul. I couldn't...
May 17, 2009 at 10:37 pm
Since we're tying this international community together, here's my home neighborhood in San Francisco.
The original home of St Mary's College, now in Moraga, was sub-divided and...
May 15, 2009 at 3:20 pm
GilaMonster (5/15/2009)
GSquared (5/15/2009)
Gail: Check out the second story on this page[/url]. You'll get a chuckle out of it.
Hehe. That's not an uncommon comment. I showed someone a photo...
May 15, 2009 at 11:47 am
Can you post an example of what's happening? I tried to create your scenario with this code: create table #temp (Descript char(10), Amount money)
insert #Temp
select 'Something', 123.25 union all
select...
May 14, 2009 at 12:05 pm
One more freeware option would be ExamDiff.
May 14, 2009 at 10:51 am
Please be careful using ANY advice from an open forum such as this one without testing it first. The algorithms offered so far are severely lacking in accuracy. Although...
May 13, 2009 at 8:13 pm
Hmmm. So which error is it (you apparently mixed them up, saying 'null violation error' msg 2627)? If it is error 2627, it's saying that you're trying to insert...
May 13, 2009 at 6:10 pm
**** sigh. Spent too much time making up examples, so RBarry beat me to the answer....Here 'tis anyway****
I don't recognize the HexToChar() funciton.
String matching wildcards with the LIKE comparison...
May 13, 2009 at 4:10 pm
Viewing 15 posts - 496 through 510 (of 702 total)