This is something I am thinking someone may have done already. Basically we have data loader which …
1 day ago
FYI Database collation is Arabic_100_CS_AS
Why do Arabic characters in a varchar column (c…
3 days, 6 hours ago
By: Mark T.
I've table and data as script below,
CREATE TABLE [dbo].[ClientProjects](
[Id] [int] IDENTITY(1,1) …
3 days, 14 hours ago
We have a scalar function that is used to add a specific number of business days to a date however …
4 days, 4 hours ago
Please assist creating an inline Table Valued Function. Output https://drive.google.com/file/d/1…
2 weeks, 6 days ago
Please assist creating an inline Table Valued Function. Output should look like this: https://drive…
By: Jonathan AC Roberts
I have a sample data, see below.
The base rules are
If the same CustomerID and Account…
3 weeks, 3 days ago
I ran into an issue this morning to read the data using OPENROWSET
I was able to read the f…
3 weeks, 4 days ago
I have a requirement to read csv files skipping the First X Rows and Last Y Rows using OPEN…
I feel like I have done this in the past, but cant remember what I did for it and even worse, …
I have a SSIS package with the following Connections:
ODBC Connection to 32 bit MS Windows System …
3 weeks, 5 days ago
We have a current ETL process that takes a delta and uses MERGE to decide whether the data …
3 weeks, 6 days ago
When i run a stored procedure, i would like to capture all the Database updates with table name and…
4 weeks ago
Thanks if you can help. DDL below.
This is similar to problems usually solved with RANK but …
By: Steve Collins
need help on below requirement.
1 month ago
By: Jeff Moden
Viewing 15 topics - 1 through 15 (of 1,323 total)
You must be logged in to create new topics.