I got it right ... :w00t:

friday rocks.... :hehe:

cool ; i didn't know ....

nice question

gsd1 (10/30/2012)

---

Thanks for all the replies...

As Sean Lange suggested, I tried with temp table (instead of temp variable).

I faced these problems.

1. I have to build the sql statement. So...

that's a good one.. creating dynamic variable dynamically...:-P

you might be able to create the table variable dynamically...

yes like ternary operator..

.or conditional operator in C (if i remember correctly that's what it called)...

I once face this issue while loading an image in binary format and saving it to the database ..

If the length...

ya convert it to what ??

it looks like datetime2 ...

oh , I got it wrong , I thought instead of null, it will give default 0 as output..

..

learned something though 😉

thanks for the question...

I found the glitch ..

nice question...

thanks

Eid mubara Jamsheer..

I knew of the PARSENAME ..there is a wonderful use of this for taking out the dot...

A new one for me ...

thanks

gosh.. I almost overlooked the quoted null ..:w00t:

nice question....:Whistling:

Eugene Elutin (10/16/2012)

---

santoshupadhayay87 (10/16/2012)

---

i want to add three table to the datbase out of which two are from one table and one is of another table can anyone please...

santoshupadhayay87 (10/16/2012)

---

i want to add three table to the datbase out of which two are from one table and one is of another table can anyone please help me...

Let me know if this helps..

Then in the SSMS :

create table #test(a int,b varchar)

BULK INSERT #test1

FROM 'C:\Test.csv'

WITH

...