Topics
Started by
Posts
Last post
Hi all, I have this table: CREATE TABLE [dbo].[Merchant]( [MerchantID] [int] IDENTITY(1,1) NOT NU…
2 replies
Hello, I am in the process of designing an audit process for a new application. For example we wou…
12 replies
Hi all, OK I've been using this code for sometime in different places for concatenation columns tog…
4 replies
gURU'S, Can someone please tell me how to defrag or rebuild the indexes by filegroup. I have about …
11 replies
Now i have this query TRANSFORM Sum(tbl1.col1) AS SumOfcol1 SELECT tbl1.col2, tbl1.col3 FROM tbl1 W…
2 replies
Hello folks, i would like to export data from a server with sql server 2005 to other one with sql …
2 replies
I have the following data. Number NameJanFebMarchApril 1kk12131415 2ll22232425 3mm3…
2 replies
how to display date in yyyyMMddhhmmss format
5 replies
Hello ALL, Say I have written codes that create the column header field name such as BOMCleared, CT…
1 replies
Hi, My requirement is that if there is no record in Log Table for the Batch Table Join Condition Lo…
1 replies
The WHERE Clause in my query below needs to do 2 things. 1) WHERE TodaysDate(Which is GETDATE()) &g…
3 replies
I have a table, with nvarchar(50) of 40 million records, this field has an unique index on it The t…
2 replies
Hi there, I'm new to Transact SQL and working with a legacy system where the key to a table is a bi…
7 replies
If any new inserts, then I need to insert the data into table1 and if any existing data is getting …
13 replies
I am having to deal with a lot of external data for which NO front end editing can be accomplished.…
23 replies
Viewing 15 topics - 7,096 through 7,110 (of 12,230 total)
You must be logged in to create new topics.