Topics
Started by
Posts
Last post
Hi, I'm trying to figure out how to "conditionally" require a couple of input parameters. Based on…
6 replies
ALTER PROC prodTool.CalculateTaxablePrice --@productId int, --@taxablePrice decimal = 0 AS --IF(EXI…
3 replies
Im using the WITH(INDEX(indexName)) syntax to help me reproduce execution plans purposfully, so as …
4 replies
I have a query SELECT A.SOLD_TO_CUST_ID, C.NAME1, DATEDIFF(DAY, (CONVERT(CHAR(10),B.STATUS_DT,121))…
7 replies
Hi all, I currently have 2 Dbs; lets call them DBLive and DBReport running on the same server. I ha…
4 replies
By: Grinja
Hello all! How can I list all the table's collation in one Database? Some of the columns in the tab…
1 replies
I have some code (included at bottom) which basically does the following: for all dbs in SQLSvr ins…
8 replies
I am looking for a way to insert a value into a string while preserving the order of the string. Fo…
20 replies
Hi Guys Here is my sample table Year Month DoctorNo Expenditure 2000 1 1Q …
6 replies
i have many views which have the following: myview select * from REPORTDB.DELTEK.EMPL I want to r…
23 replies
Hi. I posted previously and NULL kindly provided a solution. Part of the code was as follows: SELE…
5 replies
By: 2Tall
Hi, I have a table that contains about 200,000 records of check information. There might be 5 reco…
2 replies
I have a bunch of normalized tables, and I want to get some MAX() dates with different criteria. D…
3 replies
How can I find out the specific data is existing in which database table. I am looking for all the …
2 replies
By: Lowell
I am trying to find data in a particular field where there are more than 6 characters. The field i…
5 replies
Viewing 15 topics - 7,816 through 7,830 (of 12,234 total)
You must be logged in to create new topics.