Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in posts by dusana only
Search
Advanced Search
Forums
Product Launch
Updates
Today's Posts
Member List
Calendar
Home
dusana
User Profile
Collapse
Profile Sidebar
Collapse
dusana
Last Activity: Oct 22 '07, 01:08 AM
Joined: Oct 22 '07
Location:
Subscriptions
2
Subscribers
0
Activities
About
Media
Subscribed
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Source
All
dusana only
Visitor Messages Only
Advanced
Filtered by:
Clear All
new posts
dusana
replied to
Transposing Data of Table as Columns in SQL
in
SQL Server
Oct 22 '07, 12:49 AM
try this
Select ltrim(rtrim(Col 1)) as Col1, ltrim(rtrim(Col 2)) as Col2 from Table1 where Colx = 'A5100650867'...
See more
|
Go to post
Leave a comment:
Post Comment
Cancel
dusana
replied to
cast to integer?
in
SQL Server
Oct 22 '07, 12:46 AM
use this
insert into DataSet_Rows
select cast(col01 as int), cast(col02 as int) from tempout...
See more
|
Go to post
Leave a comment:
Post Comment
Cancel
dusana
replied to
cast to integer?
in
SQL Server
Oct 22 '07, 12:45 AM
insert into DataSet_Rows
select cats(col01 as int), cast(col02 as int) from tempout...
See more
|
Go to post
Leave a comment:
Post Comment
Cancel
No activity results to display
Show More
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Leave a comment: