Topics
Started by
Posts
Last post
Hello SSC! I have been tasked with optimizing a stored procedure the imports data from XML to SQL t…
3 replies
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup process, and I’d like …
1 replies
Hi - Currently, I have this DAX coded in Power BI Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([…
2 replies
Hi, Need this DAX covert SQL T-SQL. Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([Remedy Submitt…
2 replies
I have a list of transactions in a table. Each transaction has a unique id which is a Guid, a date,…
8 replies
In my SSIS package I have a Data Flow with a XML Source with the below XSD. The problem I have is w…
3 replies
Hello all. Trying to measure the time in days between to dates excluding weekends. Currently I have…
3 replies
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as S Where…
5 replies
Good morning to all. I am a novice when it comes to SQL so my question is TSQL related on how to u…
4 replies
This is the function oracle.xxxfloat BEGIN IF @first IS NULL OR @second IS NULL RETURN NULL IF @fir…
13 replies
Problem: I am trying to insert a a value into a column that has been encrypted using 'deterministic…
2 replies
Any suggestions for a good tool for documenting a database and all the important objects in it? I'm…
3 replies
I'm trying to use forfiles in an Execute Process Task in my SSIS package to delete files older than…
2 replies
SQL server became slow before I ran exec sp_updatestats
3 replies
Reposted this in Data Warehouse forum. This topic was modified 6 months, 2 weeks ago by Lo…
1 replies
Viewing 15 topics - 46 through 60 (of 393 total)
You must be logged in to create new topics.