Topics
Started by
Posts
Last post
Related to another question on how to decipher system tables, I have a need in a script to generate…
3 replies
In our enviroment I write the stored proc's on the server and the developer have a copy of the data…
1 replies
Calling a function from linked SQL Server received error message. SELECT * FROM TSTCMSDB1...usyspro…
7 replies
Why does this: DECLARE @amt money set @amt = ROUND(30088.3200 * 0.0055 / 365 * 31, 2) print cast(@a…
3 replies
My database has two tables. I need to sum two particular fields from each table where there are a …
12 replies
i have a select statement and i want trim down some characters in the result of my data can you ple…
4 replies
Server: Msg 8648, Level 17, State 95, Line 60 Could not insert a row larger than the page size into…
9 replies
Ok, I'm sure this is easy enough to do, but I can't get my head around it. If I have a table - …
1 replies
Hi, I have a trigger that logs modifications (Ins, Upd, Del after). I have a situation where I don'…
5 replies
Hi everybody! I'm trying to create a dynamic name for a table like this: declare @s1 as char(6) set…
2 replies
When we run a select statement on a text field (ex. notes field in the employees table in the north…
9 replies
Hi: Is it legal to combine Action queries with one or more SELECT queries in a single Stored Proced…
9 replies
Is there a way to speed up this query SELECT Convert(char,Ai_InputDate,101) AS iDate, Count(tblAv…
3 replies
Hello, I have a column in the database which contans alpha numeric data as follows. Column ------ A…
1 replies
I am running a stored procedure. I insert records into a temporary table and then manipulate them.…
1 replies
Viewing 15 topics - 16,111 through 16,125 (of 17,082 total)
You must be logged in to create new topics.