Forum Replies Created
Viewing 15 posts - 1,291 through 1,305 (of 1,439 total)
-
RE: Find Aggregate value in lookup
Something like this?
WITH AvgResponse AS (SELECT AVG(CAST(response AS DECIMAL (4,2))) AS response,
expectation,
employeenumber,
...
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: Collation Latin1_General_CI_AS stands for?
CI - Case Insensistive
AS - Accent Sensitive
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: MSSQL into XML in Hierarchy?
CREATE FUNCTION dbo.GetSubTree(@ID int)RETURNS XML
BEGIN RETURN
(SELECT ID AS "@ID",
Title AS "@Title",
dbo.GetSubTree(ID)
FROM MyTable
WHERE Parent=@ID...
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Xquery question
SELECTXML.value('(/*[local-name()="Movement"][@Context="Purchase"])[1]','varchar(50)') AS Purchase
from
XMLCollection
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: XQuery
Why do you want to do this dynamically?
Have you tried something like this?
SELECT @var = ParamXML.value('/ROOT[1]/TestCase[position()=sql:variable("@TestCaseID")][1]/Query[1]/@Expected','VARCHAR(MAX)')
FROM dbo.SPParamXML
WHERE SPName = @SPName
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: text() for xml Data Type Methods
selecttab.col.value('@Descr', 'varchar(100)'),
tab.col.value('.', 'varchar(100)')
from @xml.nodes('/SerialNumber/S') tab(col)
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Query from XML
select r.value('../@a','int') as A,r.value('@b','int') as B
from #testA
cross apply xml.nodes('/Tree/Leaf') as x(r)
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Need help on XML urgently
You'll need to post the XML with the namespace declarations
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Need help on XML urgently
select b.value('@id','int') as CustomerID,b.value('./name[1]','varchar(20)') as Name,
b.value('./city[1]','varchar(20)') as City,
d.value('@id','int') as...
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: How to identify the position of the nth occurance of character in a string
You can use a numbers/tally table
http://www.sqlservercentral.com/articles/TSQL/62867/
For example
DECLARE @Parameter VARCHAR(100)DECLARE @ch CHAR(1)
SET @Parameter='aaaddddfffggghhhhjjjj'
SET @ch='f'
SELECT ROW_NUMBER() OVER(ORDER BY N) AS nth,
N AS [Position In String]
FROM...
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: XML Query
SELECT r.value('.','VARCHAR(20)')FROM Table1
CROSS APPLY Column1.nodes('/*:Webstore/*:Manifest/*:Version') AS x(r)
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Check All
Assume that the selected file types are in a table such as this
CREATE TABLE SelectFileTypes(FileTypeID INT)INSERT INTO SelectFileTypes(FileTypeID) VALUES(2)
INSERT INTO SelectFileTypes(FileTypeID) VALUES(3)
This query should give the results you want
SELECT GroupIDFROM...
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: Select XML data
WITH XMLNAMESPACES ('urn:WebstoreDeploymentSchema.xsd' AS ns)SELECT r.value('@Name','VARCHAR(50)') AS 'Element Database Template'
FROM Table1
CROSS APPLY Column1.nodes('/ns:Webstore/ns:DatabaseTemplates/ns:DatabaseTemplate') AS x(r)
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: coalesce negative values
RyanRandall (7/14/2008)
This looks like fun, so I'm chipping in...declare @t table (id int identity(1, 1), a1 int, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537 -
RE: coalesce negative values
antonio.collins (7/10/2008)
the list is individual columns of floats. i thought of stringing them together and using my fListToFloats(list,delim) function but i'd like something cleaner, especially since i need to...____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 15 posts - 1,291 through 1,305 (of 1,439 total)