Forum Replies Created
Viewing 15 posts - 586 through 600 (of 1,439 total)
-
RE: Generating n-Tuples with SQL
I think you can use CUBE/ROLLUP for this.
SELECT CASE WHEN n1.strcol IS NULL THEN 0 ELSE 1 END +CASE WHEN n2.strcol...
____________________________________________________
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: Update using subquery help!
CELKO (5/16/2012)
>> Once again, you and your high horse ride in. <<Gee, ANSI/ISO Standards, etc are "high horse" to you? Does that say a lot about your professionalism and expertise...
____________________________________________________
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 Filter
Use LIKE
SELECT ..FROM mytable
WHERE PartNumber LIKE '[0-9][0-9][0-9][0-9][A-Za-z][0-9][0-9]'
____________________________________________________
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: for xml path() concatenates texts, how to get 2 elements with the same name?
Bit weird but works...
select'A' as [value],
null as [x],
'B' as [value]
for xml path('test'), type
____________________________________________________
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: parse string
This sort of things is straightforward as a SQLCLR, something like this
using System;using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Text;
public partial class UserDefinedFunctions
{
enum States { Literal, UpperNext, LowerNext...
____________________________________________________
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: Getting parent node attributes is very slow
With a minor change, the cross apply code runs a lot quicker.
Here's my test set up
SET STATISTICS TIME OFFDECLARE @x XML
SELECT @x = '<EXPORT>
<UNIT UNIT_ID="40001" TYPE="01">
...
____________________________________________________
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: Getting parent node attributes is very slow
This should be quicker
select b.value('@UNIT_ID', 'nvarchar(100)'),r.value('@DT', 'DATETIME'),
r.value('@V', 'decimal(10, 8) ')
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: Delete Duplicates
Try this
with cte as (select *,
row_number() over(partition by empno,cid order by enddate desc) as rn
from temptable)
delete from cte where rn>1;
____________________________________________________
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: Updating a field twice in one statement
UPDATE #test
SET string = dbo.RegexReplace(dbo.RegexReplace(string, '[0-9]', '9'), '[a-zA-Z]', 'X')
FROM #test
____________________________________________________
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: Are the posted questions getting worse?
Sean Lange (5/3/2012)
Lynn Pettis (5/3/2012)
SSC is at 1,499,895 and counting!Wow if the same rate continues we should hit 1.5M by the end of the day today or certainly tomorrow.
Now standing...
____________________________________________________
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: Split Row into Multiple Rows
Join to a numbers/tally table
SELECT s.ORDER_NUMBER, s.PRODUCT_ID, 1 AS QTY, s.VALUE/s.QTY AS VALUEFROM @SPLITROW s
INNER JOIN master.dbo.spt_values t ON t.type='P'
AND t.number BETWEEN 1...
____________________________________________________
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: nth occurance of a alphabet
See if this helps
SELECT col1,col2,col3,LEN(col3)-LEN(REPLACE(col3,'A','')) AS NumberOfA,
LEN(col3)-LEN(REPLACE(col3,'B','')) AS NumberOfB
FROM tbl1
____________________________________________________
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 This Problem
dilip.aim11 (4/26/2012)
hi yes i have variable number of till..which i am getting in variable ... using
count statement from other table...
Have a look at dynamic cross tabs here
http://www.sqlservercentral.com/articles/Crosstab/65048/
____________________________________________________
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 This Problem
SELECT Sales,SUM(CASE WHEN Till=1 THEN Amount ELSE 0 END) AS Till1,
SUM(CASE WHEN Till=2 THEN Amount ELSE...
____________________________________________________
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: Occurrence count
Still not really clear what you're asking for
SELECT resp_Id, Brand, [Year], [Month], FOP = MAX(CASE WHEN [Week]=2 THEN 1 ELSE 0 END) +...
____________________________________________________
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 - 586 through 600 (of 1,439 total)