Topics
Started by
Posts
Last post
Hi all, I designed a report layout in server and my system, the rdl in server is the old one, and t…
1 replies
Hello, I want to count rows with same id but I am not really shure about the syntax. table x rowid …
2 replies
Hi All, I want to know , as to how we can find the order of dependency in SQL Server 2005 for the o…
1 replies
error: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. the above err…
1 replies
Hi, I have what should be a simple update that I stopped after 7 minutes. declare @cid int set…
2 replies
Hi, I need to write a query to update an image field with documents provided. I wrote the followi…
1 replies
I need to change the values in a field, leaving the last 4 characters only. Would like to change t…
5 replies
I made an index on a table named stock_items that has a field named batch_file_id , this is the new…
9 replies
I have to write a function to return a due date. The way the system works is if I have a due time …
13 replies
Hello all, I have been in the process of transferring a database from Access 2007 to SQL Server 20…
26 replies
Hi All, What is wrong with this statement. Even when CHARINDEX is zero it goes thru the 2nd cas…
25 replies
Hi, Please can you help with the following statement.I am trying to create a column called Harvest …
5 replies
Table1 - personID, firstName, lastName Table2 - personID, badgeID, validFrom, validUntil I would ne…
7 replies
I do bulk insert from CURRENCY.TXT It's a TAB delimited file with CR+LF row delimiter -------------…
5 replies
This is a simple stored proc. CREATE PROCEDURE [dbo].[usp_rpt_report1] (@col1 varchar(8)) AS SELE…
2 replies
Viewing 15 topics - 7,156 through 7,170 (of 12,230 total)
You must be logged in to create new topics.