Topics
Started by
Posts
Last post
-- in following "#t" table one can enter b as 10 and e as 2 that means e can be smaller than b and…
15 replies
Folks: I have to extract the date from this string which is between files_ and .xls I have this SEL…
13 replies
I have one question in SQL and would like to take some help from you. I am using the below query to…
2 replies
We have 30 K tables in DB and I have a table which checks the table growth of each table on Daily b…
6 replies
this is my query select PREM_ID, CHAR_TYPE_CD, CHAR_VAL, EFFDT, ADHOC_CHAR_VAL from CI_PREM…
6 replies
I am trying the following code and I'm getting an error that says, Incorrect syntax near '.' DBCC c…
4 replies
I have the following request and I'm not sure how to achieve it SQL. Let's say we have three tables…
11 replies
Good afternoon all, Hopefully you can help, I will admit firstly however that I know barely nothing…
9 replies
i have table please see the screen shot I want the CHAR_TYPE_CD "CNSMP " which ever is the l…
5 replies
Hello, I have this loop which creates a bunch of matrices based on the month_nbr (in this case 1-36…
7 replies
this is my query, which gives me the complains details SELECT * FROM CI_TD_ENTRY TE INNER JOIN CI_T…
3 replies
Hi, I have a table with one of the column [last seen] nvarchar datatype and data imported from .csv…
1 replies
Hi Guys, Here is my "Sample" source data. ID,DKey,SKey,InvType ,PID,PAmount,CAmount,AAmount 1 ,123 …
2 replies
Hi, I am not actually a programming but my job did need to write a bit of sql queries. Hope someone…
2 replies
I am providing DDL to re-create the parent and child tables involved and the DDL is a representatio…
16 replies
Viewing 15 topics - 1,741 through 1,755 (of 1,790 total)
You must be logged in to create new topics.