Programming SQL

xml dml conditional attribute inserting does not work
Hi, I'm experimenting with XML DML. I need to add an attribute only if it meet some condition. But I can not use an sql variable to implement the condition. The following example gives me an error: XQuery [modify()]: An expression was expected Declare @sSerie Varchar(10) ,@sFolio Varchar(10) Declare @x... 1 Jul 2008 19:33

how to strip specific email address from nvarchar field with multi
One approach is to strip out the email server name you don't need (@google.com), and then see if any additional server names are left. This is just a simple WHERE clause and requires no defined functions or accessory tables. declare @T table (sentto varchar(8000)) insert @T (sentto) values ('Doe, John [john... 1 Jul 2008 19:33

SSIS - sql server integrated services - like OLAP?
Question: is SSIS (sql server 2005 and higher) like online analytic processing? Does it involve cubes at all? My place may be stepping up to sql server 2005 from 2000. The big buzz word is SSIS. Any explanations appreciated on what SSIS entails. Thanks, Rich ... 1 Jul 2008 14:24

Help us understand this sql script built by a vendor
One of my co-workers and I are trying to figure out how this script works. I do understand using multiple Select statements to get multiple result sets. Can someone help us with what this script is doing? My take was that it's like building arrays. SELECT DISTINCT B1_ALT_ID, --B1_SUBDIVISION, -- A1 ( SELE... 1 Jul 2008 18:31

Query question
CREATE TABLE #TEST_ONE ( ID INT IDENTITY(1,1) NOT NULL, TEST_ONE_ITEM VARCHAR(30) NULL ) CREATE TABLE #TEST_TWO ( ID INT IDENTITY(1,1) NOT NULL, TEST_TWO_ITEM VARCHAR(30) NULL ) -- Why does this not fail? TEST_ONE_ITEM clearly doesn't exist in the #TEST_TWO table. Running the subquery alone will fail, ... 1 Jul 2008 14:24

To update a clr dll should I drop the assembly?
Hi all, I'm updating by hand a dll containing clr code for Sql 2005 stored procedures. My question is which are the steps needed to update the dll to the new compilation? The file is not locked so I can overwrite the old version with the new one, but it looks like the sql server does not understand the change... 2 Jul 2008 01:40

Insert Records
Hello, I have 3 tables: create table dbo.Files ( FileID uniqueidentifier not null constraint PK_File primary key clustered, Path nvarchar(800) not null ) create table dbo.Tags ( TagID uniqueidentifier not null constraint PK_Tag primary key clustered, [Name] nvarchar(100) not null ) cre... 5 Jul 2008 13:33

query perfomance issue with Select statment in the Select list
On Jul 1, 10:38 am, "Roy Harvey (SQL Server MVP)" <roy_har...(a)snet.net> wrote: Are there any other indexes on the ORDERS table?  At a minimum you would need an index on OrderID for the subqueries in the SELECT list to work efficiently.  As shown, with no such index, each of the subqueries executed has to p... 1 Jul 2008 11:18

2005 vesion changes
Hi all, Below script works fine with in sql2000 version without errors DECLARE grant_cursor CURSOR READ_ONLY FOR select * from #test OPEN grant_cursor FETCH NEXT FROM grant_cursor INTO @owner_name, @object_name, @object_type WHILE @@fetch_status = 0 BEGIN ... 1 Jul 2008 13:22

OpenQuery problem
Yes, it seems that openquery won't accept a variable or concatenated string. I guess to pull this off, we would have to hold our nose and execute the openquery as dynamic SQL. A hacker would love to poke around with a procedure that does this, so be sure to lock down the permissions. declare @SQL as varchar... 1 Jul 2008 11:18