Topics
Started by
Posts
Last post
Hi, I have used uniqueidentifiers as primary keys but can't seem to reference them as foreign keys …
1 replies
Hi all, We are facing problem to delete the log file, those created using other packages. The pro…
1 replies
I have 4 item classes. Class A = 80% of receipts, Class B=15%, Class C=4% and Class D= 1%. So I h…
4 replies
Is there MS SQL analog of group_concat? SELECT ClassID, group_concat(StudentID, '|') FROM class…
3 replies
HI ALL, I CREATED A TABLE AND APPLIED CHECK CONSTRAINT USING IN AND LATER I AM ENTERING DATA WHY CH…
1 replies
When I do a Contains(table, column, "on") it won't find any instance of the word "on." It works fi…
2 replies
Hello, I am trying to covert data and I have an address field that has addresses with city, state, …
3 replies
When trying to run this query to OpenLDAP 2.3.27 (RedHat flavor): SELECT convert(varchar(5), [given…
1 replies
Hi...I would appreciate some guidance on the following please: SQL 2005 STD SP3 linked server via O…
1 replies
Hi, I have a query that returns Purchase Orders Line Items that have a 'Due Date' +6 days from curr…
5 replies
Sometimes I encounter multiple duplicates in a recordset. I either want to delete the second or thi…
6 replies
Hi, I need to select the above rows in ascending order but want the row having t='O' as last row. (…
10 replies
I need to input data into a column in a table using a reference table. Below is code displaying the…
2 replies
Hi All, Can guyz tell me, why DISTINCT is not working in this context. How can it will be possible …
4 replies
Hmm ok so maybe the title is a little obscure but I'll try to explain what I want to do. I have 2 t…
6 replies
Viewing 15 topics - 6,196 through 6,210 (of 12,234 total)
You must be logged in to create new topics.