Topics
Started by
Posts
Last post
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
I need a query to hide the time from a datetime field if the time is midnight. I tried a case state…
6 replies
Hi, I made a change to a query to return data quicker. I used the EXCEPT operator to make sur…
4 replies
I'm using this trigger to update specific columns.I want to get old values for some columns, but th…
4 replies
I have wished for SQL Server BEFORE TRIGGERs for a long time. I have posted to Microsoft Connect (…
16 replies
Viewing 15 topics - 1,696 through 1,710 (of 1,713 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy