microsoft.public.sqlserver.programming | Forum profile

  You can use recursive CTE: CREATE TABLE Items ( item VARCHAR(10) NOT NULL PRIMARY KEY, superceder VARCHAR(10) REFERENCES Items(item)); INSERT INTO Items VALUES('ITEM1', NULL); INSERT INTO Items VALUES('ITEM2', 'ITEM1'); INSERT INTO Items VALUES('ITEM3', 'ITEM2'); INSERT INTO Items VALUES('ITEM4', NULL); INSERT INTO Items VALUES('ITEM5', 'ITEM4'); INSERT...

  shapper (mdmoura@gmail.com) writes: > On a database I have two tables: > > Countries and Regions. For each Country I have one or many regions. > > Then I have another table, Centers, where I need to define its > location. > I suppose I need only RegionId in this table correct? > > By defining the Region of the Center I can lookup in which country is > located ......

  Frank Specifically for your case it does not matter , when it does for OUTER JOIN such as LEFT/RIGHT JOIN you can get 'wrong' output Start reading http://www.solidq.com/insidetsql/books/tsqlfund2008/ "Frank" <francis.moore@gmail.com> wrote in message news:b64b5bb9-a702-408b-9152-ded94ceacc0a@w19g2000yqk.googlegroups.com... > Hi, > > I'm currently reading a SQL...

  On Nov 25, 11:21?am, LN <L...@discussions.microsoft.com> wrote: > How can I convert column data to single row base on licenseid. ?Please see > desire results below. > Thank you in advance. > > --SQL 2005 > > IF OBJECT_ID('Tempdb.dbo.#Temp', 'u') IS NOT NULL > ? DROP TABLE #Temp > GO > > CREATE TABLE #Temp > (...

  I have been asked by several of my clients to do technical interviews for them and I use the same method Kalen. I want to see what the candidate can come up with given incomplete or nebulous information - which is exactly what they will get in the real world.

  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. "Sam" <Sam@discussions.microsoft.com> wrote...

  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 Inner Join inserted i On...

  "JeffP->" <JeffP@discussions.microsoft.com> wrote in message news:8DBB559C-705A-4DDC-A81C-F5E539952728@microsoft.com... > a penny. It just irks me that Excel is the defacto calculator, not a real > calculator or real math but Excel math. Perhaps someone should stop using Excel... ;) .  

  That's what I thought. Just wanted to be sure I wan't missing something. Thanks. "Plamen Ratchev" <Plamen@SQLStudio.com> wrote in message news:V9WdnRQ1WocM2JDWnZ2dnUVZ_opi4p2d@speakeasy.net... > Collation defines how strings are compared and sorted (as well as the > character set for non Unicode data), so it will have no effect on values > like INT and date. >...

  On Nov 26, 6:22?pm, Plamen Ratchev <Pla...@SQLStudio.com> wrote: > The FLOAT data type is a good choice. > > -- > Plamen Ratchev http://www.SQLStudio.com Thank You. I was undecided between real and float. Then I was also reading something about spacial values in SQL 2008 and I was getting a little bit confused. Thanks, Miguel .