Viewing 15 posts - 1,741 through 1,755 (of 1,988 total)
pwalter83 (3/25/2015)
ZZartin (3/25/2015)
Just out curiousity are those varchar fields you're using MAX on? While that will work is that really what you want?
Yes, those are all varchar fields. Is...
March 25, 2015 at 11:24 am
Just out curiousity are those varchar fields you're using MAX on? While that will work is that really what you want?
March 25, 2015 at 10:59 am
It's possible that's a tab not a space between the names.
March 25, 2015 at 10:16 am
Based on the data you provided what is th expected output?
March 25, 2015 at 7:52 am
Based on what you have posted, these indexes are not helping you in any way. Indexes speed up reads and slow down modifications. In other words an index, when used,...
March 24, 2015 at 11:54 am
Well yes if the web server was restarted before sql server and it tried to run a job that needed to connect to sql server before sql server was running...
March 23, 2015 at 1:50 pm
Well is the primary key also the clustered index?
March 20, 2015 at 3:00 pm
I'm sure there's a prettier solution to this but this should give you the start and end date of each contiguous group, if you want to see only groups with...
March 20, 2015 at 10:44 am
Sean Lange (3/19/2015)
Luis Cazares (3/19/2015)
Would this be a valid URL http://www.thisisaninvalidurl.com? It has the correct format but...
March 19, 2015 at 4:09 pm
I'm sure you could write some kind of CLR function that would go ping your URL's, that'll tell you whether they're valid or not 😀
Trying to rely on regular expressions...
March 19, 2015 at 3:14 pm
That sounds like a very painful way to pad a string.
RIGHT('0000000000' + YOUR_ACCOUNT_NUMBER, 10)
March 18, 2015 at 4:15 pm
Sangeeth878787 (3/18/2015)
March 18, 2015 at 2:50 pm
I believe you would need to handle that on the reporting platform side not the database side(other than creating new views with the appropriate columns), for example in excel unless...
March 18, 2015 at 2:16 pm
Well without knowing more about what you're trying to do it's hard to say but have you tried checking @@ROWCOUNT after your insert into
INSERT INTO MY_TABLE(....) SELECT ......
IF @@ROWCOUNT >...
March 18, 2015 at 9:49 am
Well the way you test for a query not returning/returning records is by running the query..... so what exactly is the problem with running the insert into if no records...
March 18, 2015 at 9:06 am
Viewing 15 posts - 1,741 through 1,755 (of 1,988 total)