Go Premium for a chance to win a PS4. Enter to Win

x

Microsoft SQL Server

159K

Solutions

49K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Share tech news, updates, or what's on your mind.

Sign up to Post

Your access to October’s Course of the Month expires today! Enroll now and begin adding Microsoft SQL to your professional skills.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE
LVL 5
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

v2-native-ad-no-button.pngOnly five days left to enroll in October’s Course of the Month! Once you enroll, you’ll have 30 days to complete the Microsoft SQL Server and Database Concepts course.
0
native-ad-no-button.pngThe end of October is approaching and you only have nine days left to enroll in our Microsoft SQL Server and Database Concepts course. Enroll today and take advantage of this complimentary Course of the Month training.
4
Have you enrolled in this month’s complimentary course? Enroll now for a free Microsoft SQL Server and Database Concepts course. Get 7+ hours of step-by-step SQL training, including possible topic interview questions.
0
I've a stored procedure SP1 built. It has 8 columns n 6 rows. I also created a table T1 with exact 8 columns as SP1 and this table is empty. How do I insert 6 rows from SP1 into T1? Does the insert statement need to be inside the stored proc SP1 or can be it a separate query?
0
 
LVL 124

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE^2)
You may want to post this Question, in the Microsoft SQL Server, SQL, Query Syntax topic areas, to get an Answer.
0
 

Author Comment

by:LION KING
Thank you Andrew.
0
How to create a 4 quarter rolling calendar / period in sql server? For instance, if Table A as a date field - DATE1.
0
v2-native-ad-no-button.pngDo you work with and analyze data? Enroll in October’s Course of the Month to get step-by-step SQL training. Learn SQL to quickly and efficiently store and retrieve data!
0
native-ad-no-button.pngOctober’s Course of the Month is available! Enroll today to get 7+ hours of step-by-step Microsoft SQL Server training.
4
hi i  have 3 tables in sql server and i want to save all 3 table data into one new table WIN_20170930_221232.JPG
any help me?
0
 
LVL 60

Expert Comment

by:Kevin Cross
You should post this as a Question and it will draw in Experts within the areas you designate.  It looks like you will want to ask about how to JOIN data.  Good luck!

Ref: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
 
LVL 60

Expert Comment

by:Kevin Cross
Welcome to Experts Exchange by the way!
0
2
Fill in the form and get your FREE NFR key NOW!
LVL 1
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

1
We are importing (Bulk Insert) of around half million records to the staging table and then to the production table.

More often column data type or size validation fails the bulk insert process from Staging table to the Production table.

I will have to redesign the process by SSIS packages by inserting all the good records from Staging to the Production and load the bad / error out data to the staging table. Those bad or error out data with proper validation message.

Validation message is based on first error out column. If the all the columns in that row are erroring, we can consider with the first column error and reload the data after fixing that data.

Example Error Message: Column PurchaseDate has invalid data

How do I achieve this complete workflow SSIS package. What are the controls, I need to use to start with?

Please :)
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi chokka,

What you have done is made a "Post" here. To get help from the experts, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
How to design a Hierarchy based Table Relation?


To give an example: Organizational Chart. I am actually working on a Product based database.  Lacking in the design.
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi chokka,

What you have done is made a "Post" here. To get help from the experts, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
A real head scratcher

SQL Server 2005
Web Service .Net Framework 3.5
Symbol MC3190
VB.NET Compact Framework 3.5

Dates consumed by the compact framework are shifted by the difference in the timezone between the server and the client.

Luckily for me the fix was as just a matter of setting the client machines timezone to that of the server.

Just putting it out there in case someone runs into something similar.

https://social.microsoft.com/Forums/en-US/9858d657-ce26-442a-86a7-e2ba6b774ebf/sync-framework-over-wcf-sql-2005-datetime-is-shifted-by-timezone?forum=syncgeneral


0
Watching Paul Randal's course SQL Server: Performance Troubleshooting Using Wait Statistics on Pluralsight to help troubleshoot competing production processes and SQL Agent jobs.
0
0
0
SQL PASS DBA Fundamentals mtg going on now.  Gail Shaw talking about Indexes, and her cat is talking back.  :-)  http://fundamentals.pass.org/
4
 
LVL 66

Expert Comment

by:Jim Horn
Joined.  Thanks for posting.
0
Today is the last day to enroll in the free course of the month! Premium members, Team account members, and Qualified Experts can enroll in the CompTIA A+ course as part of their membership. Once you enroll you have 30 days to complete the course. Take advantage of this month's course today!

7
 
LVL 12

Expert Comment

by:Andrew Leniart
Not meaning to be pedantic, but you actually get 31 days to complete the course :)  I've just gone through the first section myself and can highly recommend this course. The instructor and content is excellent. Very informative.
4
 
LVL 17

Expert Comment

by:Spike99
Cool, I'll try it. Thanks for the head's up.
1
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

10
I'm glad to see Liquidweb is a new topic here. They have been my web host of choice since about 2008 or 9 and I have twenty some posts here on why I like LW https://www.experts-exchange.com/questions/28434976/recommend-a-hosting-provider.html#a40069498

They completely helped me from migration from a previous host and through several critical server upgrades VPS -> dedicated windows server 2003->2008->2012.  Whenever I have an issue, the person that takes the ticket is friendly and very knowledgeable. Other hosting services I have used, a help call or ticket starts at a low level and has to get escalated. At LW, 99% of the time, the person that you initially contact is the person that fixes the issue be it by submitted ticket or a panicky phone call.

One of the add on services I use for my dedicated server is continuous back up on my SQL Server drive. I have client billing systems on this server and one time did encounter a crash. Because of the continuous back up, no data was lost and everything was restored in quick manner.
11
Is it just me or is NoSQL Overapplied? It seems like in an effort to be as trendy as possible people shoehorn obviously relational problems into non relational schema. If you have to start throwing foreign keys on your objects I think you need to rethink your solution. Sarah Mei makes a good point about this in her article:

http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/
4
 
LVL 15

Expert Comment

by:Phil Phillips
It was definitely over applied initially. Though, I think it's gotten better over the years. Part of it, too, is that a lot of the relational databases started incorporating NoSQL-like features (i.e. PostgreSQL and their JSON capabilities).
3

Microsoft SQL Server

159K

Solutions

49K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.