| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> yes or no
<1> I need NULL instead of Perc value
<0> ok
<1> my main goal
<1> is to get Perc for a part
<1> and if there is no percent (Perc) value for a specific customer and supplier
<1> so I need to get NULL anyway
<0> http://sql-servers.com/nopaste/?show=215
<0> try that
<1> I don't think that query will work on MSAccess
<1> 1 min I will check it out
<1> syntax error in query expression
<0> where
<0> then you've got problems
<0> it's a correct sql query as far as i see
<1> yes
<1> MS Access needs special brackets
<1> and special organizing of multy joins queries
<1> look...
<1> look at my query
<1> it's correct and it works
<1> all I need is to replace last 2 inner joins with left outer joins
<1> right ?
<1> I replace them, and I get error JOIN expression not supported
<1> at first, I don't understand why?
<0> that's your problem not mine
<0> get a fully functional sql engine
<2> how do i write a self join when using an inner join, i keep getting a syntax error?
<1> well
<1> thanx for trying to help me
<3> How do i create a unique column in SQL Server 2000? i can only find "Primary Key"
<0> with the gui or tsql
<3> does the Data View thing create Foreign key's automaticly?
<4> anyone know why i would get String or binary data would be truncated.The statement has been terminated.
<4> when im inserting an image into SQL 2K
<0> because the destination column length is shorter than the source?
<4> so the file is to big?
<5> is there an easy way to copy a database in mssql?
<0> export wizard
<0> is pretty easy
<6> backup/restore
<0> Gm0nEy : because the destination column length is shorter than the source?
<0> interpret it however you wish
<4> no it was that the type was set to binary and i was inserting Image
<4> but what is the diffrence?
<5> thanks for the help!
<0> truncation is that exact definition Gm0nEy
<0> check the lengths/limits for your specific rdbms
<4> and yet another stupid question how can i tell if the column has been writen to all it says is <Binary>
<7> ok i know this isn't exactly an SQL questin... but i figured i could find some ACCESS users here... i inserted a image into a form in access... now i watn to resize it without losing the proportion of the image... like in adobe when your resize something it looks the same as it does big or small....
<0> i would try to read the length of the column Gm0nEy
<0> i wouldn't try to output binary as text
<0> it'll look ugly
<4> speaking of length limits can i change lenght of a text type (to make it hold more)?
<7> anyone :(
<4> btw thanks for the advice Darken_
<0> i'm not aware if you can, obviously that'd depend on each rdbms implimentation
<7> darken do you know?
<0> id look for a datatype which has a limit which fits your need
<0> xchaos i only answer sql questions here
<0> not visual formatting in access
<0> check the access manual
<4> thanks again..
<8> curious is there a way in sql server 2000 to recognize holiday days? i'm pretty much tryin to populate a table with holidays goin back 3 years
<4> i'll look at what you have sugested
<7> i did
<0> Disabuse not that I know of, you'll have to make your own procedure to do this
<0> if anything oracle would have something so obscure as to know holidays
<0> :P
<0> nothing else
<8> hehe
<0> oracle will tell you your current emotional state for any given day
<0> it has a bunch of rather obscure functions
<0> adds a lot of bulk
<8> how about when your girl is on the rag?
<0> it does that too
<8> lol
<0> based on statistical input
<9> select happiness() from dual;
<0> it will tell you future outputs
<0> of rag ranges
<4> lmao
<8> hehe
<4> you can market that
<4> make millions
<0> we'll make a documentary of the product
<0> and call it from rags to riches
<4> nice
<4> how poetic
<4> that would be good though i would know when to come home late fromwork
<0> lol
<0> im out
<4> later
<3> Okay, http://sql-servers.com/nopaste/?show=216 so i get an error like this: Erro 409: The ***ignment operator operation cannot take a text data type as an argument.
<3> I use SQL Server 2000, it is probably a silly error. but please tell me where to look and ill try find it! :)
<9> text and varchar are not they same thing. You probably don't mean text.
<9> Look up the data types in the bol.
<3> Drk`Angel: i have "text" in the tables aswell.. :/
<9> More than likely in error.
<9> And its just going to get worse and more annoying if you don't change it.
<3> oh
<3> now i found it :D
<3> @Unread text OUTPUT
<3> thats an int :)
<3> thank you for clearing my mind!
<3> Drk`Angel: but i still got that error "now its just less text!" :)
<9> I already told you why.
<9> The text data type is odd to work with.
<3> okay.. what could i else work with that can store big texts?
<9> If you think you have to use text, there's a bunch of functions for manipulating the data.
<9> Look them up in the bol.
<3> what is "bol"
<10> @ bol
<11> bol = Books Online http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en#filelist ;Start - Programs - Microsoft SQL Server - Books Online
<3> oh! thank you!
<12> Anyone have any ideas for me... I am trying to restore a database on a win2003 box running MS SQL2k. We have done this dozens of times before but now the restore just hangs. No errors in the event viewer.
<12> I ran a profile trace and I don't see any activity.
<6> Keyman01: hangs means sits there and does nothing ?
<12> yes
<12> No bars in the progress window...
<6> how long did you wait ?
<9> Should add the link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp to bol. Its less annoying than downloading and installing :)
<12> 2 hours
<6> and how big is the db ?
<12> 23 gig
<12> Shouldn't I see some activity in the profiler?
<10> @+ bol http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp
<11> Updated key bol = Books Online http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en#filelist ;Start - Programs - Microsoft SQL Server - Books Online http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp
<6> i am able to restore 60gb in under an hour, but that's on dual xeon, 2gb ram
<6> is there enough disk space for the restore ?
<12> Yes.. I cleared out the old MDF and LDF
<3> @Message=MessageBox.Message thats the line causing my error ...
<12> plenty of room
<6> not sure about that one, i know the restore is very slow
<12> I would be happy if I saw the progress bar or activity in the profiler.
<6> yea
<3> http://sql-servers.com/nopaste/?show=217 this gives me "Error 107: The Column prefix tblMailMessage.."
<13> Is there a way to make a MSSQL 2005 setup redundant without using microsoft cluster services? database mirroring?
<13> I just need one active
<13> Microsoft cluster service is a bit expencive, needing 2000/2003 advanced servers, sql enterprise edition (Might only need standard with 2005)
<3> on this code http://sql-servers.com/nopaste/?show=218 i get the following error: "Error 107: The column prefix 'tblMailMessages' does not match with a table name or alias name used in the query." and this is my table structure: http://frw.se/sql/struct.png
<14> I'm trying to optimize a database with a very deep hierarchical structure - is there anywhere online to look for general info about optimal ways to implement different types of data-structures?
<15> in mssql, is it more efficient to filter out in the join, or filter in WHERE?
<15> select * from X join Y on Y.propertyName = 'Name' vs. select * from X join Y where Y.propertyName = 'Name'
<16> tenfour
<16> explicitly state what type of join you are talking about
<16> first off
<15> http://sql-servers.com/nopaste/?show=219
<15> that's the query
<17> ah interesting.. those pkm search daemon filters console error message *do* mean something
Return to
#sql
or
Go to some related
logs:
#computers
#windows
rast gasser holster
pirut connection :0.0 refused
#beginner
#politics
#flash
eth0 whatis
#online
curling Sweden-switzerland torino
|
|
