| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> Nope, it appears to be used for somthign else in Access
<0> Oops, maybe not. The help file was misleading
<0> :)
<1> :)
<0> Thanks for your help everyone. I'll be back later. :)
<2> oh please don't
<0> I think I finally got it working
<0> It works on a local test database that I just created. VPN is crap and wont let me access the database, and its too beautiful today to go into the office. Thanks for everyone's help
<3> vension: anything excel will let you do...not exactly related to excel (like Range()), access (or any other office app) can do
<0> Thats cool
<3> just fyi
<3> vba is generic...except where it's not generic :)
<0> hehe
<4> hi
<0> IS there any down sides to this? Since it's doing the 'hard work' on my pc instead of the server?
<0> Hello daniela--
<4> I create tables, insert some columns,then run "select * from table" and I get "invalid object name 'tablename' "
<4> I've googled, and it';s a MS SQL server issue, but i don't get how to fix it
<4> I have 2005 MS Sql server
<3> daniela--: I doubt anything you are hitting is a sql server issue
<5> my computer froze
<5> did I miss anything?
<2> yes
<5> what?
<2> wish you were here
<1> you have probably created the tables in a schema other than the one you are querying in
<2> to see it
<6> <4> I create tables, insert some columns,then run "select * from table" and I get "invalid object name 'tablename' "
<6> daniela-- - that usually means that you the table belongs to another "owner" or "schema"
<2> how do you select from `table` and it tells you invalid object `tablename`
<6> and you're not using the schema
<6> in sql 2k it would be owername.tablename
<6> and in 2k5 its schemaname.tablename
<5> i also ran select * from dbo.tablename
<5> ah
<7> SELECT * FROM INFORMATION_SCHEMA.TABLES
<5> be right back
<2> http://www.islandtactical.com/index.asp?PageAction=VIEWPROD&ProdID=85445 pretty
<4> ok, what's the difference between order by and group by?
<6> one orders by
<6> and one groups by
<6> huhi
<6> order by orders the data
<6> and group by singles it out by groups
<4> it doesn't singles it out, it still returns same rows
<4> -s
<8> no it doesnt LP
<8> only incase when you have 1 row in each group
<4> i used the query analyzer and it appears to return the same result set
<4> i don't see any groups here
<4> I entered duplicate data, just to see if it makes a difference
<8> haahah
<4> it doesn't
<4> am I missing something?
<4> group by leaves out duplicated data?
<4> is that all?
<2> yes
<2> you're confused
<2> group by makes logical groups based on conditions
<2> if you don't understand the word `group` please refer to a dictionary
<4> :D
<4> i understrand it, but the query stillselect one big group of data, i don't see smaller groups in it :P
<4> i might be confused.
<8> you need to read between the lines to see the groups
<8> try harder
<4> now this is something that I;m bad at
<4> reading between the lines
<4> weird...
<4> this is the second time today I;'m told to read between the lines...
Return to
#sql
or
Go to some related
logs:
#windowsxp
black and white photo to colour
#politics
#linuxhelp
#hardware
#worldcup
sp_shellexec
#goal
#linuxhelp
fluke network inspector : setup.exe
|
|