Viewing 15 posts - 31 through 45 (of 185 total)
DECLARE
@note VARCHAR(2000)
,@id INT
,@command varchar (2000)
DECLARE C_sql CURSOR FOR
SELECT '' AS [-- Notes --],
2 AS [-- print output --]
UNION
SELECT '--...
March 14, 2018 at 11:49 am
Its only giving result for one database and not other
DECLARE
@note VARCHAR(2000)
,@id INT
,@command varchar (2000)
DECLARE C_sql CURSOR FOR
SELECT '' AS [-- Notes --],
March 14, 2018 at 11:04 am
NorthernSoul - Thursday, May 4, 2017 6:20 AMAre you running it as an administrator?Thanks
Yes I am admin on the server
May 4, 2017 at 7:07 am
I downloaded SSMS 2016 from Microsoft website. I executed SSMS 2016 exe file but it does not install neither it gives any messages or generates any error.
May 4, 2017 at 6:10 am
ZZartin - Thursday, February 16, 2017 9:04 AMWhat do you plan to do with this random number?
my store procedure ( exec SP_DEV_generateanynumber)
When...
February 16, 2017 at 9:27 am
Let me give with Example:
I have table called Tracking_changes which contain 4 columns a
I want to get the output ONLY with differences in other column 2 and 3 and System...
January 15, 2015 at 1:06 pm
This is the Data I have in my table
NameIDGradesecSystem Date
sac11A1/5/2012
paul21A1/5/2012
Simon32B1/5/2012
Kelly42B1/5/2012
Nimo52B1/5/2012
sac11A1/4/2013
paul22A1/4/2013
Simon32B1/4/2013
Kelly42B1/4/2013
Nimo53C1/4/2013
OUTPUT I am expecting below (since only Grade and Sec I am concern about from System Date change)
NameIDGradesecSystem Date
sac11A1/4/2013
Nimo53C1/4/2013
January 15, 2015 at 1:03 pm
Thanks that's solved my problem using EXEC sp_MSforeachdb @command
November 11, 2014 at 7:36 am
I have text which is causing me issue
Text having data with value '369 Pacific ave, NC. (07818)'
August 18, 2014 at 3:52 pm
Viewing 15 posts - 31 through 45 (of 185 total)