Viewing 15 posts - 751 through 765 (of 1,251 total)
Edvard Korsbæk (2/4/2015)
I have this table:
[dbo].[Login_details](
[login_data_id] [int] IDENTITY(1,1) NOT NULL,
[login_no] [int] NULL,
[logindate] [datetime] NULL,
[logoutdate] [datetime] NULL,
CONSTRAINT [PK_Login_details] PRIMARY KEY CLUSTERED
(
[login_data_id] ASC
)
This query:
Select count(*) from dbo.Login_details group by...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
February 4, 2015 at 2:03 am
Sqlraider (2/2/2015)
Iwas Bornready (2/2/2015)
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
February 3, 2015 at 1:16 am
Lock
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 30, 2015 at 6:08 am
bugg (1/30/2015)
Mark Cowne (5/3/2012)
SELECT s.ORDER_NUMBER, s.PRODUCT_ID, 1 AS QTY, s.VALUE/s.QTY AS VALUE
FROM @SPLITROW s
INNER JOIN master.dbo.spt_values t ON t.type='P'
AND...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 30, 2015 at 6:05 am
TomThomson (1/26/2015)
Half the people who have replied so far think they can use a column filter to select rows, which is a bit startling; and more than four...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 26, 2015 at 6:47 am
You're welcome. I've done some tinkering with postcodes myself in the past so I recognised what you were trying to do 🙂
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 26, 2015 at 5:33 am
SELECT
left(Postcode,patindex('%[0-9]%',postcode)-1)
FROM YourTable
where patindex('%[0-9]%',postcode) > 0
order by 3
That should do the trick for all the...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 26, 2015 at 5:29 am
Have all your postcodes definitely got numbers in them? I know they should have but it might be worth checking.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 26, 2015 at 5:05 am
Have you got spaces in all your postcodes?
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 26, 2015 at 4:50 am
c.simpson (1/26/2015)
I would like to extract the first part of the post code.for example I have
AA1 2BB
A1 2B
A4 2BB
I would like my field to ready
AA
A
A
Thanks
left(Postcode,patindex('%[0-9]%',postcode)-1)
Does that do what you...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 26, 2015 at 4:44 am
That definitely sounds like a good idea. We've got some tables that are 300-ish columns wide and I'd said at least at third of those are all nulls (don't...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 23, 2015 at 2:02 am
Ed Wagner (1/20/2015)
djj (1/20/2015)
DiagnosticTune-Up
Flat
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 22, 2015 at 4:49 am
Richard Warr (1/20/2015)
I thought it was 10^38 - 1 which works for a DECIMAL(38,0) type. That's a much bigger number than the BIGINT type gives you.
That's what I thought too....
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 20, 2015 at 2:41 am
Stuart Davies (1/16/2015)
Ed Wagner (1/15/2015)
djj (1/15/2015)
Ed Wagner (1/15/2015)
SQLRNNR (1/15/2015)
Ed Wagner (1/15/2015)
Taxes@$!%#$!^#
Gouge
Excess
Spend
Thrift
Store
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 16, 2015 at 3:44 am
Ed Wagner (1/15/2015)
ChrisM@Work (1/15/2015)
Ed Wagner (1/15/2015)
ChrisM@Work (1/15/2015)
BWFC (1/15/2015)
richxs (1/15/2015)
Giraffe DBA (1/14/2015)
SQLRNNR (1/14/2015)
Ed Wagner (1/14/2015)
djj (1/14/2015)
BWFC (1/14/2015)
Ed Wagner (1/14/2015)
Stuart Davies (1/14/2015)
TomThomson (1/13/2015)
Ed Wagner (1/13/2015)
SQLRNNR (1/13/2015)
regexPattern
Match
Point
Edge
Bono
Sonny
Cher
Babe (i've got you ...)
Ruth
Sultan
Swing
Swap
Meet
Potato
Gravy
Train
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 15, 2015 at 5:44 am
Viewing 15 posts - 751 through 765 (of 1,251 total)