Topics
Started by
Posts
Last post
This is getting the data I need, but not the format. select replace(convert(varchar, getdate(),101)…
8 replies
My goal is to replace the numbers 1-9 in a column with a different number. For this example the num…
4 replies
I have an SSIS package which outputs a flat file to the file system into a "staging" folder. The pa…
4 replies
Hello, I have a SQL view with a column called GlobalCountryRegionXML. Here is an example of a value…
6 replies
We are trying to update a stored procedure to reference objects that don't yet exist in preparation…
2 replies
I have a database D1 in Prod and TEST. In Prod D1 has 266 tables and in TEST D1 has 250 tables. How…
2 replies
Experts, I am not good with writing SQL codes but I found this script (shared below) which checks f…
5 replies
I've been considering using DATETIME2(3) over DATETIME for new work due to the 1-byte saving of equ…
24 replies
I have a query taking a long time to execute and it appears to be from using between conditions on …
3 replies
I need to extract changed records from a client's db. The client's db I have access to is a read on…
6 replies
Hi All, I wonder if someone can help with an SQL query I need for an SSRS subscription. The code …
7 replies
I am creating a User Defined Function in which I pass in a character string representing a date and…
6 replies
we have detail daily data in a table about members., trying to finding how many new members (by con…
30 replies
There is a stored procedure that updates some columns. I want the following: if the column value al…
2 replies
Hi there I have a query result (sub-query) and want to refine it more with another query. I'm tryin…
4 replies
By: Calvin
Viewing 15 topics - 1 through 15 (of 2,599 total)
You must be logged in to create new topics.