Topics
Started by
Posts
Last post
I have an insert with an output clause where one of the outputted columns is not in the inserted li…
7 replies
Hello All, Please advise on the below. I am new to deployments and learning so feel free to share a…
0 replies
I have two queries Query 1 : Retrieves last two end of month date from Date Dimension output as Act…
7 replies
Hi guys, I am stuck with a task with not getting there? I want to calculate income tax based on a …
1 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
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
I've searched the web to no avail. So PLEASE help out!I have a table:CREATE TABLE [Course].[N…
4 replies
INSERT INTO OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0','Data Source=D:\Book1.xls;Extended Properties…
1 replies
Viewing 15 topics - 1 through 15 (of 16 total)
You must be logged in to create new topics.