The simplest solution, since you already have working C# code, is to create a Console Application, and use your existing code in the Main() method. Compile it into an EXE, and place the EXE somewhere on the computer where the code must run. Use Windows Task Scheduler to schedule your EXE to run as needed. … Read more
From a 10,000 ft view: a string comparison is being done between each Reach Report values, and the results of each comparison are used to order the 4 rows (ORDER BY [Reach Report] DESC). REACH 2012-13 REACH 2011-12 REACH 2010-11 REACH 2009-10 Then, the first one is chosen and returned (SELECT TOP 1 [Reach Report]). … Read more
You should either use this method: SqlCommand cmd = new SqlCommand(“dbo.workScheduleDataGrid”, sqlcon); or this method SqlCommand cmd = sqlcon.CreateCommand(); to create the command, but not both (the second assignment in your code overwrites the first one). With the second options, you need to specify the command to execute separarely: cmd.CommandText = “dbo.workScheduleDataGrid”; Also, do not … Read more
all what i had to do is add this: ‘ into ##myTempTable DECLARE @DynamicPivotQuery AS NVARCHAR(MAX) DECLARE @ColumnName AS NVARCHAR(MAX) –Get distinct values of the PIVOT Column SELECT @ColumnName = ISNULL(@ColumnName + ‘,’,”) + QUOTENAME([month]) FROM (SELECT DISTINCT [Month] FROM MyTable) AS [Month] order by [month] –Prepare the PIVOT query using the dynamic SET @DynamicPivotQuery … Read more
I didn’t test it, but it should look something like that : var query = (from s in Suppliers select new { SupplierId = s.SupplierId, CompanyName = s.CompanyName, ContactPerson = s.ContactPerson, Address = s.Address, Email = s.Email, InActive = s.InActive, BranchId = s.BranchId, CreateDate = s.CreateDate, CreatedBy = s.CreatedBy, UpdateDate = s.UpdateDate, UpdateBy = s.UpdatedBy, … Read more
Try this UPDATE TPatientRaw SET tPatSSlidaID = RIGHT(‘0000000000’ + CAST(CAST(tPatSSlida AS int) + 10000 AS VARCHAR), 10) WHERE tPatSName=”CLINIC DENT” simple test 4 solved SQL Change Value + 10000
You will need an API (REST, etc.) running on a web server, with that web server having access to the firewalled-off database server. And authentication for your API so that you don’t have random people DDoSing your service and database. Your database server should not be exposed to the internet at all, nor directly accessible … Read more
declare @t1 table ( col_a varchar(5) null ,col_b varchar(5) null ,col_c varchar(5) null ,col_d varchar(5) null ) declare @t2 table ( col_a varchar(5) null ,col_b varchar(5) null ,col_e varchar(5) null ) insert into @t1 values (‘Cat 1′,’Bla a’,’C-1′,’D-1′) ,(‘Cat 1′,’Bla a’,’C-2′,’D-2′) ,(‘Cat 1′,’Bla a’,’C-3′,’D-3′) ,(‘Cat 2′,’Bla b’,’C-4′,’D-4′) ,(‘Cat 2′,’Bla b’,’C-5′,’D-5′) insert into @t2 values (‘Cat … Read more
Assuming that there aren’t any partitioned table: USE [SpecificDatabank] SELECT sys.columns.name AS ColumnName, sys.tables.name AS TableName, sys.partitions.rows AS [Rows] FROM sys.columns JOIN sys.tables ON sys.columns.object_id = sys.tables.object_id JOIN sys.partitions ON sys.tables.object_id = sys.partitions.object_id and sys.partitions.index_id in (0,1) WHERE sys.columns.name LIKE ‘%ColumnName%’ 1 solved Find number of rows of each column name [duplicate]
with cte as ( select * — get min & max per date ,min(time) over (partition by cast(time as date)) as mintime ,max(time) over (partition by cast(time as date)) as maxtime from tab ) select * from cte where time in (mintime,maxtime) 1 solved how can i show the last event of each date in … Read more
I’ll take a stab at your problem. This is only a guess, based on the query you provided. A complete question would have described what exactly you mean by a duplicate row. delete from Registrations where exists ( select 1 from Registrations r2 where r2.UserItemId = Registrations.UserItemId and r2.CourseOfferingId = Registrations.CourseOfferingId and r2.Id < Registrations.Id … Read more
Your current syntax problem is with the @count = @count + 1; which needs to be set @count = @count + 1. But… There is no need for a loop. You can simply do one big insert directly, like: insert into your_table (fk_col, other_col1, other_col2) select pk_col, ‘something’, ‘something else’ from your_other_table If you need … Read more
sp_MSforeachtable @command1=”ALTER TABLE ? ADD id int IDENTITY PRIMARY KEY CLUSTERED” The good thing is that it if it fails for some table, it doesn’t fail for all. solved How to add a primary key to all tables in SQL Server?
Try this select id,[date],(case when refund = 1 then ‘R’ when voidstatus = 0 then ‘C’ when voidstatus = 1 then ‘V’ else ” end ) as [status],grossamt from trans 2 solved SQL Statement two columns value return single value [closed]
It is possible for you to be database owner and still have your account’s security settings screwed up. To fix this, delete the user (not the login), then recreate it. solved SqlDependency isn’t firing