Topics
Started by
Posts
Last post
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
Good day Forumites, I have a full text search set up on the "Goods" table with some columns below, …
6 replies
Hi, I've got a number of tables with no clustered index I want to archive on a regular basis (weekl…
2 replies
Please advise what's the meaning/significance of the -53960 in the following datadiff function call…
2 replies
Being an adhoc coder I am trying to write a AP and getting the following error Msg 137, Level 15, …
2 replies
Viewing 15 topics - 4,021 through 4,035 (of 12,230 total)
You must be logged in to create new topics.