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 GregM56 only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Member List
Calendar
Today's Posts
Home
GregM56
User Profile
Collapse
Profile Sidebar
Collapse
GregM56
Last Activity: Jan 20 '15, 02:32 PM
Joined: Jan 19 '15
Location:
Subscriptions
1
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
GregM56 only
Visitor Messages Only
Advanced
Filtered by:
Clear All
new posts
GregM56
replied to
using CONVERT VARCHAR with DISTINCT in Select
in
SQL Server
Jan 20 '15, 02:32 PM
Thank you so much Rabbit!
See more
|
Go to post
Leave a comment:
Post Comment
Cancel
GregM56
started a topic
using CONVERT VARCHAR with DISTINCT in Select
in
SQL Server
Jan 19 '15, 07:39 PM
using CONVERT VARCHAR with DISTINCT in Select
I can
SELECT CONVERT(VARCHAR (8), DXACCNUM)
but I cannot
SELECT CONVERT(VARCHAR (8),DISTINCT(DX ACCNUM))
I am merely trying to make that int column 8 char wide.
Any ideas from anyone?
Thanks!
See more
|
Go to post
Last edited by
GregM56
;
Jan 19 '15, 07:47 PM
.
Reason:
clarity
No activity results to display
Show More
Working...
OK
OK
Cancel
👍
👎
☕
Leave a comment: