Topics
Started by
Posts
Last post
Continuing my crusade to tidy up our contacts database, I wanted to write something which would det…
9 replies
OK, so I've nabbed this proper case function from somewhere a little while ago: USE [Preqin] GO /**…
9 replies
This problem is really foxing me and I'm struggling to think of a strategy to solve it, let alone w…
13 replies
I don't know how many people have seen this, but in case no one has, I thought I'd post it. I accid…
2 replies
Hi. I read a post where the issue was similar to my position. I have read up on Crosstab Queries bu…
2 replies
I'm trying to convert the following Oracle PL\SQL to MSSQL 2005 and I'm struggling!! Would anyone h…
18 replies
USE GLPDEMO GO select t.name as TriggerName, ta.name as TableName, o.parent_obj into GLPDemo.dbo.Te…
4 replies
I know you can return 1 datatable with the following to fill an xml file in a web app: select * fro…
5 replies
If i have a dynamic sql query will it take advantage of indexes?
5 replies
Hi, Does anybody know or prove it, what happens with the data base when a JOB (supose that it take…
5 replies
I have a table setup as such labeled - tbl_items: seq account amount disp ---- …
11 replies
Hi All, Please I need your help. Your time is very much appreciated. I will explain it with a simpl…
7 replies
OK, so one can add USE At the top of a script and it will automatically use the DB you have speci…
10 replies
Is there a query or function that will print query results directly to a printer?
3 replies
I am trying to get some more performance out of an existing stored procedure. It uses some dynamic …
9 replies
Viewing 15 topics - 9,991 through 10,005 (of 12,230 total)
You must be logged in to create new topics.