Viewing 15 posts - 361 through 375 (of 1,082 total)
If you check BOL it says somewhere in there that variables used with the EXECUTE statement get reduced to 4000, what you can do it break your code up.
so...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 6, 2009 at 9:10 am
It's hard to say really,
The size of the tables is a factor.
The indexes on the tables are factors.
How many you have is also a factor.
And obviously how they used.
If you...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 5, 2009 at 9:50 am
Almost impossible to help unless we can see some code.
please read the link below for for advice on posting
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 5, 2009 at 9:37 am
--DELIMIT FUNCTION
--I've made it inline so it performs better when it's joined to
CREATE FUNCTION [dbo].[fn_StringtoTable]
(
@String NVARCHAR(MAX) ,
@Delimiter CHAR(1)
)
RETURNS TABLE
AS RETURN
(
SELECT SUBSTRING(@String+@Delimiter, n,
CHARINDEX(@Delimiter, @String+@Delimiter, n) -...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 5, 2009 at 9:17 am
Ah I see ok cool I'll look into it
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 5, 2009 at 8:59 am
CREATE PROCEDURE p2
(@empid varchar(255) = NULL ,
@dept varchar(255) = NULL,
@age varchar(100) = NULL)
as
SELECT *
from CTS_emp
WHERE (@empid = eno or @empid is null)
AND
(@dept = dept or @dept is null)
AND
(@age =...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 5, 2009 at 5:43 am
thanks I'll let you all know how I do
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 4, 2009 at 9:52 am
I hope you not just saying that cause I'm South African 🙂
no seriously, thanks Gail, you made my day, coming from you that is big confidence booster 🙂
wish me luck...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 4, 2009 at 9:28 am
cool thanks.
I've work with SQL for a few years and with regards to the SQL side and UI of SSMS I think I'm pretty knowledgeable.
I've just done some demo questions...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 4, 2009 at 9:01 am
how long would you say it takes to study for this exam say if you can do 2-4 hours a day?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 4, 2009 at 8:21 am
HI Jack.
OK I've check the:
"Default Connection options" for both servers.
The only difference is that the live server has "concat null yeilds null"
When I check the options under the properties for...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 12, 2009 at 8:54 am
thanks everyone for the help. I'm going to move the first issue to a new topic as I don't think it's related to FOR XML PATH('') so the heading is...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 12, 2009 at 6:28 am
Thanks for the answer to the second question 🙂
With regards to the first question.
The space that is being trimmed or not being trimmed is from the Concatenation
', ' part of...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 12, 2009 at 3:30 am
the Collations on both servers and both db's are the same "SQL_Latin1_general_CP1_CI_AS"
🙁
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 12, 2009 at 2:07 am
I'll have a look at the collation and get back you .
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 12, 2009 at 2:04 am
Viewing 15 posts - 361 through 375 (of 1,082 total)