Search results for query: *

Hi, I have a requirement to update mutiple rows in a table if their ItemID exists in a comma delimated field eg. 23,22,21 One method have been using is to use a split user defined fucntion that returns a resultset allowing me to use "in". When I use the code below I get the "Subquery...

Hi, I have the following SP which I would like to return a total of the JourneyDuration field for a each day in the search criteria. I also then want to change the JourneyDuration value from seconds to hours. i.e divide by 60 twice. Everything works fine until I try and perform the above...

Hi, I'm doing some testing reqarding db connections and something is driving me nuts! I'm checking the connections made to sql via sp_who2 and using a console app is VS2005. This is the simple code i'm using, that as far as I know should open and close the connection fine...

Hi, I've recently been testing the Atlas framework and wanted to see what everyone else thought about it. I'm thinking about implementing it heavily on a new project and wondered if anyone had come across any problems in a production environment. After coding Ajax manually it does feel...

Hi, I took the plunge and forked out the hefty whack for the above bluetooth mouse and keyboard set. Got it home and everything installed first time and I was well impressed. It looks that absolute nuts and is excellent to use, it really is. Until.....for some reason one day (about three...

Hi, I have a SortedList that contains the key field and on object (which has 8 fields within). I can bind this fine to a datagrid and see the 8 fields via the bound columns. Works great. What I would like to do however is sort the data by one of the eight fields before i bind it to the...

Hi, I have tried to find the answer to this on google on here. Maybe I've had too much coffe but no luck. Anyway, I want to find and change the IP address for my local SQL Server. I am sure I have found this before in a file in the SQL Server program files, but I cant for the life of me...

Hi, I have heard mentioned that having outbound links on your page will lower the pages overall page rank. I.e. you pass on a portion of your PR. For example. If my home page has a PR of 2 and it has two outbound links, does that mean if I remove them after I get re-indexed I would have a...

Hi, I need to store one field from every row of a result set in a single variable. EG Resultset, 1 Jo 2 Frank 3 Sid @variable = "Jo Frank Sid" I know I could do this using a cursor but understand this is a bad option. Thanks in advance, John Find out you can improve your plant...

Hi, I have an application that stores well formatted XML in a varchar database field. This works fine when I'm working with the data in c# as I can extract the field and interrogate it as an XML document using nodes etc. My question is this, is it possible to interrogate the XML string in...

Hi, I'm just wondering how much better it is for search engines to read / access your pages when you have: A lean page of structural XHTML with a referring CSS for all style. Instead of a XHTML page that has inline styles, fonts etc I know that JavaScript can cause problems in the head...

Hi, Is it possible to use strongly typed datasets with SQL reporting services?? I currently have the report working in crystal but prefer RS and would like to transfer it over. The current report works by populating the XSD at run time in an ASP.NET web page, which then calls the crystal...