I'm running into the following message, "String or binary data would be truncated. [SQLSTATE 22001]…
1 year, 5 months ago
i have 5 database with same table schema in my branches
i want to have one data base in my…
1 year, 8 months ago
I have a the below table, from the result set I only want to see records where the Statu…
1 year, 9 months ago
By: Steve Collins
I want change schema name on Table.
Dear SQL Expert,
I want to make a query to calculate the amount for budget purposes.
Here's the for…
By: Jeff Moden
Does anyone know how to read files from spesific folder/path using T-SQL?
1 year, 10 months ago
In the query below do I need to join tables Brs to MYCTE in the UPDATE portion of the query?
1 year, 11 months ago
*** EDIT 2015-03-04: please be advised the code I posted originally below was in need of some impro…
2 years ago
Assuming I have a table similar to the following:
Auto_ID Account_ID Account_Name Account_C…
2 years, 3 months ago
I have a query where I am trying to find out if there are 2 authorizations for the same time frame.…
By: Steve Jones - SSC Editor
I execute a script that someone else wrote and I get Query Completed with Errors but there is not a…
2 years, 4 months ago
Users are experiencing some performance issues when they come in/out of the building. Their ID card…
I have a Budget Table in following format
Account -- Year -- Month1- Month2- Month3- Month4- Month5…
By: jcelko212 32090
I have to deal with a table with schema designed as below:
CREATE TABLE [dbo].[UseCase]
By: MVDBA (Mike Vessey)
This is very painful to me, I have a list of location and need to determine as much/close as possib…
By: PasLe Choix
Viewing 15 topics - 16 through 30 (of 10,644 total)
You must be logged in to create new topics.