Topics
Started by
Posts
Last post
Hi, I have a table with syn_trans with below cols: ( Id integer(10), Name varchar2(100), seq_no in…
3 replies
I have following xml: <root> <row value="US"> <col value="00">Jon</col&…
2 replies
can anyone tell me the basic T-SQL for looking up a user and their password in a loging I'm creatin…
5 replies
SELECT Persons.P_id ,Persons.LastName ,Persons.FirstName ,Persons.Address ,Persons.City F…
6 replies
Hi All, I have 58 sequentially run jobs as part of our Database ETL. So, I took the start time …
3 replies
I create a table as CREATE TABLE DEMO (A INT) Then i deleted it as follow DELETE DEMO I tried to ag…
3 replies
Hi All, I need your help. Database: SQL SERVER 2008R2 I want to calculte for a year and a week the …
12 replies
Hello all, I am trying to select row from a table where the column contains values from a list. I t…
3 replies
Hi All Some DDL --Table 1 CREATE TABLE [dbo].[Indexing2]( [Col1] [int] IDENTITY(1,1) NOT NULL, […
8 replies
A Report writer sent this query to me asking to either make it a view that they could JOIN to or cr…
11 replies
Hi all, When i write the comments above this statement they are not reflected, but when i write the…
10 replies
Hi, Since i am newbie to SQL Server, i am finding some new things. 1. I have a table in dbo schema …
11 replies
USE Master; GO --- Step 1 : Create New Test Database with two different filegroups. IF EXISTS (SELE…
7 replies
I have two tables, a table of actions and a table of items. They look like this: ActionID Employe…
7 replies
I'm trying to get the count of only the Active Consumers for each ConsumerType, based on the Acti…
6 replies
Viewing 15 topics - 4,546 through 4,560 (of 10,647 total)
You must be logged in to create new topics.