Topics
Started by
Posts
Last post
Hi there, I've been trying to solve this issue for a while. I have been asked create a job that run…
13 replies
Here is my tables and indexes structure : CREATE TABLE [dbo].[Clients]( [ClientId] [int] IDENTITY…
9 replies
Hi I'm trying to write a query that combines two rows into one with specific columns. I'm using SQL…
11 replies
In SSMS I want to get the OutPut or Result to be displayed in to Text Mode instead of Grid whe…
4 replies
Hello All, Is there a Stored Proc or a function using which I can recognize the process that fired …
3 replies
creaate table #temp1(account, MTD float, ytd float) insert into #temp1 select account ,mtd,ytd from…
40 replies
I have a table called Transactions, which has 4 fields (for the sake of this example): [TimePunchI…
11 replies
Hi, I have a table named ABC. It has a field named Y and Z. Y='ABCDEFG (9105) CDD ABCDEFG (1690)…
9 replies
Hi, i have a data like below Personid AccountNo ProductCode Date1 1 111 80 …
3 replies
Hi, Please use the following sql to create a sample of test data to play around with. USE [master]…
13 replies
We recently decided to partition a table in one database that is referenced in another. The current…
9 replies
Hello Everyone OK, I am going to do my best to explain this and not leave anything out. In the tabl…
5 replies
I have a working pivot statement, which pivots againts one column. I'm trying to create some ddl t…
10 replies
hello everyone. i got a scenario like this i got 5 parent tables and 30 child tables in the source …
19 replies
I'm in the process of upgrading a sql 2000 environment to 2008 R2. I now have 2 servers, 1 with ea…
5 replies
Viewing 15 topics - 6,121 through 6,135 (of 10,635 total)
You must be logged in to create new topics.