Hi! I'm trying here to do a compilcated(?) SQL statement... The first step I did was this: I have table1: key description -------------------- 0 john 1 dani 2 joe then table2: amount key ---------------- 30 0 20 0 25 1...more >>

I need to get the column list string of dynamically generated SQL select statement. For example, I get input of a string 'select 1 as A, '234' as B, C from .......' and it will get 'A, B, C' ...more >>

Hi, I've the following query: SELECT SUM(dbo.CLAIMS.PAID AS COSTS, dbo.CLAIMS.TYPE_ID AS ID1 FROM dbo.CLAIMS GROUP BY dbo.CLAIMS.TYPE_ID UNION ALL SELECT SUM(dbo.CONTRACT.COSTE) AS SELLS, dbo.CLAIMS.TYPE_ID AS ID2 FROM dbo.CONTRACT GROUP BY dbo.CL...more >>

Hi All Is there a tool that i can use to compare records in two tables. The table structures are the same and also there the tables have primary keys. All i want is, if there are records in table A that are different from records in tbale B, then list the PK for those records. I know it's p...more >>

Hi, I have sql server records that need to archived in archive tables in the same database. The rows are in five different tables. The archive should be such that those data could be restored at a future time. Is there any knowledge base or concept that will allow me to do so? Or do I have cr...more >>

Hi All, I am processing WebLogs and part of the task is extracting values from the cookies. The format of the cookie is similar to this: url=www.url.com;referrer=www.google.com;pcode=1234;testid=2334;abtestgroup=A etc. The order of values can be different for each record and the last ...more >>

Miguel I been reading your post Basically I need to insert a new record if there is no record with the given @id or update the record if one is found with the given @id. Its possible that you can send me the final chunk of code that resolve the issue. Thanks in Advance EggHeadCafe...more >>

I found a piece of sample code about restoring a database: Assuming that the database backup file name is c:\backups\northwind\nwind.bak, the following command will restore the database to "nwind_new": RESTORE DATABASE nwind_new FROM DISK = 'c:\backups\northwind \nwind.bak' WITH MOVE 'northw...more >>

I cannot get an update to work in a stored procedure. I have a column of type XML named ‘Approvals’. Here is a shortened standard entry in that column. <Approvals> <Approval BodyID="MCCH"> <ApprovedBy>jsmith</ApprovedBy> <OnBehalfOf>John Jones</OnBehalfOf> <App...more >>

Hello, I'm developing in ColdFusion for my front-end, using SQL Server as my data repository. I have multiple date fields that are populated yet, some aren't. Those that aren't, may never be however when I perform an update action using an SQL Update statement, for those that are NULL or not pop...more >>

I have a very absurd scenario that only happens in a job. A procedure that I execute in this job hangs up on the insert statement of the following scenario: --BULK INSERT FROM TXT FILE --TRUNCATE STAGE_TABLE --SELECT INTO STAGE_TABLE FROM BULK TABLE --TRUNCATE FINAL_TABLE insert into FIN...more >>

I need to trace all my db structure changes. To do this i've seen in the msdn the use of DDL Triggers. I've done this: USE MY_DB CREATE TABLE LOG_DBSOURCE (LOS_ID int identity(1,1), LOS_CURRENT_USER nvarchar(100), LOS_SPID int, ...more >>

[MSSQL 2000, ASP.Net 2005, VB.Net] Hi, I'm hoping someone can suggest the best way to tackle this problem: I have a "sales order" object which may contain multiple line items. When the sales order is saved, the cost of each line item is determined by a UDF (called GetAverageCost). GetAvera...more >>

Here is my situation: We have highly partitioned database with many child tables that go many levels deep. For example Table1 is related to Table2 which is related to table3 and so on. Table2 might have hundreds of records and others too. I have to make a copy of one record from Table1 and a...more >>

Im trying to establish how many rows were done per week per year eg results would be week / rows 1 23 2 27 3 35 etc table has ID and a date been playing with datepart but didnt really get the results i was thinking of cheers mark tbh im sure ive done ...more >>

Hi guys I dont know if I post this in the right group but I thought I give it a go. I will have an interview in 2 days and I so want to land this job. The job is database developer. It is a job for a public sector organisation so I think there are so many things they need to comply e.g infor...more >>

Hi. We will be using a hosting company for our customer's SQL Server 2000 database. The customer has expressed interest in managing the database themselves. The hosting company says they don't supply the client tools. Therefore, how can the customer license just the SQL Server 2000 administr...more >>

Friends, I have a very strange issue. When i execute a DTSPackage with less amount of data. its execute fine, But when i execute it with double amount of data and check form SQLProfiler, it take so many times, the conditions are : -lot of times execute msdb.dbo.sp_sqlagent_get_perf_count...more >>

I'm developing an app that removes multiple values from a starting value in stages. The app is an assignment system that starts with the "annual work hours", subtracts "vacation hours", then "overhead", etc. I work with each subtotal and there are about six stages of results. I am using ...more >>