Converting Sheet Excel to a SQL Server equation (1 Viewer)

[sharawee707]

Please help me convert Excel to SQL Server according to the attached example

 

[arnelgp]

maybe ask ChatGPT.

 

[GPGeorge]

One thing you could do to help others help you is provide the context and business reason for the code in question. Asking someone to analyze and interpret code with no guidance as to what you hope to achieve is a pretty big ask. Encouraging others to help by giving them enough background to start with can go a long way toward success.

 

[theDBguy]

Hi. Welcome to AWF!

Is this a school project? Just curious...

 

[mikenyby]

Okay so here's what you're going to do. First create a view using this code:

[REDACTED]

You're good to go!

IMPORTANT NOTE: If this is not a school project and you are not asking us to do your homework for you, then absolutely DO NOT do what I described above. If otherwise, go nuts buddy.

CODE REDACTED by The_Doc_Man 10/25/2024 16:10 CDT USA
REASON: Code is dangerous and represents a bad joke bordering on malicious behavior, which is EXPRESSLY not allowed. @mikenyby, this is dangerously close to improperly aggressive behavior to another member. Please do not do this again.

 

[Isaac]

Whoever opened a zip file from a member with 1 post is a better man than I.

And whoever provided that code, well ...

 

[Gasman]

Can anything self execute on opening a zip file?, as I peeked

 

[Isaac]

Too much weirdness for me. A new person posts a zip file instead of an excel file, then someone else posts code to drop tons of your sql tables.
Looks like a duel!

 

[Gasman]

I think the code was a joke, as it came with a disclaimer?

 

[The_Doc_Man]

As noted in the offending post, the destructive code was removed.

 

[sharawee707]

DECLARE @a DATE
a:

SELECT (YEAR (GETDATE()))-1, MONTH('2020-12-29'),DAY('2020-12-29')

BEGIN
PRINT @a
END

 

[mikenyby]

As noted in the offending post, the destructive code was removed.

My apologies, I tried to make it as obvious as possible that this advice should not be followed, but I will be more conscientious in the future.

 

[Gasman]

My apologies, I tried to make it as obvious as possible that this advice should not be followed, but I will be more conscientious in the future.

People here and on other sites just copy code supplied, which to us is obvious that the names need to be changed (as we do not know) them , so anything is possible.