Programming SQL

Sequence
I have 2 columns in table Orders. OrderId which is int InventoryId which is int. I would like to write a query to update a column called sequence so it assigns an automatic number based on OrderId and InventoryId. For same Order Id and different InventoryId the sequence increases. When we get a new OrderId it rest... 9 Mar 2010 12:22

Convert Positive Value to Negative Value
How can I get the "Amount" to be a negative number when the "Code" = "G6"? Maybe I could multiply by -1 and use the CASE statement, but I don't know how. Table Name = EncounterData Amount Code $15.00 G2 $13.00 G2 $18.00 G6 $16.00 G2 $25.00 G6 $30.00 G6 -- Tyro from Missouri ... 9 Mar 2010 10:04

Query
I would like to get sum of the price for all items from table ProductVariant CREATE TABLE #Kits ( ShoppingCartRecId int, InventoryVariantId int, SumTotal money ) INSERT #Kits (ShoppingCartRecId,InventoryVariantId) select ShoppingCartRecId,InventoryVariantId from Orders_KitCart update x set x.Su... 8 Mar 2010 14:11

SELECT SUBSTRING
I want to select a substring from a text this way: blablaNAME:myNameADDRESS:myAddressblabla What I want to get is all the text between "NAME:" and "ADDRESS:" I'm trying: SELECT SUBSTRING(myField, PATINDEX ('%NAME:%', testo) + 5, xxxxxx) Of course I can't know how long the substring is, so I don't know what to pu... 8 Mar 2010 10:50

Xml shredding performance
Hi, we are having some performance issues regarding xml shredding. At this point we are extracting data from xmls from nearly 60 different companies - and therefore 60 different xml structures. The total amount of xml is about 350MB and we are trying to extract the data as fast as possible. Our current s... 9 Mar 2010 03:29

Alter table
I tried the following statement: “ALTER TABLE STOCKTRANS ALTER COLUMN DATASET varchar(3) NOT NULL” I got this message in return: “--> Msg 5074, Level 16, State 1, Line 1 The index 'I_013ITEMNUMBERIDX' is dependent on column 'DATASET'. .. .. .. Msg 5074, Level 16, State 1, Line 1 The index 'I_013SEQNO' is de... 8 Mar 2010 02:07

Need help with a recursive query - DDL Part 3
INSERT [dbo].[testProduct] ([SEQ], [ID], [NEWID], [EVDESCRIPTION], [PARENTH1], [SCALING], [BASEUNIT], [MATERIALTYPE], [STDCOST], [STDHRS], [ORIGINCOUNTRY], [ORIGINREGION], [PRODHIER], [PRODUCTCLASS], [TAXFLAG], [PH], [CALC], [DIMCALC], [ISBASEMEM], [HIR]) VALUES (CAST(1008252 AS Numeric(8, 0)), N'70857', N'', N... 9 Mar 2010 12:22

T-SQL to retrieve language pairs with a fallback to a default language when missing
On Thu, 4 Mar 2010 09:25:33 -0800 (PST), --CELKO-- wrote: I am confused as to why you went out of your way to avoid the ISO language and country codes. You have allowed data errors to creep in with the NVARCHAR(15) declarations. I also cannot find an ISO Culture Code standard; what is it? My idea of a cultur... 5 Mar 2010 17:23

sql server formats
The following two questions pertain to format questions I have about sql server 2008: 1. When I export some of the sql server 2008 tables to either word or PDF, and the table goes to two or more pages, there is a complete empty page break. Basically I will see the table, followed by a blank page, the tab... 5 Mar 2010 16:15

sql server displays
I would like to know what I can use in sql server report 2008 to display several sentences or paragraphs prior to where I have a table generated. Each table in each report will display the data. To display the paragraph(s) and/or sentence(s) before the table containing data what toolbox item would I use? Should... 5 Mar 2010 16:15