I have a the below table, from the result set I only want to see records where the Statu…
3 weeks, 6 days ago
By: Steve Collins
I want change schema name on Table.
1 month, 2 weeks ago
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 month, 4 weeks ago
In the query below do I need to join tables Brs to MYCTE in the UPDATE portion of the query?
2 months, 3 weeks ago
*** EDIT 2015-03-04: please be advised the code I posted originally below was in need of some impro…
4 months, 3 weeks ago
I've been researching for past two days and hitting my head against wall, but I can't figure this o…
6 months, 3 weeks ago
Assuming I have a table similar to the following:
Auto_ID Account_ID Account_Name Account_C…
I have a query where I am trying to find out if there are 2 authorizations for the same time frame.…
7 months, 3 weeks ago
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…
8 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]
8 months, 1 week ago
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
I looked all over the web, and there are different opinions about this error. It's dif…
8 months, 2 weeks ago
Viewing 15 topics - 1 through 15 (of 10,638 total)
You must be logged in to create new topics.