A function I seem to be missing in TSQL is to encode a date. For example: EncodeDate(2006, 8, 23) How can I best do this? -- Thanks in advance, Stijn Verrept....more >>

Hi, I have a CLR table-valued function that pulls data from a 3rdParty OLEDB provider. When I call Dispose() on the .NET objects (System.Data.OleDb.*) and the end of my function Init() method, it causes COM interop errors which I cannot catch. I think it's a ThreadAbortException that cause...more >>

Hi there, I am trying to provide auditing for a customer and was going to use the Columns_Updated function in my update trigger as I do not want to report that an update has occurred when someone just opens a record to view it and clicks the OK button. In that case, only the ti...more >>

Hi I have a table where two fields together is unik id. On the table I have a update trigger that is updating a date field. The trigger goes like this: Update table1 set date1 = getdate() where id1= (select id1 from inserted) and id2=(select id2 from inserted) This is ok when only one reco...more >>

Hi My query us extracting values in the following format. create table tmp_id ( id int, count int ) id count 1 10 2 2 3 7 4 20 I would the values in the count field to be aligned to the right ...more >>

I'm working on a small tool that makes changes to a database (SLQ Server 2005, but SQLExpress is deployed at the client's location). It has to either create a new stored procedure (if it doesn't exist), or it has to update it with a patch (if the procedure already exists). Currently, I'm tryin...more >>

anybody know the difference between clustered and a non-clustered index. Mike...more >>

I'm trying to do something like this... CREATE PROC up_myproc @pcode char (3) AS IF EXISTS (SELECT srvname from sysservers WHERE srvname like '%@pcode%') ::::::::::::: ....where I validate if the value passed in the SP (@pcode) is contained in the srvname column before the rest of the co...more >>

How can I use this in SQL to update a table's data? Thanks using System; using System.Globalization; using System.Threading; namespace ToTitleCase1 { class Program { static void Main(string[] args) { string title = "this is my converted string"; ...more >>

Hi, I need to insert special records into one table on daily basis. I need to disable a trigger in the table, after my records inserted i need enable the trigger. How do accomplish ny task thanks ...more >>

Hi All, Has anyone ever seen the behaviour where a query containing an aggregate, (Count in this case) has to be run multiple times in succession until the 'counts' are correct? -- Dan ...more >>

Using SQL2000 STD SP3... I'm trying to interface with our ERP database and I basically need to extend the table definition into my own database (I don't want to touch the ERP software's table defs). When a table in the ERP software has rows inserted, updated or deleted, I want to add/updat...more >>

Hi, I'm confused as to how to do this and would appreciate any help given! My data: Customer# Itemname Date Purchased Cost 1 Broom Jan 1, 2006 5.00 1 Broom Feb 2, 2006 6.00 1 Dustpan Feb 3, 2006 4.00 2 ...more >>

Whenever I query a a view, I get the error: "Error converting data type varchar to numeric." How can I find what the row with the bad data is without having to dissect the view and all its tables? Thanks....more >>

Hi all, I am facing one problem. I have one test Stored Procedure in SQL as below [having one insert query followed by the select query] CREATE/ALTER PROCEDURE MigrateCAMTEST AS BEGIN insert into test values(1) SELECT CampaignName FROM MigrateCAMTab END Here MigrateCAMTab ...more >>

Hi, We own a remote webserver. It's ower machine, but it's in a datacenter specialized in webhosting, dedicated servers, ... So far, we've only put online websites we've made ourself for our clients using asp, asp.net, mysql and sqlserver express. We use remote desktop to update the data...more >>

Group Please see the data set example shown below Master Table **************** Column1 Column2 R1 C1 R2 C2 Child Table ************* Column1 Column2 Column3 R1 X1 A1 R1 X2 A2 R1 X3 ...more >>

Hi, I inserted the following value to a table. Column datatype is varchar the value is 'Customer List - Based on the return date' The value has been inserted sucessfully . On selection the following is what i get 'Customer List — Based on the return date' My question is 1. W...more >>