Viewing 15 posts - 451 through 465 (of 1,048 total)
Can you please provide us some more details that what you did and what you want to achieve?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 11, 2013 at 12:27 am
can you please post table structure and stored procedure ?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 11, 2013 at 12:23 am
Good question 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 10, 2013 at 11:26 pm
Sean Lange (6/7/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 10, 2013 at 5:26 am
Andrew,
Replace your query with this one:
SET @NewPhoneNumber = REPLACE(@PhoneNumber,LEFT(@PhoneNumber,5),'')
it will works 🙂
You just switch the arguments of LEFT thats why it was not working
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 10, 2013 at 5:23 am
Lokesh Vij (6/6/2013)
Interesting question Mark!With no idea about the question, I went ahead with a fluke and got that correct 🙂
+1
waiting for experts views on this 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 6, 2013 at 11:48 pm
select LEFT('[N] 18. Is the C.B. removed from the panel? [Yes / No]',43)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 5, 2013 at 6:36 am
Danny Ocean (6/4/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 5, 2013 at 4:53 am
Easy one for the day 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 5, 2013 at 4:52 am
Lynn Pettis (6/5/2013)
It would help to have the DDL for the tables involved, some sample data for the tables and the expected results when the processing is completed.
Here is the...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 5, 2013 at 12:15 am
GilaMonster (6/4/2013)
kapil_kk (6/4/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 4, 2013 at 6:41 am
Kingston Dhasian (6/4/2013)
SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021' AND VoucherBookletNo ='VVB0000025'
If your query is translated in simple English, it will be something like
Give...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 4, 2013 at 5:07 am
Kingston Dhasian (6/4/2013)
SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021' OR VoucherBookletNo...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 4, 2013 at 4:26 am
Lokesh Vij (6/3/2013)
Srinivas.Pendyala (6/3/2013)
what about the 5 th value,why it is not giving output of 5?
Srinivas, The idea here is we are using "TOP(6) WITH TIES", initially "TOP 6"...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 3, 2013 at 11:31 pm
NBSteve (6/3/2013)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 3, 2013 at 11:19 pm
Viewing 15 posts - 451 through 465 (of 1,048 total)