Topics
Started by
Posts
Last post
Ho do I step through or debug my T-SQL code. I'm trying to use a cursor to compare 5 fields from o…
6 replies
I have this table of dates: mark_per start_date end_date -------- ---------- ---------- M1 0…
14 replies
Hi, Can anybody suggest me "How to get last 10 characters in all rows of a single(same) column?". T…
6 replies
Not too sure, If this forum fits here but here it goes. I send out the following email everyday.Wha…
4 replies
I'm looking for a way to identify all round currency amounts in a given fileld. So if I have a tab…
10 replies
I've found several examples of how to use the CASE statement to do this but for some reason I canno…
7 replies
Hi there, I am trying to get data in the format of table ##Temp1 into the format of table ##Temp2 …
12 replies
Hi. I have id , vlaue pairs data in rows...what i need is to transpose them into columns without us…
6 replies
CREATE TABLE mytbl2 ( c1 sysname ); GO INSERT mytbl2 VALUES ('Discount is 10-15% off'); INSERT myt…
18 replies
Hey guys, feel like this one should be obvious to me but it's just not working. I'm trying to get t…
22 replies
Hi, i have a query using FOR XML AUTO that i need to retrieve in only one big text field (one row, …
3 replies
After Restoring DB i'm not able to drop a user in the database, i checked if the user owns any obje…
1 replies
Hi, I'm trying to build an sp that will return a list of companies where the company first lett…
11 replies
Hi, Hi, I have a Microsoft access table that looks like this: Field1|Field2|Field3 1|0|1 1|10|…
3 replies
Hi, I am beginner.Just an example. If I have table with 3 rows and 3 columns: customer number n…
10 replies
Viewing 15 topics - 4,021 through 4,035 (of 12,234 total)
You must be logged in to create new topics.