Click here to Skip to main content
14,741,857 members
Home » Discussions » Database
   

Database

 
AnswerRe: Table Design Suggestion Pin
Nathan Minier8-Dec-17 2:33
professionalNathan Minier8-Dec-17 2:33 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 18:46
MemberManish K. Agarwal10-Dec-17 18:46 
GeneralRe: Table Design Suggestion Pin
Nathan Minier11-Dec-17 2:38
professionalNathan Minier11-Dec-17 2:38 
AnswerRe: Table Design Suggestion Pin
Richard Deeming8-Dec-17 2:35
mveRichard Deeming8-Dec-17 2:35 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 18:53
MemberManish K. Agarwal10-Dec-17 18:53 
AnswerRe: Table Design Suggestion Pin
Mycroft Holmes9-Dec-17 1:00
professionalMycroft Holmes9-Dec-17 1:00 
QuestionCan the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 5:14
professionalRichard Andrew x646-Dec-17 5:14 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Richard Deeming6-Dec-17 10:51
mveRichard Deeming6-Dec-17 10:51 
There are a few aggregate operators the work on varchar columns - for example, Max.

sql - PIVOT with varchar datatype - Stack Overflow[^]
sql server - Pivot Table with varchar values - Stack Overflow[^]
SQL Server pivoting on non-numeric data types - SQL Shack[^]



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 13:16
professionalRichard Andrew x646-Dec-17 13:16 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Jörgen Andersson6-Dec-17 11:05
professionalJörgen Andersson6-Dec-17 11:05 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 13:17
professionalRichard Andrew x646-Dec-17 13:17 
QuestionSQL and database tutorials Pin
MikeTheFid4-Dec-17 12:52
MemberMikeTheFid4-Dec-17 12:52 
AnswerRe: SQL and database tutorials Pin
Mycroft Holmes4-Dec-17 14:17
professionalMycroft Holmes4-Dec-17 14:17 
GeneralRe: SQL and database tutorials Pin
MikeTheFid5-Dec-17 1:33
MemberMikeTheFid5-Dec-17 1:33 
QuestionSQL SERVER script Pin
Member 135516041-Dec-17 0:08
MemberMember 135516041-Dec-17 0:08 
AnswerRe: SQL SERVER script Pin
Richard MacCutchan1-Dec-17 0:31
mveRichard MacCutchan1-Dec-17 0:31 
AnswerRe: SQL SERVER script Pin
Simon_Whale4-Dec-17 6:33
professionalSimon_Whale4-Dec-17 6:33 
QuestionSchedule a trace file in SQL Profiler Pin
VK1928-Nov-17 8:06
MemberVK1928-Nov-17 8:06 
AnswerRe: Schedule a trace file in SQL Profiler Pin
Richard Deeming28-Nov-17 8:27
mveRichard Deeming28-Nov-17 8:27 
AnswerRe: Schedule a trace file in SQL Profiler Pin
jschell1-Dec-17 9:01
Memberjschell1-Dec-17 9:01 
GeneralRe: Schedule a trace file in SQL Profiler Pin
VK194-Dec-17 3:17
MemberVK194-Dec-17 3:17 
GeneralRe: Schedule a trace file in SQL Profiler Pin
jschell5-Dec-17 11:24
Memberjschell5-Dec-17 11:24 
GeneralRe: Schedule a trace file in SQL Profiler Pin
VK196-Dec-17 4:39
MemberVK196-Dec-17 4:39 
GeneralRe: Schedule a trace file in SQL Profiler Pin
jschell8-Dec-17 9:14
Memberjschell8-Dec-17 9:14 
QuestionFatal error: Out of memory (allocated 408944640) (tried to allocate 805306376 bytes) Pin
Mahtabpi25-Nov-17 0:11
MemberMahtabpi25-Nov-17 0:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.