Programming SQL

Query Aggregation
Hy, i have a Problem with table 'aggregation'. here a simple example, say 2 tables user roles 1 mike 1 rolea 1 roleb so the result of a joined query is 1 rolea 1 roleb now a customer wants the user to appear only once, but needs the group information, i... 20 Jan 2006 01:53

scientific notation and CAST or CONVERT
Is it possible for me to return a very small number (5 or more decimal places) as a string NOT in scientific notation using the CAST or CONVERT function? I want 0.0000769 not 7.96e-005. Thanks, Martha Hoffmann ... 12 Jan 2006 13:30

bcp issue
Dear all, I've got a little issue and I can't work out with it. Using BCP in order to export the contains of a .dat file into a table: C:\OFI0501>BCP abs..ABS_OF501 IN 20050726.DAT -e enric.txt -n -Sserver -U us1 -Pdts1 SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Se encon... 12 Jan 2006 08:17

Date Only Data Type
I would like to have a field in a table that is a Date only data type instead of the datetime. Could someone offer any advice on this in SQL Server 2005. Thanks ... 15 Jan 2006 10:41

INSERT...EXEC prevents parallelism?
Hello all. I have a, shall we say, "legacy" stored proc whose result set I must manipulate in another stored proc. The legacy stored proc is extremely complex, and the final select for the result set is about 2 pages of UNION statements. When this legacy SP runs in a standalone fashion, it executes in less than ... 10 Jan 2006 19:13

OPTIMIZER LOCK HINTS
I want to populate ULF with all the records from ULF_Backup in my License database. I can't get around this error, "OPTIMIZER LOCK HINTS" Here is the SQL code I'm running from Query Analyzer. sp_dbcmptlevel 'license', 70 GO SET IDENTITY_INSERT ULF ON INSERT INTO ULF (SPORTSMAN_KEY, LICENSE_YEAR, LICENSE_N... 19 Jan 2006 14:28

Joing two tables but avoid cartesian product
Hi all, I have two tables that don't have any common data: [Table1] Column11 Int AnotherColumn Int [Table2] Column21 Int Data: [Table1] Column11 | AnotherColumn 111 | 8 112 | 8 113 | 8 114 | 8 [Table2] Column21 211 212 213... 7 Jan 2006 03:29

Syntax error converting from a character string to unique identifier
Hi I am using a stored procedure in SQL2000 for retrieving file maximum weighting from a db. The table consist weighting (int) and variable id (Unique identifier) columns. My intention is to get the maximum weighting of a variable among the passed variable ids. So I am generating a comma separated stri... 3 Jan 2006 05:33

TSEQUAL
I have, in stored procedures in SQL2000, used the TSEQUAL-function when doing updates. example: table test is defined like this(id int,description varchar(100),t_stamp timestamp) create proc test @id int,@description varchar(100) @ts varbinary(8) as update testtable set description = @description where id = @... 2 Jan 2006 06:07

dts to update table
Hi, I am writing a dts package to update a sql table using data in a csv file. I know that dts updates all mapped columns regard less of the column's value has changed or not. I need to perform a special action when dts actually changes any column's value but not when the column's value remains unchanged. W... 29 Dec 2005 12:08