Topics
Started by
Posts
Last post
Why can I not create a new column and add 90 days to the date in column P_INDATE in MS SQL Server? …
4 replies
I will force the cursor to execute the procedure first then execute execute the others my script i…
6 replies
Hi, we have merger sp with table-type now we have to call one sql function to populate one column v…
1 replies
In a WHERE clause. SELECT SCHEMA_NAME([o].[schema_id]) , [o].[name] FROM [sys].[objects] [o] WHERE …
7 replies
Hi guys, I am stuck with a task with not getting there? I want to calculate income tax based on a …
2 replies
I have an insert with an output clause where one of the outputted columns is not in the inserted li…
8 replies
Hello All, Please advise on the below. I am new to deployments and learning so feel free to share a…
1 replies
I have two queries Query 1 : Retrieves last two end of month date from Date Dimension output as Act…
7 replies
I am running the query below but I am getting an error "Conversion failed when converting the varch…
2 replies
Basically I am trying to use a select for 1 column and another select for all others. I want the CO…
4 replies
I am trying to modify my query so that it will only look at the data between 6am and 6pm instead of…
9 replies
I am trying to create a query that will create a percentage based on 2 know column values I want to…
4 replies
Just wondered how much anyone has played with the new Graph Tables (Graph processing with SQL Serve…
5 replies
By: Jo Pattyn
I need a query to hide the time from a datetime field if the time is midnight. I tried a case state…
6 replies
By: gtjr92
Hi, I made a change to a query to return data quicker. I used the EXCEPT operator to make sur…
4 replies
Viewing 15 topics - 1,771 through 1,785 (of 1,790 total)
You must be logged in to create new topics.