Topics
Started by
Posts
Last post
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
Hi all I have two stored procedures which return dynamic columns as result sets. is there any way …
2 replies
I fire a trigger on tblAdmin as CREATE TRIGGER [dbo].[trg_mailupdation] ON [dbo].[tblAdmin] …
1 replies
Hi, The below table is my source SkillBU1BU2BU3 Skill1000 Skill2260 Skill3007 Skill44…
8 replies
Hi, I'm using DBCC Page to investigate data on specific pages. My question is: Does DBCC Page show …
2 replies
Hi, I have a table with exchange rates between 2 countries. There's 90 days of history for every e…
7 replies
Viewing 15 topics - 4,546 through 4,560 (of 10,636 total)
You must be logged in to create new topics.