Viewing 15 posts - 46 through 60 (of 86 total)
Steve,
I recreated the source table with the same destination datatypes... surprisingly i still get the same error..
--Pra:-):-)--------------------------------------------------------------------------------
February 26, 2013 at 9:01 am
Oh good to know... I will check on dat.. and get back...
--Pra:-):-)--------------------------------------------------------------------------------
February 26, 2013 at 8:39 am
Steven Willis (2/25/2013)
BEGIN
SET @sql = @sql +'INSERT INTO ' + @dbname + '.dbo.Organization (Last_Backup, Backupsize) select '
-- The problem might be one of...
--Pra:-):-)--------------------------------------------------------------------------------
February 26, 2013 at 7:56 am
joeroshan (2/25/2013)
If it is not null try...
--Pra:-):-)--------------------------------------------------------------------------------
February 26, 2013 at 7:46 am
so what you say is, even if it doesn't show the result in SSMS when i try to exec the local variable it works???? Problem is only with displaying it...
--Pra:-):-)--------------------------------------------------------------------------------
February 25, 2013 at 8:32 pm
Ya I changed it in the very first step... But still getting the same error.. 🙁 🙁 🙁
--Pra:-):-)--------------------------------------------------------------------------------
February 22, 2013 at 10:00 am
mrTexasFreedom (1/17/2013)
Sadly, this isn't matching any rows:
select id, name
FROM my_user_table
WHERE CHARINDEX(name,CHAR(0),1) > 0
No rows returned. Likewise, the replace operation doesn't touch any of the rows. Ideas?
Thank you very much...
--Pra:-):-)--------------------------------------------------------------------------------
February 18, 2013 at 1:01 pm
M sorry i mean 11 instead of 12... Sry for the confusion
--Pra:-):-)--------------------------------------------------------------------------------
February 15, 2013 at 8:23 pm
Ahhh This works.... and you are a fantastic listener.. Thanks a ton
select * from LOG_tblAddtest
WHERE h1_Add LIKE '%' + CHAR(9) + '%'
AND DioUniID = 207261;
--Pra:-):-)--------------------------------------------------------------------------------
February 15, 2013 at 1:56 pm
select
h_Address_1,
N as Position,
DioUniqueID,
LogDate,
SUBSTRING(h_Address_1,N,1) As TheChar,
ASCII(SUBSTRING(h_Address_1,N,1)) TheAsciiCode
from LOG_tblAddressBK
CROSS APPLY (SELECT TOP 255 ROW_NUMBER() OVER (ORDER BY (SELECT...
--Pra:-):-)--------------------------------------------------------------------------------
February 15, 2013 at 1:48 pm
Thankyou Again:)
--Pra:-):-)--------------------------------------------------------------------------------
February 15, 2013 at 1:43 pm
Lowell,
Thankyou for ur response.. It worked so well.. I just couldnt believe that my problem resolves in no tym... 🙂 Would you also help me Now if i want to...
--Pra:-):-)--------------------------------------------------------------------------------
February 15, 2013 at 1:27 pm
hey did u find any solution at all... its coz i have same scenario at my work place.. Two servers which are not connected and are remote but shd synchronize...
--Pra:-):-)--------------------------------------------------------------------------------
February 12, 2013 at 9:35 pm
they are replicating a database... The main database is Michigan.. But they set up pull subscription from newyork... both the databases are remote... and the newyork people dont have access...
--Pra:-):-)--------------------------------------------------------------------------------
February 12, 2013 at 12:34 pm
Yep...dont forget to practise.. Install trail version of Sql server Mgmt studio and play around..Post any questions with your approach after trying them. dont post any questions without trying..dat helps...
--Pra:-):-)--------------------------------------------------------------------------------
February 12, 2013 at 10:47 am
Viewing 15 posts - 46 through 60 (of 86 total)