Topics
Started by
Posts
Last post
HI Champs, explain composite index structure and work in sql server ? How B Tree for composite inde…
1 replies
Hey Experts, This recently came up at work and the solution to the problem was utilizing a loop. I…
6 replies
Hi, I have a mix of data in a table as follows: person_id interests 1  &n…
2 replies
TST 1700 If a food product is labeled as fat-free, be cautious about it. These foods may be high in…
1 replies
Hello, I have a problem, ltrim is not working. Here is the scenario I imported data to a table…
5 replies
Hello Everyone, I have a problem, We have different client specific databases with all same Tables,…
3 replies
--input code : CREATE TABLE SumPositiveNegative ( ID INT ) GO INSERT INTO SumPositiveNegati…
5 replies
I'm upgrading an SSIS package from SQL Server 2008 + BIDS to SQL Server 2016 + SSDT. The environm…
6 replies
I have week codes like 201551 , 201552 I want the sql query to return firstday and last day for tho…
3 replies
hi all, i have to following query : DECLARE @latitude float=31.24326 DECLARE @longitude floa…
7 replies
Hi Friends , input code : CREATE TABLE #First_nonzero ( value int ) GO INSERT INTO #First_nonze…
12 replies
I have three users: admin, user2 and user3. User admin is db_owner while user2 and user3 are regula…
2 replies
I have master tblJob (jobid,jobdesc,jobno) Data ----- a212, Painting a213,Plastering a214,windows a…
2 replies
I'm looking for suggestions on creating a table with a list of DBA's and then a Job that will weekl…
8 replies
I am copying contents of 2 csv files to at third one. It works with this command: exec master..xp_…
2 replies
Viewing 15 topics - 3,001 through 3,015 (of 3,042 total)
You must be logged in to create new topics.