| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> Toadstool read the information you were given when you joined the channel
<1> is it possible to make system functions in sql 2k5?
<2> system functions?
<1> yeah, so in database foo, i can to SELECT fn_MyFN() and fn_MyFN exists in master
<1> basically this... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01l1.asp
<1> in sql 2005
<2> Try adding it to the sys schema?
<1> no dice :(
<2> Might not be possible. This article looks like a hack.
<1> The specified schema name "sys" either does not exist or you do not have permission to use it.
<1> do you know if i can write a function in master that access the information_schema of the context database?
<3> halo there?
<2> nope
<3> quick question
<3> you know how output window subscribes to debug.write and trace.write
<3> say my windows service will call those methods. how can an external app subscribe to that
<2> ITraceListener
<2> external apps can't
<2> Not unless you expose somehthing for them to connect to
<2> Look at log4net, it has that kind of crap buit into it
<2> built
<3> how does VS do that
<2> VS is a debugger, it's magic
<3> hehe
<3> remeber in vb6 if app.PrevInstance then DIE
<3> how to do the same in .net
<4> easiest way to kill a .net app is app.run
<3> meh
<3> jarett, killing is the easy part. need to determine whether another instnce is runnin
<5> MSSQL: I have 2 tables. TableA has a list of users. TablePhotos holds all the photos for each user. I want
<5> to order the results of my query to order in a manner that users with photos come up first. Does anyone know how I could go about this?
<5> I am not looking for the answer just a function that I can look into to get the answer
<4> a[K]a, order by
<5> I use order by a lot
<5> but I am selecting users from tableA
<4> and?
<4> ever hear of a join?
<5> and I need to somehow count how many entries in tablePhoto that the user has
<5> yeah I know what a join is
<4> you dont need to count
<4> do you care about number of photos?
<4> or just that they exist?
<5> just exist
<6> a primary key can also be a foreign key, can't it?
<0> sure why not
<0> why don't you test first before asking
<0> it gives you some hands on knowledge
<0> better way to remember things in my opinion
<7> hi does anyone know if sql 2005 express has http-soapxml support like sql2005 standard?
<0> let me google that for you chen`chen
<0> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
<0> it would appear express keeps all of the xml support and other features
<0> I would imagine if standard has it express would as well
<7> oh thanks a lot darken, there is this "Web Services End Point" , seems that only standard and enterprise has that
<0> yea
<7> i wonder if, is it so bad to do business logic inside sql since i can expose it as webservice
<5> if I am doing a left join on a table can I set a field to 1 or 0 depending on whether the left join table has a result?
<5> basicly is there a way to set a field to 1 or 0 if in table1.id = table2.id
<0> yes
<5> sweet
<0> where is this field
<0> and call it a column please
<0> we're not reading from text books here
<5> ahh sorry
<0> :)
<0> row column, easier
<5> I figured it would be a field since it is one element of a coloumn but yahdah yahd
<5> whatever... I am nebie
<5> where is this field <-- what do you mean?
<0> what table
<0> you could do an outer join comparison
<0> a case comparison on the update column
<0> many ways to achieve this result
<5> property has a unique key of 'property_id' and property_photos is the table I need to check if there is an entry or not
<0> ok
<0> if there is an entry based on what constraint
<5> if there is an entry in the property_photo with the same property_id as in the property table
<5> so essentially I want to check if the property has a photo or not
<5> some have more than one
<5> and if it does have a photo then set a field to 1 on the output
<5> you understand what I am trying to do?
<5> brb
<8> augh
<8> my developers **** ***
<8> pharking idiots don't even clean up thier changes in thier own enviroment.
<8> trying to re-establish a FK and getting type differences...
<8> the sql server is partially to blame though, for allowing them to change datatypes after an FK relationship has been established already.
<8> or they ignored the error(s) and went about thier merry ways...i dunno. i gotta go test and see what happens when you change a FK datatype...
<8> still, phucking idiots.
<3> a[k]a you still need help?
<5> hrmm yeah I still can't get it
<3> ok so what do you need
<5> I am trying to do a case comparison
<3> what do you need to do?
<5> let me try to explain what I am trying to do and maybe you can see the best way to do it
<3> zzZzzzzzzZzzz
<5> sorry
<5> writing it out
<3> rofl
<3> http://www.compfused.com/directlink/1208/
<5> I have a table (property) and a table (property_photos). I want to select the properties in alphabetical order of the property_name. But I want to show the properties with photos first and then the ones without second.
<3> easy
<5> I don't have enough experince so I am probably over doing it
<3> mmmk
<5> so some items in properties don't ahve entries in property_photos
<5> property_id is the key
<5> what are you thinking about ;)
<3> ok i guess like this
<3> select PropertyID from Properties LEFT OUTER JOIN Photos on Photos.PropertyID = Properties.PropertyID group by PropertyID order by case when count(*) > 1 then 1 else 0 end,Property_Name
<3> no
<3> select PropertyID from Properties LEFT OUTER JOIN Photos on Photos.PropertyID = Properties.PropertyID group by PropertyID order by case when count(PhotoID) > 0 then 1 else 0 end,Property_Name
<5> let me try that
<3> actually
<3> select PropertyID from Properties LEFT OUTER JOIN Photos on Photos.PropertyID = Properties.PropertyID group by PropertyID order by case when count(PhotoID) > 0 then 1 else 0 end DESC,Property_Name
<0> haha
<7> hi i installed sql2005 standard without uninstalling sql2000, now i have no idea how to start sql2005 db engine
<0> read the manual
<9> http://pastebot.nd.edu/551
<9> Can anyone see if there is a problem with that. I'm looking at it and I'm not seeing one, but I'm told there is a problem with it. :)
<0> use our paste site
<0> please read the rules
<9> I thought it was more of a suggestion and not a rule.
<9> I thought the "don't paste SQL in channel" was the the rule, the url was the suggestions
<0> rule to me
<10> hard ***
<0> i don't use other paste sites
<0> among the other rules i don't type out for every single person
<0> which is why we have a bot tell you the rules
<9> hha
<9> that was meant to be me laughing
<9> what if I put up a URL to a txt file that I uploaded to my website...
<9> is that against the rules?
<0> not against the rules
<0> and yes
<0> the paste site is a suggestion, you don't have to use it
<0> matter of fact, you don't have to use this channel either
<9> I don't have to. I don't know exactly what I'm -using- the channel for right now even beside getting the petty #sql riot act read to me
<0> that's fine
<0> take a suggestion then
<9> Indeed
<0> you make a suggestion into an issue
<3> darken
<3> did you laugh cause the bastard didnt evne thankx me?
<11> is sql server 8 = sqlserver2k5 express?
<12> no, 8 is sql2000
<13> 9 is sqlserver2k5
<11> I tried to install sql2k5 express on a win2k3 server with sql server 2000 msde. Upgrade was available so I chose that. But when I launch SQL Server Management Studio Express it tells me that the server connected to is sl server 8
<11> how to remove sql server 2000 msde?
<14> uninstall
<11> how? it isnt possible in add/remove programs
<14> there's no uninstall function for sql server in your add/remove programs list?
Return to
#sql
or
Go to some related
logs:
win hockey prolines
#c
#wtf
#politics
#stocks
#computers
#ubuntu
netdirectv4
hockey chan
#politics
|
|