Insert Value From Column into String Value of Another Column: Query

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2008 » SQL Server 2008 - General » Insert Value From Column into String Value of...

Add to briefcase

11 posts, Page 2 of 2

««1 2

Insert Value From Column into String Value of Another Column: Query

Expand / Collapse

Author

Message

Posted Tuesday, January 15, 2013 5:45 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 2,345, Visits: 3,190

Happy to be of service my friend.

No loops! No CURSORs! No RBAR! Hoo-uh!

INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Are you too recursively challenged?
Splitting strings based on patterns can be fast!

Post #1407526

« Prev Topic | Next Topic »

Add to briefcase

11 posts, Page 2 of 2

««1 2

Permissions

Expand / Collapse