Topics
Started by
Posts
Last post
Table Data --------------------------- ID Dept-ID Version 10 30 0 20 30 0 20 30 …
4 replies
I have the following SP that runs daily. ALTER PROCEDURE [dbo].[usp_token_disable] AS BEGIN set noc…
2 replies
Hi, I need to identify what logins exist and what access they have to each database on the server. …
4 replies
Hi folks, I need to add code to an existing dos batch file that will return one single row of data…
5 replies
An existing trigger prevents bulk data insert into a database. In a stored procedure that pushes da…
9 replies
This is my main (and simplified) table: if object_id('tempdb.dbo.#Scan') is not null drop table #sc…
7 replies
Hello, I have a problem designing a table from a matrix in excel. Is it even possible in SQL Server…
5 replies
I have a column value like this 'Merged Facility Id:0286- Patient Id:999000 PHPatId:28488 with Faci…
6 replies
I have written a stored procedure where I am using a TRY .. CATCH block, but that CATCH wasn't bein…
8 replies
Hi All, I have a table with below data create table t1 ( name varchar(50) ) insert into t1 select '…
10 replies
I'm trying to insert records to a table with identity column. I first set it to on and try to inser…
7 replies
Given a table like this declare @Tab1 table ( id int identity(1,1), v1 int, v2 int, v3 int, v4 int,…
25 replies
Hi all, I used sqlcmd -U dbName -P password -S hostName -y 0 -u -d dbSchema -i C:\MyLargeScriptFile…
2 replies
I'm working with healthcare data, specifically with drug data. I've been supplied a reference table…
21 replies
I am struggling with an overview of jobhistory. I am so far as to convert job_runtime and job_runda…
2 replies
Viewing 15 topics - 1,606 through 1,620 (of 12,230 total)
You must be logged in to create new topics.