Topics
Started by
Posts
Last post
Hello, I was just asked a question by my boss. Is there an advantage to indexing a column if you ar…
11 replies
Hello, I am trying to improve the performance of our weekly reindex job. It is currently…
6 replies
I have the following query that uses @@ROWCOUNT SELECT TOP 1 SampleUnit_ID FROM #Sps IF @@ROWCOU…
7 replies
Hi all Im trying to use a rankorder column to enable users to set the display order of the rows in …
5 replies
the problem for that. If I open the file in excel. EMPLSTS lile 00, 0F make the program conf…
7 replies
Guys, I have stored proc where I try to generate insert - dml statements for bunch of tables. When …
5 replies
Hi everyone, I have a database as follows: Card(CardId bigint, SerialNumber varchar, CardStatusId i…
7 replies
I'm building procs that have 2 optional parameters for accessing data (query by id or guid). My que…
9 replies
Guys I have below snippet of dynamic sql which I run to generate insert statements for bunch of loo…
6 replies
I have the following update query: Update TELEMATCHOUT Set Telephone = CASE WHEN PHONET = '' THEN…
5 replies
Hi There im Trying to create a daily diary and im wondering if there is anything I can do to conca…
14 replies
Hi guys! I have written this SQL statement, which works for Access, but I can't work out the equiva…
2 replies
I'm using opendatasource to centrally table-drive a number of stored procedures. The SPs on remote …
38 replies
We are in the process of changing domain name. Unfortunately I have to then change all the xp…
4 replies
I have a table with single column "Names". Data in the table is -------------------- Name ---- XX Y…
17 replies
Viewing 15 topics - 4,336 through 4,350 (of 17,082 total)
You must be logged in to create new topics.