TSQL QUESTIONS

I think the issue was by ths following , I have this requirement to convert a list of account active dates to provide the active start and end dates for each sequence of dates and the days between the dates. For example, this is the list of active da

TAG : tsql

it helps some times "w" is not shorthand for weeks, it is an alias for WEEKDAY. Since Weekday does not really make sense as a datediff option, I would guess that this is treated like days under the hood.If you want weeks difference, you need to use "

TAG : tsql

To fix this issue As stated, I'm not able to test this, but this is what I'm suggesting you change:

TAG : tsql

it should still fix some issue In the Modelling tab in Power BI, click on New Table and use the below expression:

TAG : tsql

wish of those help How can I turn the next query: , If you prefer single step:

TAG : tsql

To fix this issue I could really do with some help and intend to be active in this community and help others in return. I am a SQL developer using MS SQL Server for the last two years but I've hit a roadblock on this one. Imagine the scenario you hav

TAG : tsql

help you fix your problem You can put your CASE expression in a CTE and refer to it multiple times by its alias in the query to follow. However, since your CASE expression for F_YEAR is different from the one for F_Quarter there is no way to only use

TAG : tsql

hope this fix your issue Do you know why this piece of code returns syntax error? A subquery executes properly. , Found one problem and fixed it in the following:

TAG : tsql

I wish this helpful for you 1st step was to create a date table. Figuring out weekday verse weekends is easy. Weekdays are 1, weekends are 0. Borrowed someone else's holiday calendar, if holiday 1 else 0. Then Business day is Weekday-Holiday = Busine

TAG : tsql

this will help maybe someone or something with enough permissions made a mistake by reseeding?As simple as this:

TAG : tsql

To fix this issue This is the error i am getting while creating the Stored Proc below : Incorrect syntax near ','. I am trying to separate columns inside CONCAT function with Hyphen and Comma but if I remove Hyphen and Comma it works. I am trying to

TAG : tsql

I hope this helps you . Once when @wDate reach @fcStart looks like you never reset @wDate to initial state So next loop run againYou need some how to reset @wDate for next loop

TAG : tsql

help you fix your problem James,You may find it helpful to build a CTE table with one row for all of the possible dates between a range (i.e. MIN and MAX dates from your fact table), and then LEFT JOIN to it to find missing dates. You may also want t

TAG : tsql

like below fixes the issue There are many possible solutions, but I would personally use a CTE. For the CTE to work, you'll need to include a ; at the beginning to close any previous statements. I assumed a full outer join just in case any EntrantID

TAG : tsql

I wish this help you Times ago I needed to create clusters of data using transitive closure. The best way to do that was using SQLCLR. Here's the GitHub code (article to detailed link is there too)https://github.com/yorek/non-scalar-uda-transitive-cl

TAG : tsql

this will help A common table expression can only be used within the scope of a single statement:

TAG : tsql

This might help you Your where clause is effectively changing your left join to an inner join. That is because a left join returns nulls for rows that can't be found on the right table, and null compared to anything will always return unknown which i

TAG : tsql

I wish this helpful for you I have a table Tabel1 with columns id, data1, value1A, value1B, date2, value2A, value2B. , You can accomplish this by using cross apply:

TAG : tsql

hop of those help? I have a time field which is storing numbers in '49235062'. Can these be converted to an actual readable time? , Just a guess, but is this milliseconds from midnight? Example

TAG : tsql

it should still fix some issue Here is a working sample of the PIVOT optionExample (or dbFiddle)

TAG : tsql

hop of those help? I'm not sure I'd bother with all of the overhead that comes with a MERGE statement. See Use Caution with SQL Server's MERGE Statement.You can get everything you need with an explicit transaction.

TAG : tsql

around this issue I have a table with a table_id row and 2 other rows. I want type of numbering with row_number function and I want result to seem like this: , Using LAG and a windowed COUNT appears to get you what you are after:

TAG : tsql

wish of those help You need to utilise a standard date-time format, for it to work. For example, see following query:

TAG : tsql

this will help Not a bug, it's how LEN works. LEN:

TAG : tsql

With these it helps I am trying to combine the SQL queries and getting the below error. , SET the variable value :

TAG : tsql

this one helps. SQL Server 2005 is long out of support, why are you still using it? If you really are still using SQL Server 2005 it's long past time you upgrade and you really need to look at upgrade paths asap. No supported versions of SQL Server s

TAG : tsql

I wish this helpful for you How can I get the output of the below query in a variable without temp table? , Assuming that you get a singleton value from your dynamic statement:

TAG : tsql

I wish this help you After fixing your SQL to not be a huge injection issue, by properly quoting your objects, you need to separate the statements into 2 commands. Then you can CREATE your database in one command, and then INSERT in another.

TAG : tsql