Topics
Started by
Posts
Last post
Hello, For now while the DBA's correct some issues causing bad data I need to create a bit of a wor…
1 replies
This function uses a Table variable to return a result set. The issue is the db is getting large en…
2 replies
Hello again, Experts, This code below is working great for me when used with MS Access database. Ho…
2 replies
Dear Gurus, I have below mentioned data table and I want retrive Previous flow date for those recor…
8 replies
When a stored procedure creates a temp table #MyTable, the table name in tempdb is made unique by a…
12 replies
By: hester84
A brief description of what I'm trying to do, I have a process that writes the current drive space …
2 replies
hi friends i have faced to two select command with same results. i want to know which one is faster…
12 replies
How can i bring below result Shift st-time end-timd 1 06:00 13:59 2 14:00 21:59 3 …
18 replies
By: KMPSSS
using this: http://www.tek-tips.com/faqs.cfm?fid=4191 executing this sql on that procedure select d…
2 replies
I'm going round in circles on this one, and every time I think I've fixed it, then the error messag…
3 replies
By: LutzM
Hi Everyone, I have a table that contains the login and logout time and here are the following colu…
1 replies
OK, maybe I am missing something here. I was reviewing an forum discussion about ignoring duplicate…
2 replies
I am trying to select records from a large table with millions of records and insert the records in…
8 replies
I have a time dimension table in my master database that I use as a multi-purpose date table. I us…
1 replies
The below script give output for last 7days, I need to modify the script like to pull the data for …
2 replies
Viewing 15 topics - 3,601 through 3,615 (of 12,230 total)
You must be logged in to create new topics.