Topics
Started by
Posts
Last post
I have been asked to create a script to manipulate the database and set any nullable columns to nul…
9 replies
The below script returns this data set. RowOrgID StartDateEndDate 11219042/4/20086/1/2…
8 replies
accountno transaction amount date ========================================== A-123 …
22 replies
Hi Everyone, I have users profiles in a table in my database but some of them have wrong data. i.e,…
8 replies
I'm looking for a script that List all Foreign Keys for a Table. I had a few but I can't locate the…
10 replies
Hi, Can some one tel me how can I display current week number in SQL? I need to use this function i…
12 replies
Hello, I compressed a table XYZ in Sql Server 2008. Now i need to insert some thousands of rows fro…
4 replies
I have a table with two columns created date and mofified date. I have a condition like 1. When the…
6 replies
I have a process where I have to copy rows from two tables and update a few columns, one of which i…
5 replies
I'm using one query window and trying to tune the Query, if i runs twice or thrice it's taking Old …
4 replies
Hi, I have data in a table wid 3 columns. Invoice_no, item, price.... example:- Invoice_no item …
4 replies
I have a sproc that performs a multi-table insert. Some of which is done via dynamic SQL. When my…
4 replies
Hi I was wondering if someone could help me. I have a huge table that stores product delivery route…
7 replies
I execute this statement on my PC and it works: CREATE NONCLUSTERED INDEX IX_WorkOrder_ProductID …
12 replies
Hi guys, How to identify the last inserted values in "select Query" Example Query : select * from i…
9 replies
Viewing 15 topics - 5,506 through 5,520 (of 10,647 total)
You must be logged in to create new topics.