Programming SQL

Create function concatenate
I want to know How I can create a function that will concatenate fields ex: UF_Concat_fields (Tbl_Name, Field_Name, Where_Clause, Separ_Char) In that function, I could do select Field_Name from tbl_Name where Where_Clause in a cursor or something like that and add the Separ_Char which would = ", ". ex: UF_C... 14 Jun 2010 18:30

many reports solution
Hi, I have a web page to let user to define customized report. For now, just one and two dimension reports. And db has 11 entity tables, and a few tables to join them togeter. 11 entity joined in different path, in different way (1:m. m:m), directly and in-directly. Now the problem is the user want each... 7 Jun 2010 03:08

tuning import of large dataset
hi I'm interested in knowing more about tuning import of large dataset from for example MS Acess into MS Sql Server 2005. over 60.000 rows to be inserted into the table. I think using bulk insert is better than using a loop of insert statements. If you have I would be greatful if some some of you could post... 6 Jun 2010 19:28

deleting duplicate rows
I have an import file that might have duplicates that I don't want to deal with. I'm creating a temp table from the import file and want to delete the duplicates from the temp table before proceding with other code. Here's an example table: create table #temp (itemnum int, firstname varchar(10), notes varchar(5... 11 Jun 2010 21:28

Organizing Solutions and Projects
Can anyone suggest the best way to organize Projects and Solutions. I work alone as opposed to.. with a team of developers. I try to save all stored procedures, UDF's, Triggers and DDL as ..sql files in projects and solutions in SSMS. Still... I frequently find myself searching solutions via explorer looking f... 5 Jun 2010 09:14

Is there any replacement for SQLXML in sql server 2008 R2?
Hi, Is there any replacement for SQLXML in sql server 2008 R2? I have to produce XML export files based on my database data every night. The XML structure has nested tags and is complex. What would be the best tool to do this? I am aware of FORXML clause and I am hoping to have a better option. Thank yo... 4 Jun 2010 17:00

Union versus multiple join conditions
Hello, I was working on a query that had multiple join conditions, and even though there was an index covering all of the columns used in the join (none of the columns were the primary key for either table), it was taking a long time (~20 seconds). The original query looked like: select b.* from a in... 5 Jun 2010 14:44

loop
hi, i have the following: --****************************************** --make temp table --****************************************** CREATE TABLE #DCLNS2 ( B_DATE DATETIME, ACCT INT, LTR_CODE char(50), INV char(5) ) INSERT INTO #DCLNS2 ("B_DATE","acct","LTR_CODE","INV") (SELECT * FROM dcl... 7 Jun 2010 21:06

Fastest way to Copy DB + Keys,Constraints to another server
What would be the fastest way to copy a SQL Server 2005 database and its data to another server including keys and constraints, without stopping the source server? TIA ... 3 Jun 2010 22:21

Suspended bcp
I am using SQL Server 2008 x64 and running a bcp statement to insert a large amount of data (100M rows, 50Gb). Problem is that as it runs, it gobbles up more and more ram, and then eventually locks up and the spid goes to "Suspended" Status. I read some articles about this problem in SQL 05, and it was report... 4 Jun 2010 19:13