Viewing 15 posts - 331 through 345 (of 1,082 total)
ok could I get table definitions in the form a create statement so that I can run a complete script.
thanks
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 16, 2009 at 9:16 am
Sorry I'm still not sure what you want to do???
Could you give me an example.
e.g
Input : "STICHTING WERELDHULP-BELGIE
OUTPUT : "STICHTING WERELDHULP-BELGIE ?
or what ever it is that you want...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 16, 2009 at 9:14 am
I think you missing a bracket in your nested select .
so try this:
Declare @sql nvarchar(MAX)
set @sql = ' SELECT x.SaleYear,...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 16, 2009 at 9:10 am
could you post a before and after example for us please?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 16, 2009 at 9:00 am
could you do a PRINT Of @sql for us so we can see what the code is that is trying to be run.
you might find that delimiting your strings...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 16, 2009 at 8:59 am
Why do you want a having clause?
Is it because you only want to see rows with a duplicate id?
A Having clause is basically like a where clause but it happens...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 16, 2009 at 5:44 am
is this a one off import?
If so then just add that one row seperatly
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 13, 2009 at 7:31 am
are you sure?
I still think it was because you used a select *
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 13, 2009 at 3:12 am
Sorry I have been away and I'm pretty busy today but will try and have a look later
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 12, 2009 at 3:04 am
Are you using that in your access system you have one column that has
'77 or 70 or 81' in it.
And you result is:
'77 or 70 or 81',"'77 or 70...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 11, 2009 at 11:31 am
what error are you getting?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 11, 2009 at 10:28 am
shouldn't be that hard.
Create the function
then replace my solution example, by changing the table name and field name to your table name and your field name, BAMB you should get...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 11, 2009 at 9:37 am
Ok here is my solution.
I've created a function which uses some of the logic from the SQL function I posted earlier only it removes excess 0000 etc.
CREATE FUNCTION dbo.fn_VarbinToHexStringChris
(
@int INT
)
--EXAMPLE
--SELECT...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 11, 2009 at 9:27 am
ah I see, cool well if I get an example from him, it might be possible to write the code to do the opposite:-)
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 11, 2009 at 8:20 am
A tally table is a table that simply has a run of consecutive numbers for more information please read this article:
http://www.sqlservercentral.com/articles/TSQL/62867/
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 11, 2009 at 6:56 am
Viewing 15 posts - 331 through 345 (of 1,082 total)