Viewing 15 posts - 8,041 through 8,055 (of 13,876 total)
sqlbaby2 (10/12/2015)
October 12, 2015 at 5:13 am
dudekula.kareemulla (10/12/2015)
October 12, 2015 at 4:49 am
I have an idea.
If the subject of a post contains either "http://" or "https://", mark it as spam.
October 12, 2015 at 3:09 am
Felix Pamittan (10/12/2015)
Phil Parkin (10/12/2015)
Nice code, Felix.Quick suggestion...
Not sure how quick it was though; have you been listening to Eirikur?
Yeah! I've been lurking this forum for quite some time now...
October 12, 2015 at 2:04 am
Nice code, Felix.
Quick suggestion...
Not sure how quick it was though; have you been listening to Eirikur?
October 12, 2015 at 1:09 am
kdefilip (10/11/2015)
I have two tables, INCIDENT and PEOPLE
INCIDENT has two fields, ID and Date
PEOPLE has three fields, INC_ID [foreign key to INCIDENT.ID], PersonIteration, Complaint
There is always only one incident, but...
October 11, 2015 at 12:56 pm
Jason A. Long (10/9/2015)
Phil Parkin (10/9/2015)
Here's an iTVF version of the query I posted earlier.
Correct me if I'm wrong (a strong possibility), but I don't think we're able to reference...
October 9, 2015 at 12:01 pm
Jason A. Long (10/9/2015)
Phil Parkin (10/9/2015)
October 9, 2015 at 11:45 am
Here's an iTVF version of the query I posted earlier.
create function dbo.GetNumbers ( @data varchar(8000) )
returns table
return
select nums = left(substring(@Data, patindex('%[0-9.-]%', @data), 8000),
...
October 9, 2015 at 11:43 am
I found a 'GetNumbers' function here [/url] and that, when combined with Jeff's function, allows you to take the CLR out of the equation ... at least for the data...
October 9, 2015 at 11:25 am
anthony.green (10/9/2015)
baddulahariprasad (10/9/2015)
Hi,Just add 7 packages to the SQL Agent as a job with different steps and schedule it according to your requirement.
7 packages, a bit overkill.
Why not 1 package...
October 9, 2015 at 2:32 am
james.of.rivendell (8/12/2013)
Pretty sure it's called 'covering index' or less commonly 'cover index', but not 'covered index'. The index is not the one being covered.
+1
October 8, 2015 at 11:39 pm
garfieldlandry (10/8/2015)
If you change the target to a SQL Server table, does it work OK?
Do the columns which fail to be populated have anything in common? Same datatype, space in...
October 8, 2015 at 11:43 am
garfieldlandry (10/8/2015)
October 8, 2015 at 11:09 am
garfieldlandry (10/8/2015)
October 8, 2015 at 10:49 am
Viewing 15 posts - 8,041 through 8,055 (of 13,876 total)