Topics
Started by
Posts
Last post
Hi Experts, I am running the following query, which deletes around 800 million rows from the table.…
9 replies
Hey, Our fiscal year is May to April. I have this query: selectmax(month(oi.ITEMDATE)) [Month], …
1 replies
Can anyone tell me what I've done wrong with the following function? I suspect it's something obvi…
3 replies
I have created a crosstab query using the Pivot statement that returns the expected results. The r…
6 replies
What would be the proper way to add this to my where clause. This would be in my sales order table …
12 replies
Hi, I have around 3 tables having around 20 to 30gb of data. My table A related to table B by a FK …
3 replies
hi, i have a query i.e. select project, description from table with results chocolate | white choco…
8 replies
Hi I am using sqlserver 2005. We are managing student document like a semester wise mark sh…
1 replies
The following was found as a solution to detecting non-printable characters in a string. I can fin…
3 replies
Hello Friends, I need some help with the following data. The table has three columns with PERSON, A…
2 replies
hello, I am looking for a script, that returns all SPs, which related to a given table, incl. the a…
19 replies
How can i find the primary field name and primary table name of a given foreign key. For example Ta…
4 replies
Hi - I'm working on a join between two tables where I only want one row returned...let me explain! …
9 replies
Hi, I have data in a trace file, and I need to extract some info such as phone number. The problem …
4 replies
Hello All Good Evening, create table deltavalues (planid varchar(10), baseval float, highval float)…
2 replies
Viewing 15 topics - 1,276 through 1,290 (of 10,647 total)
You must be logged in to create new topics.