Forum Replies Created
Viewing 15 posts - 496 through 510 (of 1,439 total)
-
RE: query to count repating alphabet in a string
Lowell (9/21/2012)
Mark-101232 (9/21/2012)
declare @asd varchar(20)set @asd ='asdaaaadffa'
select len(@asd) - len(replace(@asd,'a',''))
oh your fast on the draw there, partner!
Yee-Haa!
____________________________________________________
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 to count repating alphabet in a string
declare @asd varchar(20)set @asd ='asdaaaadffa'
select len(@asd) - len(replace(@asd,'a',''))
____________________________________________________
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 many in common?
Try this
WITH data (Client_id, id, value) AS (SELECT 10, 1, 1 UNION ALL
SELECT 20, 1, 1 UNION ALL
SELECT 30, 1, 1 UNION ALL
SELECT 40, 1, 2 UNION ALL
SELECT 10, 2,...
____________________________________________________
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 transform this result?
SELECT a.ITEM,b.DESCRIPTION AS ITEM_DESC,a.CNT,a.DESCRIPTIONFROM @ITEM a
INNER JOIN @ITEM b ON b.CNT='' AND b.ITEM=a.ITEM
____________________________________________________
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: Ranking Dates
Something like this?
WITH RankedORDERS AS (
SELECT USER_ID,ORDER_DATE,
ROW_NUMBER() OVER(PARTITION BY USER_ID ORDER BY ORDER_DATE) AS rn
FROM ORDERS)
SELECT USER_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: SQL Server Query to group sequential dates
p.ramchander (9/19/2012)
yes, the difference between the start date and end date is fixed to 1 day difference.Then you can do this
WITH CTE AS (SELECT EID, AbsenceType, AbsenceStartDate ,AbsenceEndDate,
...
____________________________________________________
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: Find records which are within the depth range of other records
This is a just couple of queries rolled into one.
This first query finds the start points of the intervals by finding all start points that don't lie inside an earlier...
____________________________________________________
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: Find records which are within the depth range of other records
Not very efficient, but should give the correct results
SELECT s1.well_id,s1.Top1,
MIN(t1.BASE1) AS BASE1,
...
____________________________________________________
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 query
There's lots of ways of doing this, here's another
SELECT CustIDFROM product_details
WHERE ProdId = 1
INTERSECT
SELECT CustID
FROM product_details
WHERE ProdId = 4
EXCEPT
SELECT CustID
FROM product_details
WHERE ProdId = 0;
Also this
WITH Summary...____________________________________________________
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: Using ROW_COUNT
May not be what you're after, but you can return an additional column with the total row count
Alter proc [dbo].[InvoiceDisplayTest] (@InvoiceNumber nvarchar(50),@InvoiceDate datetime ,@InvoiceDate1 datetime, @AccountNumber nvarchar(50),@TradingPartnerID nvarchar(50),@Page nvarchar(50),@rownum int...____________________________________________________
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: The argument 1 of XML datatype method nodes must be string literal.plz help
Try adding
ORDER BY SN,NodeName,NodeValueto the end of the query
____________________________________________________
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: The argument 1 of XML datatype method nodes must be string literal.plz help
Use sql:variable
set @starttag ='XML'
set @root ='Provider'
SELECT
dense_rank() OVER (ORDER BY C.value('local-name(.)', 'varchar(50)')) AS 'SN',
NodeName = C.value('local-name(.)', 'varchar(50)')
, NodeValue = C.value('(.)[1]', 'varchar(50)')
FROM @xml.nodes('/*[local-name(.)=sql:variable("@starttag")]/*[local-name(.)=sql:variable("@root")]/*') AS T(C)
____________________________________________________
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: Table update using a hierarchy
UPDATE t1
SET Id = COALESCE(t2a.Id,t2b.Id,t2c.Id)
FROM Table1 t1
LEFT OUTER JOIN Table2 t2a ON t2a.Acc = t1.AccType1
LEFT OUTER JOIN Table2 t2b ON t2b.Acc = t1.AccType2
LEFT OUTER JOIN Table2 t2c ON t2c.Acc...
____________________________________________________
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: Filling Buckets
I think this is a running totals problem, have a look here
http://www.sqlservercentral.com/articles/T-SQL/68467/
If you are using SQL Server 2012, you can use the built-in windowing functions
DECLARE @ToAllocate INT = 21;WITH CTE...
____________________________________________________
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: Tricky REPLACE problem
Yet another to try...
DECLARE @t TABLE(ID INT IDENTITY, Formula VARCHAR(100))
DECLARE @Old CHAR(1)
DECLARE @new CHAR(1)
INSERT @t(Formula)
SELECT 'L@*K@*H@/324'
UNION ALL SELECT '(AY#-AR#)*(Y#+BB#)'
UNION ALL SELECT 'TD@*(L#+D@)*C@'
UNION ALL SELECT '((AE#-AR#)*(Y#+A#))/Y#'
UNION ALL SELECT 'A#+AB#+BA#+B#'
SET @Old =...
____________________________________________________
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 - 496 through 510 (of 1,439 total)