Topics
Started by
Posts
Last post
I have two queries Query 1 : Retrieves last two end of month date from Date Dimension output as Act…
7 replies
I have an insert with an output clause where one of the outputted columns is not in the inserted li…
6 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…
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, …
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 [Cour…
4 replies
INSERT INTO OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0′,’Data Source=D:\Book1.xls;E…
1 replies
Hi all, I’ve been looking into this query and trying to see if there is any better way to wri…
11 replies
Viewing 15 topics - 1 through 15 (of 15 total)
You must be logged in to create new topics.