Topics
Started by
Posts
Last post
How do I take this and figure out what the job was? (from the deadlocked report in SQL Sentry) SQLA…
2 replies
In the T-SQL below, I retrieved data from two queries and I've tried to join them to create a repor…
9 replies
I need to add a filter clause like WHERE username = '%%%' It needs NOT to filter anything out. I …
6 replies
In SSMS, I used the ALTER TABLE statement to add a field to a table. No errors are generated and I…
10 replies
Hi all, I've a table with two columns: ColumnA ColumnB 1 88 2 99 3 …
3 replies
I need to extract specific text elements from a varchar column. There are three keywords in any gi…
1 replies
i have requirement this CREATE TABLE [dbo].[TEST_REP_MGR_NAME]( [ACCT_ID] [decimal](15, 0) NULL, …
2 replies
Hi Friends, I m already created a table and i wanna to insert values in that more than five…
4 replies
USE [cashNotification] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[S…
12 replies
Hi all, Is there an Admin script that yields the following directories? Data Data Root Log TempDB S…
4 replies
Hi, I have an issue within a stored procedure. I have a temporary table (@tblResults) that has 4 co…
3 replies
I have 57 tables,7 views and 1 stored procedure. Just wanted know based on these requirements how …
2 replies
I have one drop and create procedure script in one sql session and execute the procedure in other s…
12 replies
I want YYYYMMDD. If I do this it works: SELECT CONVERT(varchar(8), GETDATE(), 112) Gives me this:…
4 replies
Hi all, Got a bit of a challenge in working with a SAGE ERP system (MAS500). I need to navigate a…
1 replies
Viewing 15 topics - 1,591 through 1,605 (of 10,647 total)
You must be logged in to create new topics.