Need to modify it slightly to fit your requirements. but this is my solution to rotate table vertically

Look like forum does not allow the drop statements for temporary tables, that...

PiMané (10/1/2012)

---

haiao2000 (10/1/2012)

---

For some reasons, everyone a while I COULD NOT post the code using any of IFcode. there is some issue with @ or #. Anyone see similar issue...

For some reasons, everyone a while I COULD NOT post the code using any of IFcode. there is some issue with @ or #. Anyone see similar issue witht this...

Some one suggested this function works

ALTER function [dbo].[ConvertBigIntToVarBinary1](@param bigint)

returns varbinary(1000) AS

begin

declare @iPower int;

declare @result varbinary(1000);

...

Yes there is, if you run the function and pass a parameter like 5, you will see the result. Just perform a normal conversion would not give the desire result

--would be appreciate if next time you post sample data like this, either that or post your credit card number we can charge to 🙂

declare @temp table(Corp_address int, paid_date_interval numeric(9,2),...

ultimate sql (9/17/2012)

---

Yes, that's correct. 🙂

And if you want to keep the data in default varbinary format and display it in character when selecting then last statement can be changed...

Ah

I figured out the solution after posting.

insert into @temp(binaryField)

select convert(varbinary(max), @result , 2)

Thanks anyway Experts! 🙂

Lynn,

Sorry, you are absolutely correct. it is just another database on the same server. we have 2 databases sitting on the same server.one is a live database, another is backup...

One more issue though.. how do i check table on another database from one database . if i run this query from the "MainDatabase" and set table...

Sean,

Great which mean you guys are fast and furious!

Thanks for all the helps, I am sure this will work.

Sean Lange (8/24/2012)

---

Try this instead then:

if EXISTS

(

select * from sys.columns

where object_id =...

Lynn

This is what I am looking for. Great! Let me try this. Thank You!

Lynn Pettis (8/24/2012)

---

Then you may want something more like this:

Sean

That will not work because TableB may not have a column with identify specification properties set to YES. The reason i do this because these tables being created dynamically by...

Thank you for quick response. I actually replied to my post previously. you are right all i tried to do on that is basically squelching, definitely not handling. I am...

It looks like the issue is because the exception occurs at the line below . Basically what I try to do is

try to set insert identity ON for every...