Topics
Started by
Posts
Last post
I have two tables like this having the structure below: Create table #activities (activityCode nva…
4 replies
I have a an optional parameter stored procedure that is currently being used on an employee search …
3 replies
Table Structure CREATE TABLE [dbo].[Stock]( [clientcode] [varchar](10) NULL, [productid] [varchar…
14 replies
Like many, I inherited this and cannot change it, but I have run into an issue involving a DML trig…
1 replies
Hi, I have an SQL query which is looking at the hours booked against jobs and operations between 2 …
2 replies
Hi, I'm trying to calculate the property vacancy rate per month which is no of days a property is v…
18 replies
Hello All...need your help , I have 2 db's(@DName1 and @DName2). Need to change the logical names o…
2 replies
I am trying to return several columns from the sys.database_files view and want to calculate the gr…
2 replies
When I run this view query: // SELECT [student#] ,[class_position] ,case when [class_p…
5 replies
Hi There, I require to convert single xml into multiple rows, as explained below Thanks in advance
6 replies
Hello Everyone, I have two columns, DateTime and Hours in (HH:MM) as shown below. I'm trying to add…
7 replies
Hello, I am writing a SP in which I need to take a bigint value and always round it up to the next …
5 replies
what Workday number is today in the month today is may 9th but the workday number is 6 I need away …
6 replies
Hi, I have the big query below and want the plant_month column to show only end of the month date. …
2 replies
Hi. I saw a strange looking query today when my colleague used a wrong alias in a where clause. I w…
1 replies
Viewing 15 topics - 691 through 705 (of 10,647 total)
You must be logged in to create new topics.