Viewing 15 posts - 7,051 through 7,065 (of 8,760 total)
Quick thought, if no auditing is in place, start with the short list Gail mentioned.
😎
September 16, 2014 at 10:51 am
andyscott (9/16/2014)
September 16, 2014 at 10:47 am
abhas (9/16/2014)
I need to compare the next row with the previous row of same table and produce nonidentical column.
for eg... say
mytable has
Row 1 => 1001 Abhas 120 150...
September 16, 2014 at 8:14 am
Smash125 (9/16/2014)
34.100->34%
39.8->40
35.4->35 some thing like that. please le me...
September 16, 2014 at 4:55 am
Quick thought, this can be simplified with the charindex function, no need to actually split the input. The focus must be on what has to be done, not how;-)
😎
DECLARE @reportID...
September 15, 2014 at 10:59 pm
Jeff Moden (9/15/2014)
Eirikur Eiriksson (9/13/2014)
Jeff Moden (9/12/2014)
September 15, 2014 at 10:51 pm
dexdev (9/15/2014)
Hope you guys can help...
We created an application that is using multiple dbs, one for each client using the application. All dbs are identical, each db holds the client's...
September 15, 2014 at 10:36 pm
Matt Miller (#4) (9/15/2014)
Grant Fritchey (9/15/2014)
Eirikur Eiriksson (9/15/2014)
Grant Fritchey (9/15/2014)
But, that could cause...
September 15, 2014 at 2:38 pm
Quick thought, use the CONCAT function, no need to worry about overlapping operators
😎
DECLARE @INT INT = 10000;
DECLARE...
September 15, 2014 at 2:33 pm
ScottPletcher (9/15/2014)
Two quick possibilities:
1) Add an optional parameter to the proc which requires a certain value or the proc just exits (or...
September 15, 2014 at 2:12 pm
Grant Fritchey (9/15/2014)
But, that could cause errors in the code if it tries...
September 15, 2014 at 1:58 pm
Quick thought, don't ever use geometry for geographical data, use geometry with the appropriate SRID, normally 4326.
mickyT's solution is straight forward, just make certain that the direction is correct...
September 15, 2014 at 1:51 pm
f.welten (9/11/2014)
September 15, 2014 at 10:29 am
BWFC (9/15/2014)
Eirikur Eiriksson (9/15/2014)
😎
;WITH SAMPLE_DATA(MOBILE) AS
(SELECT * FROM
(VALUES
('9334457582')
...
September 15, 2014 at 3:46 am
Quick solution, allows for variable length input
😎
;WITH SAMPLE_DATA(MOBILE) AS
(SELECT * FROM
(VALUES
('9334457582')
...
September 15, 2014 at 3:16 am
Viewing 15 posts - 7,051 through 7,065 (of 8,760 total)