SQL | Forum profile

FOR XML PATH is used to generate XML from a result set. When you use it with blank element name it results in XML without element names and concatenating the column values with ',' results in one concatenated string. Then STUFF is simply used to remove the first comma. Signature Plamen Ratchev http://www.SQLStudio.com

So the data look like this:  first field"second field"third field""fifth field Assuming that the file has the fields in the same order as the columns in the table this is easy with BULK INSERT:   BULK INSERT Testtable FROM 'C:\test\test.csv'    WITH (DATAFILETYPE = 'char', FIELDTERMINATOR = '"') It would be simple with BCP too, if it...

You have a lot of FUNDAMENTAL problems.  Let's start with the basics of RDBMS; every table a has a key; by definition a key is NOT NULL. Therefore, the only po9ssible key in your DDL is "license_id"; but by definition a key is UNIQUE. In short, you posted a deck of 1950's punch cards and think you are writing SQL. Next, the basis of all RDBMS is the First Normal Form (1NF).  That means all columns...

A trigger is called once per statement, not once per row that is updated. So you need to write the trigger to handle multiple rows (by matching the rows in the inserted table with the rows in your base table on the primary key of the base table).  The trigger for this case could be Create Trigger trTable_1 On dbo.Table_1 For Insert, Update As Begin  Update t  Set MyValueCopy = i.MyValue  From dbo.Table_1 t...

What is the version of SQL Server are you using? > Howdy - and thank you in advance for any help!!! > Here is what I have so far: [quoted text clipped - 29 lines] > g.beginingdate > g.endingdate

If you put the query I gave you in a table-valued function or stored proc and pass in the SKU as a parameter, and add the SKU to the WHERE clause predicate you will probably see acceptable performance.  The key is that you're doing this for one SKU at a time, so with a little index-tweaking on your tables I would imagine your performance would be good. > Thank you both for your responses. > [quoted text clipped - 91...

Hi AliRezaGoogle You are mixing up logical and physical constructs. Keys are a logical construct, just an expression of the behavior you want. Physical constructs are the actual method of implementation. If you declare a primary key, SQL Server will implement that with a non-null unique index.  The default is to make it a clustered index, but that is not necessary. (The non-null and unique IS necessary. ) In fact, in many cases...

The blocking resource could be a key range lock, individual locks multiple keys or some other resource.  The only way to know for sure is catch the problem in action.  From an app perspective, check to ensure that transactions don't span user interactions and select results are consumed quickly and in their entirety. Signature Hope this helps. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/

Hi Iain, Try reading this: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/11/427.aspx Puts to bed some of the misnomers on Codd and surrogate keys. Tony >>>> Well, this is my idea and questions. Am I planning this correctly?<< >> [quoted text clipped - 18 lines] > key, in that only part of the number has independant meaning, the rest > is just a counter, much...

"Michael Coles" <admin@geocodenet.com> wrote in message news:%23hvu% > I think there are some advantages that could be realized by adding > additional parameters to SQL CLR custom aggregates, and from what I > understand that is on the radar for future versions of SQL Server.  In the > meantime you can work around the issue by using SQL CLR UDTs and passing > them to...