i want to calculate last friday’s date in ssis with timestamp. Below gives me only date. C…
15 hours, 14 minutes ago
By: Jeff Moden
I found one formatter online, but wanted to know if you use any tools to format the T-SQL code …
2 days, 6 hours ago
I'm trying to work out the best way to work out a workflow to a particular set of tasks I…
2 days, 8 hours ago
By: shane.green 1227
2 days, 17 hours ago
I've been trying to optimize a large stored procedure. I found a code there that insert rec…
3 days, 13 hours ago
We don't have any DACPAC deployment options, and I was hoping to find out what the "right" way to s…
4 days, 10 hours ago
I have a table and I would like to choose the rows after a a specific date or event.
I wondered if anyone knew if you could use OPTION (USE HINT in views.
I have a view that when u…
4 days, 15 hours ago
By: Phil Parkin
I am not sure which forum i should post this into as this is more generic question.
We have req…
4 days, 22 hours ago
I have a program developed with a tool that generates cursors everywhere. If I run a query to g…
5 days, 8 hours ago
I have a column containing string values. I want to fetch all the values for which b…
6 days, 20 hours ago
I am managing a migration project for several thousand databases across dozens of SQL servers. Th…
1 week, 1 day ago
By: Jeffrey Williams 3188
Firstly my sample data
/****** Object: Table [dbo].[ChargeDataTemp] Script Dat…
1 week, 2 days ago
By: TSQL Tryer
My SQL is limited and I have inherited the schema so please go easy!
The upper tables are populate…
Hey guys! How do I upload a file with the structure as in the picture?
The XML has a structure li…
1 week, 3 days ago
Viewing 15 topics - 1 through 15 (of 698 total)
You must be logged in to create new topics.