Topics
Started by
Posts
Last post
Hi, I need to take the characters from the left before the '/' string and insert into a column and…
6 replies
create table #tmpTest ( ClientKey int, GuarantorKey int ) insert #tmpTest select 10,0 create table …
11 replies
I have an object table: I have another table 'ObjectValue' Output: I'm trying to create a new tab…
3 replies
here is my line of sql (Vehicle.value + Vehicle.Extras_Value + Vehicle.Expenses + Vehicle.Another_T…
4 replies
As the title says select id , count(distinct company) as CompanyCount , count(distinct district…
4 replies
hi friends i ve created on table create table rab(deptno number(33), job varchar(22)); insert in…
6 replies
I am trying to write a script to read the current row and previous row per device and work out the …
18 replies
Hi, I have 2 table as A(totalmarks, maths, english, class1) and there is another table B(class2) No…
2 replies
Hi, I have a scenario where I have a version table that holds multiple versions. One or more versio…
8 replies
Can someone assist me on the t-sql. This is my current data: ID role unit nam…
1 replies
Hi friends, I have a situation where i need tocreate table and insert records into…
4 replies
I am trying to optimise a script for performing DELETES in a DW staging table. DELETES are not logg…
4 replies
I am executing the SQL Statements on SQL Server 2008 (SSMS). What am I missing? (I'm sure it's me, …
9 replies
Hi I have a location table SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO…
12 replies
Hi all, I have come across various section on this website where it is mention that SQL Server is a…
34 replies
Viewing 15 topics - 5,341 through 5,355 (of 10,647 total)
You must be logged in to create new topics.