Topics
Started by
Posts
Last post
I'm not even sure how to really title this question, but here goes... I have two table that have th…
3 replies
Hi I am pretty new to SQL and have a question maybe someone can help me with. We have a database …
2 replies
/*** Create Variable Table @TableName***/DECLARE @TableName TABLE ( Component Char(…
1 replies
Update myTable Set strwhere = 'C.IT_Code IN ('A','E','C','P','R','O') AND SP.Status='S' and SP.Pay…
5 replies
Ok, I've been looking at this for ages and just cannot get what I want to work! Here's my table: CR…
4 replies
Hello ALL, I have created a query in store procedure and wish to capture a case if that case falls …
2 replies
Hi All, I am getting the below error frequently while connecting to SQL Server. Database access er…
5 replies
My requirement is if the startdate and enddate parameters are null, then the dates should default t…
2 replies
Hello: I'm familiar with the TOP command and that works fine to limit my record count, using a fixe…
10 replies
Table 1 GroupName GroupID GroupDesc Group1 1Item1 Group1 2Item2 Group1 3…
6 replies
Hi all I've got this scenari table1 id Name 10 John 11 Alice 12 Peter table2 id Name 4 John 5 …
13 replies
I have the following sample data: Ord_refil1 ord_refil2 ord_refil3 online_ord1 online_ord2 online_…
4 replies
I am using Full text search for searching Synonyms words. But from the MSDN, i came to know it will…
3 replies
I have a table that has xml data: datatype = ntext Actual data is in XML format. The query built ar…
11 replies
Hi guys I have to do a report on the patient's data which is in two different tables. Here are the…
5 replies
Viewing 15 topics - 6,991 through 7,005 (of 12,230 total)
You must be logged in to create new topics.