I am using SqlDataAdapter.Update to update data within datagridview or insert new record now when...
I just wanted to see if there was any better way to do an query like this, I think that the cast in...
I have a query which looks like this: SELECT a.Name as 'Name of the program', a.ContractCode as...
I have a task to upload the excel file and also check update if the same record found, I have...
I saw WITH tblTemp as ( SELECT ROW_NUMBER() Over(PARTITION BY Name,Department ORDER BY Name)...
While searching for a method to create date ranges I came across a problem with the following...
There is a temp table with such rows:...
I have downloaded a shapefile from Ordinance Survey website, and imported it into SQL using...
Here is the scenario: TableA - schema does not really matter TableB - same schema as TableA ...
Hi I have data stored in table(cmsContentXml) in Column Name as xml <Ingredients id="1515"...
I have in the table policies, where BK for them is VIN + ProgramCode + ValidFrom Structure of...
I have table like below. Workid StartDate EndDate 101 2012-03-01 2013-03-20 101 ...
I inserted username and password values into a table in SQL server. below is the code for my...
I have login process for my application that should run three different transactions if user...
I have a case where I have NO control whatsoever on the SQL Server configuration. Here's my...
I have rows: PLACE DATE_OPEN SUM ----------------------- PLACE1 03.09.2018 2 PLACE2 ...
So the wonderful people here on stackoverflow helped me with a "find consecutive failures" type...
have have Visual Studio 2017 Professional. During my sql server Management Studio 2008 Installer I...
On Server1, i want to schedule a job (JobTest). I want to schedule this once another job(JobLive)...
A table has a time column in float datatype is given as: 40m 11m 2m 0m 3m 1m 1m How can I sum...
SQL server 2008 Query for converting below Existing table to Expected output Existing Table Name ...
I want to select the unmatched combination from the same table: Table 1 So as per the above...
Table: emergency_tab (user_id, emergency_no) and Constraints (user_id [primary...
I have the following data and I want to subtract current row from previous row based on the UserID....
We have a bunch of queries that we run every month end. These queries store data from our...
I have one doubt in sql server Basically I need to run this on a table with 60 million rows,...
In my case I'm looking to make a simple asset register. All items will have some kind of...
Any idea how to create T-SQL to display the content of DAT files stored in the table as...
I am working on a project where I have to upload the excel file in the SQL server database, and...
I'd like to create an INSERT trigger for SQL Server 2008 with a condition. For example I've a...