Viewing 15 posts - 5,071 through 5,085 (of 8,731 total)
Maybe you could do this to find offending rows.
select fieldname
from tablename
EXCEPT
select fieldname
from tablename
where fieldname
NOT LIKE N'%[^'+nchar(0x9)+nchar(0xA)+nchar(0xD)+nchar(0x20)+N'-'+nchar(0xD7FF)+N']%'
The NOT LIKE N'%[^Pattern]%' will return non-offending rows....
March 30, 2015 at 6:07 pm
Quick question.
Can the packages contain packages?
March 30, 2015 at 3:43 pm
That's right and wrong at the same time. :hehe:
Every modification to a database (in SQL Server) is part of a transaction. Each transaction (which can contain several statements) will be...
March 30, 2015 at 1:25 pm
I've been told that Celko's personality in the forums isn't at all his real self. It's just a persona created to make people learn.
March 30, 2015 at 12:32 pm
That happens when the backslash doesn't exist in the string and generates 0-1=-1 which is invalid for the parameter.
Use a safety net to prevent this and remove the spaces (unless...
March 30, 2015 at 11:54 am
It would be easier if you have a calendar table.
SELECT DISTINCT r.VisitID, c.cal_Date
FROM #Results r
JOIN Calendar c ON c.cal_Date BETWEEN r.DateFrom AND r.DateTo
You could build one using a tally table.
March 30, 2015 at 11:33 am
I would think of Ozzy Osbourne. They're both precursors on their genres (SQL & heavy metal) and they appear to be more frightening than they really are. They both have...
March 30, 2015 at 11:09 am
Stephanie Giovannini (3/30/2015)
Instead of inventing the word "beginnator" as the opposite of terminator, how about "initiator"? It's already an English word. Statement initiator vs. statement terminator--I think that sounds reasonable.
Just...
March 30, 2015 at 10:35 am
I'm just adding a safety net.
if OBJECT_ID('tempdb.dbo.#names', 'u') is not null drop table #names;
create table #names (
FullName varchar(100));
insert into #names(FullName)
values('Ed Wagner'),
...
March 30, 2015 at 8:52 am
For 2 columns, a splitter such as the Delimited8k would be too much.
This thread might give you an idea on how to do it.
http://www.sqlservercentral.com/Forums/Topic1670877-391-1.aspx
March 30, 2015 at 8:28 am
Eirikur Eiriksson (3/30/2015)
;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.😎
I beg to differ.
IF...
March 30, 2015 at 8:24 am
What happens if you have full names with more than one space in them?
March 30, 2015 at 8:14 am
ABAS101 (3/27/2015)
;WITH DiagWithRowNum AS
(
SELECT
VisitGuid,
DiagnosisText,
ROW_NUMBER() OVER (Partition...
March 27, 2015 at 2:49 pm
This article should help you get what you need.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
March 27, 2015 at 1:55 pm
Ed Wagner (3/27/2015)
Sean Lange (3/27/2015)
Luis Cazares (3/27/2015)
Starting on April 21st I'll be working in the US. I'll...
March 27, 2015 at 11:03 am
Viewing 15 posts - 5,071 through 5,085 (of 8,731 total)