Topics
Started by
Posts
Last post
i want to pass datetime to a functon e.g @startdate,@enddate the 2 params would look into…
5 replies
Hi, I'm having problem bulding the right SQL select with tricky conditions. For example, let's say …
4 replies
I need anyones help quering some tables. I have a report process that runs and emails users report …
1 replies
I keep getting the message Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword '…
9 replies
im trying to truncate all the tables in a given database. im writing a sproc to do this ( for tes…
3 replies
How does the performance of the function "MAX(primary_key)" and the SQL statement "SELECT TOP 1 pri…
10 replies
Hi all, One of our tables has got 3 trigger on it. trigger 1,trigger 2,trigger 3 i want to set the…
4 replies
Can you assist me with a query to select, for each machine_id and setting_type_id (group by), the s…
3 replies
alter Procedure testLoad ( @FileName varchar(50), @Logon varchar(20), ) As SET NOCOUNT ON DECLARE @…
4 replies
I have a table with column Enddate defined with datetime datatype. I want to insert the maximum val…
7 replies
Considering the case of a 1 mil. rows table that is constantly accessed (online store scenario), is…
10 replies
I suddenly started receiving this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort…
22 replies
I have a need to remove all CRLFs from a file in my SP. How can I do this? Thanks in advance. PK &n…
2 replies
I have a procedure, the general structure of which is this: declare cursor while(@@fetchstatus -1)…
6 replies
Hi, can someone please let me know how I can code a select statement within a cursor that can selec…
7 replies
Viewing 15 topics - 6,391 through 6,405 (of 17,082 total)
You must be logged in to create new topics.