Topics
Started by
Posts
Last post
Hello every1. I have a problem with the following UDF. "create function [dbo].[_some_function] (@po…
6 replies
Hi All Maybe its me being stupid here and I can't see the clear mistake in the code but my percenta…
7 replies
Hi Guys Would the below script be correct if I wanted to list all the Databases in an instance that…
12 replies
I am getting a "Must declare the scalar variable @jobtbl". I don't see what is wrong with the synta…
7 replies
Hi Guys, Need your help. I have A table called [Period] and i have insert,update,deleted trigger on…
5 replies
drop table itemtest create table itemtest (itemid int) go create proc testDynamicSQLCaching @itemi…
4 replies
Hello All, I am moving a few tables from MS Access 2007 to MS SQL Server 2008. Even though the tabl…
2 replies
Hi, I have a query thats runs very very slow . select distinct R.A, R.B, R.C, (SELECT TOP 1 TrWee…
6 replies
I have got a table as below StatementNoLedgerID OpeningBal ClosingBal …
4 replies
can someone point me to a list of non-SARGable expresions?
10 replies
Hi all, I have records under columns as: select top 4 MyColumnName from MyTable MyColumnName LN1, …
9 replies
How to get avg balance amount grouped by CustomerNo. Also I need to name the avg balance as "Final …
5 replies
I am sure what I am doing wrong is very simple, I just cant seem to figure this out. Why does this…
3 replies
Hi, My requirement is as given below: My table contains three columns: start_date,id, prev_date ---…
1 replies
Hi All, i am trying to execute this statement: begin tran update Attributes set EntityId = dbo.Enti…
2 replies
Viewing 15 topics - 7,231 through 7,245 (of 10,635 total)
You must be logged in to create new topics.