Topics
Started by
Posts
Last post
What is the "Best way" to lock or block access to a table that is being refreshed? I do this all th…
4 replies
I have a stored procedure (inherited) that I am changing. The procedure calculates Actual and Budge…
1 replies
It takes more then 30 seconds to run DECLARE @intTmpTblCnt INT, @strTmpSql VARCHAR(max)…
4 replies
I have a SQL question as follows and I have difficulty gettting the correct result: Tables: F_Disco…
3 replies
Hello Guys, I have a problem with varbinary. By the way I am a real noob concerning SQL 🙂 In a tabl…
6 replies
Hi Folksl, Does anyone know of the best way of doing this. The table currently has 9 million rows i…
9 replies
Hi, I have next: Select ObjectID, ObjectNumber FROM Objects WHERE ObjectID IN ( 9712 ,9773 ,9785 ,9…
3 replies
I wish to import multiple text files into one table in SQL Server 2008 but I don't have SSIS capabi…
8 replies
Hi I have been pondering this for a while now. All the rest of SQL objects (Views, Procs, Triggers,…
5 replies
I am trying to calculate data for 30 and 90 Days . When I do a select SUM(Charges) Charges, Count(P…
2 replies
We are putting in a new backup system that only takes the block level changes in the backups. We ba…
5 replies
Hi All, I'm just a little confused, when running the query SELECT WEEKDAY(CURDATE( )) FROM dual t…
6 replies
Hi There, I have a SQL script that JOINS three tables. As part of the columns that I return I have …
4 replies
I have a table with the following data SHCOMP CBLNAM SHDESC SHAMT SHTYPE NOTES GROUP 123 …
1 replies
Hi Currently I use this solution, but do you know a best way to do that. thanks CREATE TABLE #mytab…
1 replies
Viewing 15 topics - 976 through 990 (of 5,050 total)
You must be logged in to create new topics.