Viewing 15 posts - 31 through 45 (of 86 total)
How about casting to a decimal first?
What is the range of your values?
SELECT CAST(CAST(330420968 AS DECIMAL(32,0)) AS VARCHAR(32))
October 12, 2009 at 5:53 am
Hi thanks all for your feedback and Manu for your comprehensive post.
There is currently no appplication involved, all this happening through Mangement Studio. None the less I suppose it is...
August 31, 2009 at 8:58 am
Thanks.
Out of interest sake...
The reason I've used OPENQUERY is because I got errors when trying to use INSERT INTO-EXEC approach.
Is OPENQUERY the better approach (although i doubt it) when working...
August 26, 2009 at 8:18 am
Thanks for the suggestions ... will look into TVF approach.
August 26, 2009 at 8:10 am
Thanks Bob that works for me.
A bit off topic...in order to execute the storedProcs on the DB1 the linked server needs to be configured to allow remote procedure calls.
Is this...
August 6, 2009 at 9:00 am
Thanks ARUN, this worked for my scenario.
Thanks everyone for taking time to help me out.
June 29, 2009 at 3:53 am
I've spent a bit of time to rework my sample code and redefine my problem (@ARUN SAS - thanks for that link)
Ok here goes.
My Problem:
From the sample data below I...
June 26, 2009 at 6:11 am
Hi Wayne,
I have overly simplified my sample; in my real world sample BID is GUID (with multiple rows) and I will not be able to use it as you have...
June 26, 2009 at 1:14 am
Thanks very much for taking time to answer. Im still not able to accomplish what I intended (but then again I'm not the brightest crayon in the box 😛 )
Your...
June 25, 2009 at 8:02 am
Hi Wayne ... sorry about that i switched my keys :crazy:
Below is the more accurate sample.
In the included SELECT you will notice there are two rows for Bob. I need...
June 25, 2009 at 12:29 am
Backups, Early backups, Frequent backups and verified backups
Out of interest sake, how do you go about verifying your backups?
I typically restore a backup and do a DBCC CHECKDB. My problem...
April 8, 2009 at 8:29 am
Does the account you are using on the Subscriber have access to the repldata folder?
April 6, 2009 at 9:30 am
Viewing 15 posts - 31 through 45 (of 86 total)