Viewing 15 posts - 91 through 105 (of 1,082 total)
and what is your expected output?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 9:59 am
happy to help 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 9:08 am
how about creating your queries dynamically based on the columns they choose?
After they select the column you will know what tables they want and ifyou have acustom table that defines...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 8:37 am
I think the sign function may slow things down as it would result in a function being run on a column in your where clause which will affect the use...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 8:22 am
Sorry I'm a bit confused.
If all the code that you posted is uncommented is all of that code inside your function?
The second thing is you should be aware that having...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 5:37 am
From reading books online it looks like error Number 50000 is generated from a Raiserror command when no error number is specified.
You might want to search though your code for...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 5:13 am
Hi Derek,
Could you post the code with some sample table and table/index definitions
And the code that runs you TVF as well please 🙂
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 5:04 am
I'm not 100% sure but I think it's because you have an UPDLOCK within the transaction.
Have you tried removing that table hint?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 4:18 am
Please be more specific about your problem?
Please read the link below in my sig for advice on Posting Best practices 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 8, 2009 at 2:32 am
Count you not just have table that has new rows inserted into each day with the total count(*) at the end or beginning of that day?
That way you could...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 5, 2009 at 10:23 am
Looks like confusing running around this thread.
I think what the OP mean't by no time was '00:00.00' which is actually still time, it's just the beginning of the date.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 5, 2009 at 9:36 am
Hi Steve,
Another suggestion is that when you actually viewing your full list that you can select all. rather than having to tick every single topic you want to unsubscrbe from.
The...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 5, 2009 at 9:25 am
EDIT -- Sorry was thinking of the wrong thing.
you might want to create a dynamic query for this type of problem
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 5, 2009 at 6:17 am
bad answer...
VARCHAR(1) is most definitly not the BEST answer, it should be char(1) or nCHAR(1)
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 5, 2009 at 5:46 am
Hi Jack,
Yeah I saw that one as well, first thing that I thought when I saw him say
I'm quiet new to sql but I have already made a few nice...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 3, 2009 at 9:43 am
Viewing 15 posts - 91 through 105 (of 1,082 total)