Using MS SQL Server

HELP WITH SELECT STATEMENT PLEASE
Hello Group I having problems creating a result set. The challenge is I have 3 tables: A customer table, A charge table and a payment table..... The result set needs to show all payments and what detail lines were paid down by each payment. Both the detail line table and payment table can contain positive and ne... 18 Apr 2008 10:14

SQL Server 2005: functions become slow after a while
Hi, I'm having serious issues with our user defined functions. They get very slow after a while. The functions I use have several IF-branches which check input parameters. Always exactly one branch will be executed. Normally, the execution time of my functions is something like 300ms. After a while though, it c... 17 Apr 2008 22:05

How to get the sql statement of a view? (by running a query or from ado.net)
Hello there, I was wondering if anyone knew how to run a query that supplies the sql statement behind a view? or is there a way to do that with ado.net? Thank you kindly for anyones ideas John Sheppard ... 20 Apr 2008 22:45

Login Seems OK but doesn't behave correctly
Hi, Any pointers much appreciated- I just don't know how to progress from here. Using MS SQL server on a shared host (www.joglab.com shows the problem) I am having a problem with logins- login appears to work and is registering in the members database (also on a shared server) as a login but not behaving on t... 16 Apr 2008 18:52

table trigger just hangs
I have a UDF that cleans a field of control characters and I use it like this select dbo.udf_CleanAlphaNum(Address1) as Address1 from Leads It works great. I use it to clean several fields from a vendors SQL server. The downside is I have to first load the data into my database so I can use my function to c... 17 Apr 2008 01:12

Granting permissions for a user from another database
Is there a way to grant permissions on an object in one database to a user from another database in SQL Server 2000? ... 16 Apr 2008 14:50

Dump table as INSERTs
Is there an easy way to create a SQL script to re-create and re- populate a table? Both Enterprise Manager 8.0 and Management Studio Express 2005 will generate the CREATE TABLE, but they only seem to produce a generic INSERT statement with place-holders instead of values. Not ideal for any table with more than 10 ... 16 Apr 2008 16:26

select cases where a datetime is not 3 or more hours older thana similar case
Sir, you just blew me away with that one, that's was amazing! You're a goto guy, that's what you are, thanks a million, Morten Plamen Ratchev skrev: Here is one way (SQL Server 2005): ;WITH RankedLogEntries AS (SELECT PresentationID, AccessTime, IPAddress, PageCalled, ROW_... 16 Apr 2008 05:48

SQL Server Management Studio
Hello all, I have SQL Server Mgmt Studio and would like to know how to shut off the auto updates that occur when you leave a modified row in the "Open Table" view of a table? I want to update several rows at a time and then send all modified rows back for an update. Thanks J Maloney ... 16 Apr 2008 18:04

SQL 2005 XML Searching
hi i have a table with an XML column this XML data looks like this <details><attribute id="1" value="x"/><attribute id="2" value="y"/ <attribute id="3" value="z"/></details> could anyone help guide me on how to search something like this? ------- Select * from Table Where (XMLColumn contains attribute ... 16 Apr 2008 10:48