Topics
Started by
Posts
Last post
Hi there, I know this is old ground but I seem to be struggling with this. I'm trying to find a way…
1 replies
Hi all, Due to the complexities of the data I have framed this question as 'theoretical', hence no …
22 replies
Guys Recently I have come across a deadlock scenario on OLTP box (Sql server 2005) of a client and …
2 replies
I have two tables CREATE Table A( AID int not null primary key Identity, EmployeeID int not null,…
7 replies
UPDATE DWH_THE_ALLIANCE t1 INNER JOIN DWH_TDI_SOLUTIONTYPE tsol ON t1.SOLUTIONTYPE_LLAV_PR = tsol.S…
2 replies
Hello, I need to export data from SQL 2005 to an Excel 2007 .xlsx formatted file. I know I can use…
12 replies
in simple rollback tran trigger , it is giving this error Msg 3609, Level 16, State 1, Line 1 The t…
4 replies
I have had success in avoiding the explicit creation of temp tables to store intermediate results b…
1 replies
All, I have one scenario. create table #temp ( dt datetime ) insert into #temp select 'Dec 3 2010 …
1 replies
Hi there all, I have a table stucture as: location, month, metric1, metric2,..metric100 I want to u…
4 replies
Hi, Can you please guide, how to avoid dynamic query for the following query. can you re-write th…
6 replies
I am trying to pull the correct date from a set of records. Using this code to set up the scenario:…
9 replies
hi, can we edit the expression for drillthru in ssrs, i want the drillthru on a different for the 1…
1 replies
I am creating stored procedure with this code:-- SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO c…
15 replies
Been searching but cant find a problem like mine, maby Iäm bad at searching. Here is the problem: M…
16 replies
Viewing 15 topics - 2,236 through 2,250 (of 12,234 total)
You must be logged in to create new topics.