Share via

Is my output correct regarding the example data I've been provided for this database?

Deushade 0 Reputation points
2023-04-18T01:04:36.4733333+00:00

I've created a database in SQL with insert statements for some data. What I can't understand is, my registration table output looks much different than the example data I've been given for the registration table. My table contains corresponding ID's while the example data has those outputs in text. Will I have to create joins afterwards? I thought It could display the ID's in text while creating the database. Here is the example data I'm supposed to follow, and what my output looks like in my database. Example Data

Screenshot (35)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,856 Reputation points
    2023-04-19T22:15:27.83+00:00

    Hi Deushade, Welcome to Q&A Forum; this is a great place to get support, answers, and tips. Thank you for posting your question; I'll be more than glad to help you out. As Olaf and Percy already stated, please answer the following:
    To adequately assist you with your issue/problem, it would be constructive for us to reproduce your scenario. Please provide us with at least the following things: (1) DDL and sample data population, i.e., CREATE table(s) plus INSERT, T-SQL statements. (2) What you need to do, i.e., logic and your attempt implementation of it in T-SQL. (3) Desired output based on the sample data in #1 above. (4) Your SQL Server version (SELECT @@version;)

    I hope my answer is helpful to you, Your Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

    0 comments