Topics
Started by
Posts
Last post
Hi... how can I get uniqueidentifier value as return after insert a record.
9 replies
I have bunch of views (some of them pretty complex with many inner and outer joins) that basically …
14 replies
Hi all, I often have situations where I have a table which stores, in two separate columns, a value…
17 replies
Hello expertsI need some help regarding SQL query, I have a table to save invoices and receipt…
8 replies
Hello comunity I have a field Char(10) named bank, and another one Char(15) named namebank. I need …
10 replies
I have a situation where I need to get changes in statuses for the current month and the previous m…
4 replies
Does anyone have an idea how to tweak the TSQL above to exclude assigning a row_number to rows for …
33 replies
Hi Experts, I have a doubt reg. the creation of a clustered PK for one of our DWH tables. Backgroun…
8 replies
Hi, Below the test daaDeclare @Score table(IdScore int, score int, Name varchar(100)) insert into @…
5 replies
Hi, Is it possible to use (dynamic) LIKE in a SELECT/GROUP BY rather than WHERE. Take this sample: …
3 replies
Hi I have one doubt in sql server . how to get first position to right side specific characte…
6 replies
Hi, below the sample structure, Declare @sample table(id int, name varchar, datetime); select …
6 replies
I've created a stored procedure that accepts two arguments: the name of an Excel workbook (@workboo…
15 replies
IF OBJECT_ID('dbo.Ship326587') IS NOT NULL DROP TABLE [dbo].[Ship326587]CREATE TABLE [dbo].[Ship326…
2 replies
Hi Experts, ALTER PROCEDURE PROC_JOB_BACKUP_OTHER_TABLES_ARCHIVED_00 @PARAME…
1 replies
Viewing 15 topics - 166 through 180 (of 10,647 total)
You must be logged in to create new topics.