Viewing 15 posts - 13,471 through 13,485 (of 15,381 total)
So why not just use the result set as your datasource? The user does not know, care or understand how you got the data there. Basically you have to take...
November 18, 2011 at 1:52 pm
If you want them separated with carriage returns why can't you just return them in the rows they lie in naturally?
Assuming the above won't work, how do you know...
November 18, 2011 at 1:33 pm
manssourianm (11/18/2011)
thanks for that, i looked around your site, could only find an article called 'Dynamic SQL and SQL injection' and that didn't seem to apply to my case... 🙁
The...
November 18, 2011 at 1:30 pm
How can a select into statement make the create table contain alter statements??
select ColumnListIncludingAnyAliases into MyNewTable
from ThisIsNotTheViewButARealTable
join another table
join yet another...
November 18, 2011 at 1:09 pm
That is odd. I have never seen that happen. Can you just make your select into use the code from the view instead? Might be easier than trying to figure...
November 18, 2011 at 12:32 pm
Gail has a great blog post on this very topic. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
November 18, 2011 at 12:10 pm
I am not sure what you question is. You are trying to use select into to create a new table. What does the alter table statement have to do with...
November 18, 2011 at 12:07 pm
Koen Verbeeck (11/18/2011)
ChrisM@Work (11/15/2011)
Lowell (11/15/2011)
(He or She) clicks the Instant 30 seconds button, waits 10 seconds, watching the count down,...
November 18, 2011 at 8:29 am
Evil Kraig F (11/17/2011)
Sean Lange (11/17/2011)
I call it job dating. Both sides get a predetermined amount of time to see if they like each other before "going steady". 😛
Great, thanks...
November 17, 2011 at 2:55 pm
I call it job dating. Both sides get a predetermined amount of time to see if they like each other before "going steady". 😛
November 17, 2011 at 2:51 pm
Your cartesian is because you are not using current join syntax on your two tables.
FROM
TEMP_FILTER_BY_DATE T1, TEMP_NO_FILTER T2
This is the old type join and will create a cartesian when you...
November 17, 2011 at 2:48 pm
psjrw (11/17/2011)
Thanks for the advice. Its my first time on a forum. I read the Etiquette. B Better next time. I'll try the Application variable.thanks,
Not sure...
November 17, 2011 at 1:36 pm
GSquared (11/17/2011)
p-nut (11/17/2011)
Is there a reason this OP has posted this 3 times and we all seem to keep replying to it? 🙂Jared
All of us are bots. Aren't you?
All...
November 17, 2011 at 1:29 pm
And if at all possible store your data as datetime instead of multiple varchar columns. Dates as string is fraught with hair pulling data inconsistencies and conversion challenges.
November 17, 2011 at 1:17 pm
psjrw (11/17/2011)
November 17, 2011 at 12:41 pm
Viewing 15 posts - 13,471 through 13,485 (of 15,381 total)