Topics
Started by
Posts
Last post
I have 2 tables with below table structures Create table Client (ClientID Int, clientName Nvarchar…
3 replies
one of the way to delete duplicate record is on sql authority website. I've used it many times but …
15 replies
alter table statement. i want to change the collation for all the columns in a table. i already hav…
8 replies
Hi I'm using SQLS 2008. I want to select all the staff who were employed by a company at a mid y…
2 replies
I'm very familiar with Oracle and I'm trying to find the comparable code in SqlServer world. Basica…
2 replies
Please forgive me if this topic has been beaten to death. I am by no means an expert and I have a…
13 replies
Hello all, I got a problem which is to insert rows for everyday's condition(whole year)and derive a…
8 replies
I have a an execution plan that insists on a Clustered Index Scan, and I would like to understand w…
28 replies
Hey, as some of you guys know im building a mailing system, and yesterday i learned about the wonde…
4 replies
Dear Team, I use to pick the data from one of my database (ex:ProductionDB) in CSV format. This d…
1 replies
Hi, I have data which looks as below: Yr Month Member Code Desc 2011 01 …
9 replies
I have code to create cummulative percents. Unfortunately, it is running extrememly slowly. Here is…
8 replies
I've been working through Jeff Moden's great article: http://www.sqlservercentral.com/articles/T-SQ…
12 replies
Hi Guys, I’m somewhat a novice on this issue, basically we would like to select specific records fr…
5 replies
DECLARE @V1 NVARCHAR(MAX),@V2 NVARCHAR(MAX) SET @V2 = N'test' --Method 1 SET @V1 = @V2 + REPLICATE(…
3 replies
Viewing 15 topics - 7,066 through 7,080 (of 10,635 total)
You must be logged in to create new topics.