Topics
Started by
Posts
Last post
Hi I am using sql server 2005, i had two tables PackageCategory CREATE TABLE [dbo].[PackageCatego…
3 replies
How do you set a variable to the results of a function call passing one parameter ie declare @MyVar…
4 replies
Hi, I have a need of exporting the queries output to the different(corresponding query) worksheets …
2 replies
i have a table as below empid orderdateorderid 0001 2010-11-03 00:00:00abcd 0001 2010-11-09…
8 replies
Hi, I'm stuck on a problem where i need to display the date ranges of someone in absent (hollidays …
14 replies
Hello all, I'm having a bit of a problem here. I need a proc that can make a variable number of tem…
8 replies
My tables: if object_id('tempdb.sys.#Table1') is not null drop table #Table1 if object_id('tempdb.…
6 replies
I'm mystified. Please help if you can. This returns data SELECT CONVERT(decimal(6,2),Field1), Fiel…
6 replies
I am trying to write up a scheduling system and am currently stuck on how to determine if two times…
2 replies
I need to write a script to delete any rows where the rec_date is older than 365 days Can anyone h…
26 replies
I am creating queries based on invoicing amounts from a supplier. My problem is that I cannot get t…
3 replies
Hi All, When I try to use bcp command on the server I usually get the below error. BCP.exe is insta…
8 replies
I have a table called Checktimes which has the following records: UserID CheckTime …
2 replies
Hi, Can anyone help pls. I need to delete rows from multiple tables. I cannot use ON CASCADE DELETE…
4 replies
there is a kind of call log table(with 450k rows) I would like to select only the lastest call reco…
19 replies
Viewing 15 topics - 2,431 through 2,445 (of 12,234 total)
You must be logged in to create new topics.