Topics
Started by
Posts
Last post
Hello everybody, I try to create a stored procedure for paging through a result set. While it works…
12 replies
The SP below will popup an error message when the users of the app leave the "Freight Code" field b…
9 replies
I have a dynamic sql statement that returns an integer value like so. Exec sp_executesql @sql How …
1 replies
Hello, I get incorrect number of records from the following two temp tables below. Can you please …
2 replies
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
Viewing 15 topics - 9,991 through 10,005 (of 12,234 total)
You must be logged in to create new topics.