Viewing 15 posts - 1,456 through 1,470 (of 3,544 total)
Actually, the real reason why I write is because...
I can't remember stuff no mo'.
And you are ? :blink:
lol only kidding Jeff 😉
Keep think about submitting something but can't think...
Far away is close at hand in the images of elsewhere.
Anon.
May 21, 2008 at 7:06 am
cry out “Tally Ho”!
Only when he gets on his high horse 😉
btw Jeff, excellent article, as always 😀
Only the Best eh :hehe:
Far away is close at hand in the images of elsewhere.
Anon.
May 13, 2008 at 7:09 am
Wow! Are the number of QOTD replies getter longer or what :w00t:
There seem to be a lot of strong personalities here :crazy:
Glad I'm not a DBA....
always right, never wrong and...
Far away is close at hand in the images of elsewhere.
Anon.
April 8, 2008 at 6:49 am
smelled a bit like Ice Cream, too
Way... way... too much information Jeff :sick:
Far away is close at hand in the images of elsewhere.
Anon.
March 12, 2008 at 2:55 am
we don't expect to get Jeff Moden in every interview (although, that'd be GREAT)
No but I'll have one for each working day though :w00t:
... I'd like to work with you...
Far away is close at hand in the images of elsewhere.
Anon.
March 6, 2008 at 9:19 am
BULK INSERT / BCP will not truncate/remove trailing spaces on input data, and since you already stated that the data contains trailing spaces and is longer than the column definitions...
Far away is close at hand in the images of elsewhere.
Anon.
January 25, 2008 at 1:44 am
At the moment the issue is that it places the data in the wrong columns leaving blank columns. The data seems to be ok. It seems like it doesnt like...
Far away is close at hand in the images of elsewhere.
Anon.
January 21, 2008 at 2:05 am
I belive you are looking for a PIVOT like this
SELECT[ID],
MAX(CASE WHEN IDX = 0 THEN APP_DEGREE_ID ELSE null END) AS [Degree0],
MAX(CASE WHEN IDX = 1 THEN APP_DEGREE_ID ELSE...
Far away is close at hand in the images of elsewhere.
Anon.
December 13, 2007 at 6:44 am
ORDER BY applies to the result of the UNION not the individual SELECT's so you can do this
SELECT 1 AS [Result]
UNION
SELECT 2 AS [Result]
ORDER BY Result DESC...
Far away is close at hand in the images of elsewhere.
Anon.
December 13, 2007 at 1:47 am
The question indicates a file not a database, don't know is this makes a difference :unsure:
Far away is close at hand in the images of elsewhere.
Anon.
December 12, 2007 at 1:50 am
OK. I'll go to the bottom of the nerd's class 🙁
See if this works better
There are locations (Dealers) that represent a Car Dealership that sells cars. The code for the...
Far away is close at hand in the images of elsewhere.
Anon.
November 28, 2007 at 10:13 am
My most sincere appologies
No need Jeff 🙂
I thought you were making fun of a series of threads that are responsible for the current inflamed crease in my gray-matter
Not me... but...
Far away is close at hand in the images of elsewhere.
Anon.
November 28, 2007 at 7:43 am
What? Oh? OH? OOOOOHHHHH!!! BWAAAA-HAAAAAA.....
Sorry Jeff...
Did not know if you were laughing at me :crying:
or at my question 🙁
or was it that I actually posted one :blink:
Far away is close at hand in the images of elsewhere.
Anon.
November 28, 2007 at 2:36 am
I am not sure what your question is?
Sorry Ron. I'll try to meke it clearer :blush:
Thanks for the reply 🙂
The data is separate by Location, ie the ContactID will unique...
Far away is close at hand in the images of elsewhere.
Anon.
November 28, 2007 at 2:34 am
Good spot Sergiy 🙂
Maybe this instead then
SET @sql = 'select * from [' + REPLACE(REPLACE(@dbname,'[',''),']','') + '].dbo.tblAccounts where [date]=''09/04/1998'''
EXECUTE(@sql)
btw your sql would not work anyway, it is...
Far away is close at hand in the images of elsewhere.
Anon.
November 12, 2007 at 2:21 am
Viewing 15 posts - 1,456 through 1,470 (of 3,544 total)