Viewing 15 posts - 826 through 840 (of 1,082 total)
HI There,
What compatability mode are you in 80 or 90?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 11, 2008 at 10:40 am
OK ...
I'm getting confused now, the results change all the time, sometimes the one is faster the sometimes the other one 🙁
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 11, 2008 at 8:00 am
Please provide the query?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 11, 2008 at 7:22 am
HI All,
Here is a little test I have just done.
SELECT TOP 1000000 *
FROM CTSTest a
INNER JOIN CTSTest b
ON b.RowNum = a.RowNum
SELECT TOP 1000000 *
FROM CTSTest a,CTSTest b
WHERE b.RowNum =...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 11, 2008 at 6:57 am
Hi Grant,
I don't think you should give up so easily because I posted a few months ago about ON and WHERE clause and the consensus was that it can makea...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 11, 2008 at 6:37 am
Thanks for that.
I'm actually look for more of an Analytical question rather than tech skills questions...
For example giving them puzzles to see what there approach to problem solving is like.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 11, 2008 at 6:26 am
Very strange, it seemed to work for me I think he he he
well good to see you got it working thats the most important thing 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 10, 2008 at 7:32 am
HI,
This is because when you concatenate your variable to your dynmaic string you are adding this:
o'Brain
You want to be adding o''Brain
This means that once you have your variable you should...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 10, 2008 at 7:15 am
DECLARE @vcSearch VARCHAR(100)
DECLARE @vcObjectName VARCHAR(100)
DECLARE @vcObjectType VARCHAR(100)
SELECT
@vcSearch = ''
,@vcObjectName = ''
...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 10:44 am
Thanks Jeff 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 10:25 am
ooops now I see...
that only works for 2005,
for 2000 you need to use syscomments and thats when Jeffs beware comes into place
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 9:57 am
HI Jeff,
Sorry you lost me on the column name there?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 9:43 am
he he he
no problem.
I've extended it as follows:
DECLARE @vcSearch VARCHAR(100)
DECLARE @vcObjectName VARCHAR(100)
DECLARE @vcObjectType VARCHAR(100)
SELECT
@vcSearch = ''
,@vcObjectName = ''
,@vcObjectType = ''
SELECT DISTINCT
so.Name,
CASE WHEN so.xtype = 'p' THEN 'PROCEDURE'
WHEN...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 9:35 am
Hi,
Instead of scripting all you procedures you could use this:
SELECT
o.Name as [Procedure Name],
c.text as [Procedure Text]
FROM sysComments c
INNER JOIN sysObjects o
ON o.Id = c.Id
WHERE
[o].xType = 'P'
AND
c.text LIKE...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 9:03 am
HI ,
I guess the first question is, do you have to use dynamic SQL and why?
Secondly why do you not want to use the REPLACE function?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 8:56 am
Viewing 15 posts - 826 through 840 (of 1,082 total)