Viewing 15 posts - 11,761 through 11,775 (of 15,377 total)
flashykez (6/4/2012)
June 4, 2012 at 8:18 am
weisen678 (6/4/2012)
now, I come back to this project, I tested on the code you created, then I get this error message
Msg 213, Level 16, State 1, Procedure InventoryLow, Line 4
Column...
June 4, 2012 at 8:16 am
Jeff Moden (6/2/2012)
Sean Lange (6/1/2012)
Tables in sql are by definition an unordered collection of data.
Heh... I've heard that. 😀 However, while that is the general mantra of database...
June 4, 2012 at 7:57 am
Stefan Krzywicki (6/1/2012)
Sean Lange (6/1/2012)
Stefan Krzywicki (6/1/2012)
SQLRNNR (6/1/2012)
Stefan Krzywicki (6/1/2012)
Revenant (6/1/2012)
Stefan Krzywicki (6/1/2012)
Cath Trimble (6/1/2012)
By the way, the houses near the tech center sure are expensive - about $250,000...
June 1, 2012 at 12:22 pm
Stefan Krzywicki (6/1/2012)
SQLRNNR (6/1/2012)
Stefan Krzywicki (6/1/2012)
Revenant (6/1/2012)
Stefan Krzywicki (6/1/2012)
Cath Trimble (6/1/2012)
By the way, the houses near the tech center sure are expensive - about $250,000 and up I think?...
June 1, 2012 at 10:46 am
aureolin (6/1/2012)
You could do something like:Where left(Diag1,3) > 'C00' and left(Diag1,3) < 'C97' ...
This would be non-sargable so performance could very easily become a big issue.
or you could create a...
June 1, 2012 at 10:13 am
Yes what will work as a solid performance enhancement for sql server may not be the same in Oracle. For example in Oracle it might be better to use a...
June 1, 2012 at 9:48 am
michaelh-731356 (5/31/2012)
INSERT INTO @Authors (AuthorName)
SELECT AuthorName
from tblAuthors
ORDER BY AuthorName
However in SQL 2012, the Authors are not inserted by the Order...
June 1, 2012 at 8:45 am
Your issues could be slightly different than mine.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.PSFDOC'.
Seriously you know better by now. Maybe somebody else has a new one...
June 1, 2012 at 8:35 am
Well you didn't mention that this was an attempt to learn a concept until quite late. Regardless the same need for ddl and such still exists. Just because it is...
June 1, 2012 at 8:07 am
I also heard it's been called the "wifebeater" in America because it makes the rednecks too drunk
ROFL!!! Now that is an urban myth over there. There are two major...
June 1, 2012 at 7:39 am
weisen678 (5/31/2012)
I am quite new to SQL.
but at the begining, I have said, this is my study project, so, the tables are my real enviornment. there are three tables,
product...
May 31, 2012 at 6:09 pm
No problem. I am about to wrap up for the day too.
May 31, 2012 at 3:53 pm
dallibabs (5/31/2012)
The script above works fine and returns the results I need for one category (73) but I would like the results for lots of categories so instead of just...
May 31, 2012 at 3:42 pm
I don't quite follow what you are trying to do but I suspect that what you have here is pretty close. You can change that select to be a an...
May 31, 2012 at 3:00 pm
Viewing 15 posts - 11,761 through 11,775 (of 15,377 total)