Topics
Started by
Posts
Last post
Hi I have a query like this : select x, (SELECT MAX(IL1.[Posting Date]) AS Verkoop FROM [OPS Sepi…
3 replies
Hi gang, Sorry for the vagary in the subject and description, but I couldn't think of a one-liner t…
15 replies
Hi experts, How can i delete data without primary key or specific key , my imagine such as below de…
6 replies
Hi All, Hoping you can help with this one as I'm stumped. I have a 3rd partry db that contains amon…
11 replies
I have a query like the following: Select TableA.*, (Select sum(acres) from p_acres where p_acres.i…
6 replies
hi how can i store text files in fields in a table in a sqlserver's database? please help me very…
1 replies
Hi. If I have a table which stores column descriptions. I need to query other tables based on the …
9 replies
Hello Everyone, How can I add a new column (EMP_MID_NAME) between two existing columns (EMP_FIRST_N…
4 replies
By: noeld
I have two tables in SQL server 2005 Sensors SensorDetails Sensors has two records for sensorID 000…
3 replies
I have a table, which simplified boils down to something like this: Year | Data 1992 string1 1992…
10 replies
I have a table with over a billion rows. I have created another table, that is partitioned and wit…
5 replies
Hi all Is there a more elegant way of doing this? I’m searching a book table on title and being pa…
13 replies
How can I set the date to the current date in the following format: 2008-06-26 00:00:00:000 conver…
3 replies
Hello All Does anyone have any thoughts on how to better optimize this comparison? This query lock…
16 replies
By: harshil
i am using sql server 2005 express edition...how to write a simple query to find the 4th or 3rd max…
4 replies
Viewing 15 topics - 9,586 through 9,600 (of 12,230 total)
You must be logged in to create new topics.