Viewing 15 posts - 1,936 through 1,950 (of 3,738 total)
Yes you are right about there being a business need to concatenate.
I misread his question but since the values are numbers that are being concatenated I was wondering about the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 3, 2012 at 10:31 am
Gosta,
It turns out that I belonged to that list when I was converting Lotus Notes to Excel for a Year 2K Project (12 years ago).
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 3, 2012 at 6:25 am
Thanks Gosta.
By chance do you when you create a new connection to SQL Server how do you specify where the connection is used?
I tried defining a range and I get...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 3, 2012 at 6:04 am
Well thank you and I'm sorry for not thanking you and others.
Please accept my apology. :blush:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2012 at 11:10 am
george sibbald (1/2/2012)
The single user mode solution was posted 3 days ago, and in your parallel thread on the same subject, 4 days ago, did you not believe us?🙁
I mentioned...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2012 at 10:33 am
Thanks again Gail.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2012 at 9:25 am
Sorry but what you are doing is not usual or customary.
If you want to execute the code then it should not be in the after update event code.
Generally an after...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2012 at 9:04 am
It is relative simple to pass parameters or a collection of to a Stored Procedure.
Basally assign the values of the form controls and Execute the SP with the parameters.
I have...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2012 at 8:59 am
Dev (11/29/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2012 at 8:45 am
Thanks Brandie.
I had to put this on the back burner because my priorities have changed but SA is the only Account that is a member of the sysadmin role.
Thanks!
sp_helpsrvrolemember
ServerRoleMemberNameMemberSID
sysadminsa...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2012 at 8:23 am
?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 1, 2012 at 4:38 pm
...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 1, 2012 at 4:09 pm
...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 1, 2012 at 4:06 pm
Thank you for correcting me!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 1, 2012 at 3:11 pm
stebennettsjb (1/1/2012)
simple one for you experts im sure. I have a table with values in col1 and col2
I want to put both values into a new col with...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 1, 2012 at 1:50 pm
Viewing 15 posts - 1,936 through 1,950 (of 3,738 total)