Viewing 15 posts - 3,031 through 3,045 (of 5,394 total)
On my database we are storing the time in a column which has a datatype set to varchar(max).
Not a good idea, as you may have guessed.
I expect lots...
June 29, 2011 at 3:17 am
Your last SQL statement looks a lot like the first one. What have you tried of my suggestions?
However, this is a SQL Server forum, I'm sure you would get better...
June 29, 2011 at 2:29 am
I just found this one that seems promising:
-- assign value to variable
SET input = 'app1,app2,app3';
-- create temporary table and fill it with splitted values
CREATE TEMPORARY TABLE temp (id TINYINT NOT...
June 29, 2011 at 1:59 am
In my opinion, you should split the values on the application side and then use the tokens in a query such as the one I posted earlier.
If this was SQL...
June 29, 2011 at 1:50 am
I'm not sure this is what you're after (you mention comma separated values in your post, but I don't see it in your code).
If you want to return all rows...
June 29, 2011 at 1:36 am
I suspect this is Oracle SQL, isn't it?
June 29, 2011 at 1:32 am
Koen Verbeeck (6/28/2011)
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congratulations.
I did my very first technical session last...
June 29, 2011 at 1:28 am
Peter1971 (6/29/2011)
Do I need to close the topic, or report as RESOLVED?
This feature is not implemented on SSC forums, which is one of the reasons why I love this site....
June 29, 2011 at 1:27 am
Good news! Glad you sorted out.
June 29, 2011 at 1:24 am
opc.three (6/29/2011)
I'll assume that means that's the actual query...what do we see from this?
INSERT INTO OPENQUERY(linkedserver, 'select a,b,c from remote_table')VALUES ( 10, 20, '30')
I don't expect it to be any...
June 29, 2011 at 1:10 am
Top-notch contributions from you Dave, as usual!
Keep up the great job.
June 28, 2011 at 5:02 pm
WayneS (6/28/2011)
Gianluca Sartori (6/28/2011)
Yeah! 3000 points for me!It's a small step for most of you, it's a great step for me.
Congratulations Gianluca! (Watch the mail for the check that Steve...
June 28, 2011 at 8:39 am
Lynn Pettis (6/28/2011)
Roy Ernest (6/28/2011)
Gianluca Sartori (6/28/2011)
Yeah! 3000 points for me!It's a small step for most of you, it's a great step for me.
Congratulation. Well done. I will never hit...
June 28, 2011 at 7:33 am
Yeah! 3000 points for me!
It's a small step for most of you, it's a great step for me.
June 28, 2011 at 5:12 am
Carlton Leach (6/28/2011)
Gianluca Sartori (6/28/2011)
Carlton Leach (6/28/2011)
...Maybe I'm overly sensitive, but I don't like this kind of comment.
Care to rephrase?
I believe you certainly are...it's a joke.
Yeah, it's a joke....
June 28, 2011 at 4:59 am
Viewing 15 posts - 3,031 through 3,045 (of 5,394 total)